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

Example 16 with NumberEval

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

the class TestSumif method testBasic.

public void testBasic() {
    ValueEval[] arg0values = new ValueEval[] { _30, _30, _40, _40, _50, _50 };
    ValueEval[] arg2values = new ValueEval[] { _30, _40, _50, _60, _60, _60 };
    AreaEval arg0;
    AreaEval arg2;
    arg0 = EvalFactory.createAreaEval("A3:B5", arg0values);
    arg2 = EvalFactory.createAreaEval("D1:E3", arg2values);
    confirm(60.0, arg0, new NumberEval(30.0));
    confirm(70.0, arg0, new NumberEval(30.0), arg2);
    confirm(100.0, arg0, new StringEval(">45"));
    confirm(100.0, arg0, new StringEval(">=45"));
    confirm(100.0, arg0, new StringEval(">=50.0"));
    confirm(140.0, arg0, new StringEval("<45"));
    confirm(140.0, arg0, new StringEval("<=45"));
    confirm(140.0, arg0, new StringEval("<=40.0"));
    confirm(160.0, arg0, new StringEval("<>40.0"));
    confirm(80.0, arg0, new StringEval("=40.0"));
}

Example 17 with NumberEval

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

the class TestSumproduct method testMismatchAreaDimensions.

public void testMismatchAreaDimensions() {
    AreaEval aeA = EvalFactory.createAreaEval("A1:A3", new ValueEval[3]);
    AreaEval aeB = EvalFactory.createAreaEval("B1:D1", new ValueEval[3]);
    ValueEval[] args;
    args = new ValueEval[] { aeA, aeB };
    assertEquals(ErrorEval.VALUE_INVALID, invokeSumproduct(args));
    args = new ValueEval[] { aeA, new NumberEval(5) };
    assertEquals(ErrorEval.VALUE_INVALID, invokeSumproduct(args));
}

Example 18 with NumberEval

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

the class TestSumproduct method testScalarSimple.

public void testScalarSimple() {
    RefEval refEval = EvalFactory.createRefEval("A1", new NumberEval(3));
    ValueEval[] args = { refEval, new NumberEval(2) };
    ValueEval result = invokeSumproduct(args);
    confirmDouble(6D, result);
}

Example 19 with NumberEval

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

the class TestSumproduct method testAreaSimple.

public void testAreaSimple() {
    ValueEval[] aValues = { new NumberEval(2), new NumberEval(4), new NumberEval(5) };
    ValueEval[] bValues = { new NumberEval(3), new NumberEval(6), new NumberEval(7) };
    AreaEval aeA = EvalFactory.createAreaEval("A1:A3", aValues);
    AreaEval aeB = EvalFactory.createAreaEval("B1:B3", bValues);
    ValueEval[] args = { aeA, aeB };
    ValueEval result = invokeSumproduct(args);
    confirmDouble(65D, result);
}

Example 20 with NumberEval

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

the class TestText method testTextWithDeciamlFormatSecondArg.

@Test
public void testTextWithDeciamlFormatSecondArg() {
    ValueEval numArg = new NumberEval(321321.321);
    ValueEval formatArg = new StringEval("#,###.00000");
    ValueEval[] args = { numArg, formatArg };
    ValueEval result = TextFunction.TEXT.evaluate(args, -1, (short) -1);
    DecimalFormatSymbols dfs = DecimalFormatSymbols.getInstance(LocaleUtil.getUserLocale());
    char groupSeparator = dfs.getGroupingSeparator();
    char decimalSeparator = dfs.getDecimalSeparator();
    ValueEval testResult = new StringEval("321" + groupSeparator + "321" + decimalSeparator + "32100");
    assertEquals(testResult.toString(), result.toString());
    numArg = new NumberEval(321.321);
    formatArg = new StringEval("00000.00000");
    args[0] = numArg;
    args[1] = formatArg;
    result = TextFunction.TEXT.evaluate(args, -1, (short) -1);
    testResult = new StringEval("00321" + decimalSeparator + "32100");
    assertEquals(testResult.toString(), result.toString());
    formatArg = new StringEval("$#.#");
    args[1] = formatArg;
    result = TextFunction.TEXT.evaluate(args, -1, (short) -1);
    testResult = new StringEval("$321" + decimalSeparator + "3");
    assertEquals(testResult.toString(), result.toString());
}