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

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

85
86
87
88
89
90
91
92
93
94
95
  /**
   * number of items in array is not limited to 30
   */
  public void testLargeArrays() {
    ValueEval[] yValues = createMockNumberArray(100, 3); // [1,2,0,1,2,0,...,0,1]
    yValues[0] = new NumberEval(2.0); // Changes first element to 2
    ValueEval[] xValues = createMockNumberArray(100, 101); // [1,2,3,4,...,99,100]

    confirm(INTERCEPT, createAreaEval(xValues), createAreaEval(yValues), 51.74384236453202);
    // Excel 2010 gives 51.74384236453200
  }
View Full Code Here
95
96
97
98
99
100
101
102
103
  }

  private ValueEval[] createMockNumberArray(int size, double value) {
    ValueEval[] result = new ValueEval[size];
    for (int i = 0; i < result.length; i++) {
      result[i] = new NumberEval((i+1)%value);
    }
    return result;
  }
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
  }

  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);
View Full Code Here
29
30
31
32
33
34
35
36
public class TestEDate extends TestCase{

    public void testEDateProperValues() {
        EDate eDate = new EDate();
        NumberEval result = (NumberEval) eDate.evaluate(new ValueEval[]{new NumberEval(1000), new NumberEval(0)}, null);
        assertEquals(1000d, result.getNumberValue());
    }
View Full Code Here
35
36
37
38
39
40
41
42
        assertEquals(1000d, result.getNumberValue());
    }

    public void testEDateInvalidValues() {
        EDate eDate = new EDate();
        ErrorEval result = (ErrorEval) eDate.evaluate(new ValueEval[]{new NumberEval(1000)}, null);
        assertEquals(ErrorConstants.ERROR_VALUE, result.getErrorCode());
    }
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
54
    public void testEDateIncrease() {
        EDate eDate = new EDate();
        Date startDate = new Date();
        int offset = 2;
        NumberEval result = (NumberEval) eDate.evaluate(new ValueEval[]{new NumberEval(DateUtil.getExcelDate(startDate)), new NumberEval(offset)}, null);
        Date resultDate = DateUtil.getJavaDate(result.getNumberValue());
        Calendar instance = Calendar.getInstance();
        instance.setTime(startDate);
        instance.add(Calendar.MONTH, offset);
        assertEquals(resultDate, instance.getTime());
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
67
    public void testEDateDecrease() {
        EDate eDate = new EDate();
        Date startDate = new Date();
        int offset = -2;
        NumberEval result = (NumberEval) eDate.evaluate(new ValueEval[]{new NumberEval(DateUtil.getExcelDate(startDate)), new NumberEval(offset)}, null);
        Date resultDate = DateUtil.getJavaDate(result.getNumberValue());
        Calendar instance = Calendar.getInstance();
        instance.setTime(startDate);
        instance.add(Calendar.MONTH, offset);
        assertEquals(resultDate, instance.getTime());
    }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
        assertEquals(ErrorEval.class, result.getClass());
        assertEquals(expectedError.getErrorCode(), ((ErrorEval) result).getErrorCode());
    }

    public void testBasic() {
        ValueEval[] values = { new NumberEval(210.128), new NumberEval(65.2182), new NumberEval(32.231),
                new NumberEval(12.123), new NumberEval(45.32) };
        ValueEval percentile = new NumberEval(0.95);
        confirmPercentile(percentile, values, 181.14604);
    }
View Full Code Here
68
69
70
71
72
73
74
75
76
77
        ValueEval percentile = new NumberEval(0.95);
        confirmPercentile(percentile, values, 181.14604);
    }

    public void testBlanks() {
        ValueEval[] values = { new NumberEval(210.128), new NumberEval(65.2182), new NumberEval(32.231),
                BlankEval.instance, new NumberEval(45.32) };
        ValueEval percentile = new NumberEval(0.95);
        confirmPercentile(percentile, values, 188.39153);
    }
View Full Code Here
75
76
77
78
79
80
81
82
83
        ValueEval percentile = new NumberEval(0.95);
        confirmPercentile(percentile, values, 188.39153);
    }

    public void testUnusualArgs() {
        ValueEval[] values = { new NumberEval(1), new NumberEval(2), BoolEval.TRUE, BoolEval.FALSE };
        ValueEval percentile = new NumberEval(0.95);
        confirmPercentile(percentile, values, 1.95);
    }
View Full Code Here
TOP

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

  • org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator
  • org.apache.poi.ss.examples.formula.CalculateMortgage
  • org.apache.poi.ss.examples.formula.CalculateMortgageFunction
  • org.apache.poi.ss.formula.atp.NetworkdaysFunction
  • org.apache.poi.ss.formula.atp.RandBetween
  • org.apache.poi.ss.formula.atp.TestPercentile
  • org.apache.poi.ss.formula.atp.TestWorkdayFunction
  • org.apache.poi.ss.formula.atp.WorkdayFunction
  • org.apache.poi.ss.formula.atp.YearFrac
  • org.apache.poi.ss.formula.eval.forked.ForkedEvaluator
    • 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.