@Test public void testPerformMinuteRounding() { BigDecimal[][] test = { // =MINUTE(timevalue("00:00:59")) new BigDecimal[] { new BigDecimal( 0.9833333333333333333333333333333333333760 ), new BigDecimal( 0 ) }, // =MINUTE(timevalue("00:01:00")) =MINUTE("00:01:00") =MINUTE(1/(24*60)) new BigDecimal[] { new BigDecimal( 0.9999999999999999999999999999999999999360 ), new BigDecimal( 1 ) }, // =MINUTE(timevalue("00:01:59")) new BigDecimal[] { new BigDecimal( 1.9833333333333333333333333333333333333120 ), new BigDecimal( 1 ) }, // =MINUTE(timevalue("00:07:00")) new BigDecimal[] { new BigDecimal( 6.9999999999999999999999999999999999999840 ), new BigDecimal( 7 ) }, // =MINUTE(timevalue("00:09:00")) new BigDecimal[] { new BigDecimal( 9.0000000000000000000000000000000000000000 ), new BigDecimal( 9 ) }, // =MINUTE(timevalue("00:11:00")) new BigDecimal[] { new BigDecimal( 11.9833333333333333333333333333333333333920 ), new BigDecimal( 11 ) }, // =MINUTE(timevalue("00:23:00")) new BigDecimal[] { new BigDecimal( 22.9999999999999999999999999999999999999680 ), new BigDecimal( 23 ) }, // =MINUTE(timevalue("00:28:59")) new BigDecimal[] { new BigDecimal( 28.9833333333333333333333333333333333333120 ), new BigDecimal( 28 ) } }; for ( BigDecimal[] bigDecimal : test ) { BigDecimal result = NumberUtil.performMinuteRounding( bigDecimal[ 0 ] ); assertEquals( bigDecimal[ 1 ], result ); } } }
public TypeValuePair evaluate( final FormulaContext context, final ParameterCallback parameters ) throws EvaluationException { if ( parameters.getParameterCount() != 1 ) { throw EvaluationException.getInstance( LibFormulaErrorValue.ERROR_ARGUMENTS_VALUE ); } final TypeRegistry typeRegistry = context.getTypeRegistry(); final Number n = typeRegistry.convertToNumber( parameters.getType( 0 ), parameters.getValue( 0 ) ); if ( n == null ) { throw EvaluationException.getInstance( LibFormulaErrorValue.ERROR_INVALID_ARGUMENT_VALUE ); } // calculation is as follows // time * 24 so that we get the full hours (which we remove later) final BigDecimal bd = NumberUtil.getAsBigDecimal( n ); final BigDecimal hours = bd.multiply( HOURS ); final BigDecimal dayAndHoursAsInt = new BigDecimal( NumberUtil.performIntRounding( hours ).intValue() ); final BigDecimal minutesFraction = hours.subtract( dayAndHoursAsInt ); // Multiply the minutes with 60 to get the minutes as ints final BigDecimal minutes = minutesFraction.multiply( MINUTES ); // Fix for PRD-5499, contributed by Lionel Elie Mamane // final BigDecimal minutesAsInt = minutes.setScale( 0, BigDecimal.ROUND_HALF_UP ); final BigDecimal minutesAsInt = NumberUtil.performMinuteRounding( minutes ); return new TypeValuePair( NumberType.GENERIC_NUMBER, minutesAsInt ); } }