Package org.apache.poi.hssf.record.formula.eval

Examples of org.apache.poi.hssf.record.formula.eval.Eval

43
44
45
46
47
48
49
50
51
    assertEquals(StringEval.class, result.getClass());
    assertEquals(expected, ((StringEval)result).getStringValue());
  }

  private void confirmTrim(Eval text, ErrorEval expectedError) {
    Eval result = invokeTrim(text);
    assertEquals(ErrorEval.class, result.getClass());
    assertEquals(expectedError.getErrorCode(), ((ErrorEval)result).getErrorCode());
  }
View Full Code Here
39
40
41
42
43
44
45
46
47
    Eval[] args = new Eval[] { xArray, yArray, };
    return function.evaluate(args, -1, (short)-1);
  }

  private void confirm(Function function, Eval xArray, Eval yArray, double expected) {
    Eval result = invoke(function, xArray, yArray);
    assertEquals(NumberEval.class, result.getClass());
    assertEquals(expected, ((NumberEval)result).getNumberValue(), 0);
  }
View Full Code Here
44
45
46
47
48
49
50
51
52
    Eval result = invoke(function, xArray, yArray);
    assertEquals(NumberEval.class, result.getClass());
    assertEquals(expected, ((NumberEval)result).getNumberValue(), 0);
  }
  private void confirmError(Function function, Eval xArray, Eval yArray, ErrorEval expectedError) {
    Eval result = invoke(function, xArray, yArray);
    assertEquals(ErrorEval.class, result.getClass());
    assertEquals(expectedError.getErrorCode(), ((ErrorEval)result).getErrorCode());
  }
View Full Code Here
53
54
55
56
57
58
59
60
    RefEval refEval = new Ref2DEval(new ReferencePtg("A1"), new NumberEval(3));
    Eval[] args = {
      refEval,
      new NumberEval(2),
    };
    Eval result = invokeSumproduct(args);
    confirmDouble(6D, result);
  }
View Full Code Here
72
73
74
75
76
77
78
79
    bValues[0] = new NumberEval(3);
    bValues[1] = new NumberEval(6);
    bValues[2] = new NumberEval(7);
   
    Eval[] args = { aeA, aeB, };
    Eval result = invokeSumproduct(args);
    confirmDouble(65D, result);
  }
View Full Code Here
88
89
90
91
92
93
94
95
   
    Eval[] args = {
        ae,
        new NumberEval(2),
      };
    Eval result = invokeSumproduct(args);
    confirmDouble(14D, result);
  }
View Full Code Here
37
38
39
40
41
42
43
44
45
    Eval[] args = new Eval[] { text, };
    return new Len().evaluate(args, -1, (short)-1);
  }

  private void confirmLen(Eval text, int expected) {
    Eval result = invokeLen(text);
    assertEquals(NumberEval.class, result.getClass());
    assertEquals(expected, ((NumberEval)result).getNumberValue(), 0);
  }
View Full Code Here
43
44
45
46
47
48
49
50
51
    assertEquals(NumberEval.class, result.getClass());
    assertEquals(expected, ((NumberEval)result).getNumberValue(), 0);
  }

  private void confirmLen(Eval text, ErrorEval expectedError) {
    Eval result = invokeLen(text);
    assertEquals(ErrorEval.class, result.getClass());
    assertEquals(expectedError.getErrorCode(), ((ErrorEval)result).getErrorCode());
  }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
  /**
   * Formats nicer error messages for the junit output
   */
  private static double invokeInternal(Object target, Eval[] args, int srcCellRow, int srcCellCol)
        throws NumericEvalEx {
    Eval evalResult;
    // TODO - make OperationEval extend Function
    if (target instanceof Function) {
      Function ff = (Function) target;
      evalResult = ff.evaluate(args, srcCellRow, (short)srcCellCol);
    } else {
      OperationEval ff = (OperationEval) target;
      evalResult = ff.evaluate(args, srcCellRow, (short)srcCellCol);
    }
   
    if(evalResult == null) {
      throw new NumericEvalEx("Result object was null");
    }
    if(evalResult instanceof ErrorEval) {
      ErrorEval ee = (ErrorEval) evalResult;
      throw new NumericEvalEx(formatErrorMessage(ee));
    }
    if(!(evalResult instanceof NumericValueEval)) {
      throw new NumericEvalEx("Result object type (" + evalResult.getClass().getName()
          + ") is invalid.  Expected implementor of ("
          + NumericValueEval.class.getName() + ")");
    }
   
    NumericValueEval result = (NumericValueEval) evalResult;
View Full Code Here
30
31
32
33
34
35
36
37
38
39
* @author Josh Micich
*/
public final class TestRoundFuncs extends TestCase {
  public void testRounddownWithStringArg() {
   
    Eval strArg = new StringEval("abc");
    Eval[] args = { strArg, new NumberEval(2), };
    Eval result = new Rounddown().evaluate(args, -1, (short)-1);
    assertEquals(ErrorEval.VALUE_INVALID, result);
  }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.record.formula.eval.Eval

  • org.apache.poi.hssf.record.formula.functions.BooleanFunction
  • org.apache.poi.hssf.record.formula.functions.Columns
  • org.apache.poi.hssf.record.formula.functions.Countif
  • org.apache.poi.hssf.record.formula.functions.Hlookup
  • org.apache.poi.hssf.record.formula.functions.If
  • org.apache.poi.hssf.record.formula.functions.Index
  • org.apache.poi.hssf.record.formula.functions.Isblank
  • org.apache.poi.hssf.record.formula.functions.Islogical
  • org.apache.poi.hssf.record.formula.functions.Isnontext
  • org.apache.poi.hssf.record.formula.functions.Isnumber
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.