Examples with NumberEval org.apache.poi.ss.formula.eval.NumberEval used on opensource projects

Example 41 with NumberEval

use of org.apache.poi.ss.formula.eval.NumberEval in project poi by apache.

the class TestWorkdayFunction method testReturnWorkdaysWithDaysTruncated.

@Test
public void testReturnWorkdaysWithDaysTruncated() {
    Calendar expCal = LocaleUtil.getLocaleCalendar(2009, 3, 30);
    Date expDate = expCal.getTime();
    ValueEval[] ve = { new StringEval(STARTING_DATE), new NumberEval(151.99999) };
    double numberValue = ((NumberEval) WorkdayFunction.instance.evaluate(ve, EC)).getNumberValue();
    Date actDate = DateUtil.getJavaDate(numberValue);
    assertEquals(expDate, actDate);
}

Example 42 with NumberEval

use of org.apache.poi.ss.formula.eval.NumberEval in project poi by apache.

the class TestWorkdayFunction method testReturnRetroativeWorkday.

@Test
public void testReturnRetroativeWorkday() {
    Calendar expCal = LocaleUtil.getLocaleCalendar(2008, 8, 23);
    Date expDate = expCal.getTime();
    ValueEval[] ve = { new StringEval(STARTING_DATE), new NumberEval(-5), new StringEval(RETROATIVE_HOLIDAY) };
    double numberValue = ((NumberEval) WorkdayFunction.instance.evaluate(ve, EC)).getNumberValue();
    Date actDate = DateUtil.getJavaDate(numberValue);
    assertEquals(expDate, actDate);
}

Example 43 with NumberEval

use of org.apache.poi.ss.formula.eval.NumberEval in project poi by apache.

the class TestWorkdayFunction method testReturnWorkdays.

@Test
public void testReturnWorkdays() {
    Calendar expCal = LocaleUtil.getLocaleCalendar(2009, 3, 30);
    Date expDate = expCal.getTime();
    ValueEval[] ve = { new StringEval(STARTING_DATE), new NumberEval(151) };
    Date actDate = DateUtil.getJavaDate(((NumberEval) WorkdayFunction.instance.evaluate(ve, EC)).getNumberValue());
    assertEquals(expDate, actDate);
}

Example 44 with NumberEval

use of org.apache.poi.ss.formula.eval.NumberEval in project poi by apache.

the class TestWorkdayFunction method testReturnWorkdaysSpanningAWeekendAddingDays.

@Test
public void testReturnWorkdaysSpanningAWeekendAddingDays() {
    Calendar expCal = LocaleUtil.getLocaleCalendar(2013, 8, 30);
    Date expDate = expCal.getTime();
    ValueEval[] ve = { new StringEval("2013/09/27"), new NumberEval(1) };
    double numberValue = ((NumberEval) WorkdayFunction.instance.evaluate(ve, EC)).getNumberValue();
    assertEquals(41547.0, numberValue, 0);
    Date actDate = DateUtil.getJavaDate(numberValue);
    assertEquals(expDate, actDate);
}

Example 45 with NumberEval

use of org.apache.poi.ss.formula.eval.NumberEval in project poi by apache.

the class TestDec2Bin method testWithZeroPlaces.

public void testWithZeroPlaces() {
    OperationEvaluationContext ctx = createContext();
    ValueEval[] args = new ValueEval[] { ctx.getRefEval(0, 0), new NumberEval(0.0) };
    ValueEval result = new Dec2Bin().evaluate(args, -1, -1);
    assertEquals(ErrorEval.class, result.getClass());
    assertEquals(ErrorEval.NUM_ERROR, result);
}