Package org.apache.poi.ss.formula.eval

Examples of org.apache.poi.ss.formula.eval.ValueEval

110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
  public void testErrors() {
    ValueEval[] xValues = {
        ErrorEval.REF_INVALID,
        new NumberEval(2),
    };
    ValueEval areaEvalX = createAreaEval(xValues);
    ValueEval[] yValues = {
        new NumberEval(2),
        ErrorEval.NULL_INTERSECTION,
    };
    ValueEval areaEvalY = createAreaEval(yValues);
    ValueEval[] zValues = { // wrong size
        new NumberEval(2),
    };
    ValueEval areaEvalZ = createAreaEval(zValues);

    // if either arg is an error, that error propagates
    confirmError(ErrorEval.REF_INVALID, ErrorEval.NAME_INVALID, ErrorEval.REF_INVALID);
    confirmError(areaEvalX, ErrorEval.NAME_INVALID, ErrorEval.NAME_INVALID);
    confirmError(ErrorEval.NAME_INVALID, areaEvalX, ErrorEval.NAME_INVALID);
View Full Code Here
33
34
35
36
37
38
39
40
41
    ValueEval[] args = new ValueEval[] { new StringEval(strText), };
    return new Value().evaluate(args, -1, (short) -1);
  }

  private static void confirmValue(String strText, double expected) {
    ValueEval result = invokeValue(strText);
    assertEquals(NumberEval.class, result.getClass());
    assertEquals(expected, ((NumberEval) result).getNumberValue(), 0.0);
  }
View Full Code Here
39
40
41
42
43
44
45
46
47
    assertEquals(NumberEval.class, result.getClass());
    assertEquals(expected, ((NumberEval) result).getNumberValue(), 0.0);
  }

  private static void confirmValueError(String strText) {
    ValueEval result = invokeValue(strText);
    assertEquals(ErrorEval.class, result.getClass());
    assertEquals(ErrorEval.VALUE_INVALID, result);
  }
View Full Code Here
32
33
34
35
36
37
38
39
40
        ValueEval[] args = new ValueEval[]{new StringEval(numerator), new StringEval(denominator)};
        return new Quotient().evaluate(args, -1, -1);
    }

    private static void confirmValue(String msg, String numerator, String denominator, String expected) {
        ValueEval result = invokeValue(numerator, denominator);
        assertEquals(NumberEval.class, result.getClass());
        assertEquals(msg, expected, ((NumberEval) result).getStringValue());
    }
View Full Code Here
38
39
40
41
42
43
44
45
46
        assertEquals(NumberEval.class, result.getClass());
        assertEquals(msg, expected, ((NumberEval) result).getStringValue());
    }

    private static void confirmValueError(String msg, String numerator, String denominator, ErrorEval numError) {
        ValueEval result = invokeValue(numerator, denominator);
        assertEquals(ErrorEval.class, result.getClass());
        assertEquals(msg, numError, result);
    }
View Full Code Here
32
33
34
35
36
37
38
39
40
        ValueEval[] args = new ValueEval[]{new StringEval(real_num), new StringEval(i_num), new StringEval(suffix)};
        return new Complex().evaluate(args, -1, -1);
    }

    private static void confirmValue(String msg, String real_num, String i_num, String suffix, String expected) {
        ValueEval result = invokeValue(real_num, i_num, suffix);
        assertEquals(StringEval.class, result.getClass());
        assertEquals(msg, expected, ((StringEval) result).getStringValue());
    }
View Full Code Here
38
39
40
41
42
43
44
45
46
        assertEquals(StringEval.class, result.getClass());
        assertEquals(msg, expected, ((StringEval) result).getStringValue());
    }

    private static void confirmValueError(String msg, String real_num, String i_num, String suffix, ErrorEval numError) {
        ValueEval result = invokeValue(real_num, i_num, suffix);
        assertEquals(ErrorEval.class, result.getClass());
        assertEquals(msg, numError, result);
    }
View Full Code Here
38
39
40
41
42
43
44
45
46
    ValueEval[] args = new ValueEval[] { new StringEval(number1), };
    return new Dec2Hex().evaluate(args, -1, -1);
  }

  private static void confirmValue(String msg, String number1, String number2, String expected) {
    ValueEval result = invokeValue(number1, number2);
    assertEquals(StringEval.class, result.getClass());
    assertEquals(msg, expected, ((StringEval) result).getStringValue());
  }
View Full Code Here
44
45
46
47
48
49
50
51
52
    assertEquals(StringEval.class, result.getClass());
    assertEquals(msg, expected, ((StringEval) result).getStringValue());
  }

    private static void confirmValue(String msg, String number1, String expected) {
    ValueEval result = invokeValue(number1);
    assertEquals(StringEval.class, result.getClass());
    assertEquals(msg, expected, ((StringEval) result).getStringValue());
  }
View Full Code Here
50
51
52
53
54
55
56
57
58
    assertEquals(StringEval.class, result.getClass());
    assertEquals(msg, expected, ((StringEval) result).getStringValue());
  }

    private static void confirmValueError(String msg, String number1, String number2, ErrorEval numError) {
        ValueEval result = invokeValue(number1, number2);
        assertEquals(ErrorEval.class, result.getClass());
        assertEquals(msg, numError, result);
    }
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.formula.eval.ValueEval

  • org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator
  • org.apache.poi.hssf.usermodel.TestFormulaEvaluatorBugs
  • org.apache.poi.hssf.usermodel.TestHSSFFormulaEvaluator
  • org.apache.poi.ss.examples.formula.CalculateMortgage
  • org.apache.poi.ss.examples.formula.CalculateMortgageFunction
  • org.apache.poi.ss.formula.atp.ArgumentsEvaluator
  • org.apache.poi.ss.formula.atp.IfError
  • org.apache.poi.ss.formula.atp.NetworkdaysFunction
  • org.apache.poi.ss.formula.atp.ParityFunction
  • org.apache.poi.ss.formula.atp.TestPercentile
    • 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.