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

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

119
120
121
122
123
124
125
126
      String startDate = "2013/10/06";
      int days = -1;
      String expectedWorkDay = "2013/10/04";
    StringEval stringEval = new StringEval(startDate);
    double numberValue = ((NumberEval) WorkdayFunction.instance.evaluate(new ValueEval[]{
                stringEval, new NumberEval(days) }, EC)).getNumberValue();
    assertEquals(expectedWorkDay, formatter.format(DateUtil.getJavaDate(numberValue)));
    }
View Full Code Here
125
126
127
128
129
130
131
    assertEquals(expectedWorkDay, formatter.format(DateUtil.getJavaDate(numberValue)));
    }

    public void testReturnWorkdaysWithDaysTruncated() {
        assertEquals(new Date(109, APRIL, 30), DateUtil.getJavaDate(((NumberEval) WorkdayFunction.instance.evaluate(new ValueEval[]{
                new StringEval(STARTING_DATE), new NumberEval(151.99999) }, EC)).getNumberValue()));
    }
View Full Code Here
130
131
132
133
134
135
136
137
                new StringEval(STARTING_DATE), new NumberEval(151.99999) }, EC)).getNumberValue()));
    }

    public void testReturnRetroativeWorkday() {
        assertEquals(new Date(108, SEPTEMBER, 23), DateUtil.getJavaDate(((NumberEval) WorkdayFunction.instance.evaluate(new ValueEval[]{
                new StringEval(STARTING_DATE), new NumberEval(-5), new StringEval(RETROATIVE_HOLIDAY) }, EC))
                .getNumberValue()));
    }
View Full Code Here
136
137
138
139
140
141
142
143
                .getNumberValue()));
    }

    public void testReturnNetworkdaysWithManyHolidays() {
        assertEquals(new Date(109, MAY, 5), DateUtil.getJavaDate(((NumberEval) WorkdayFunction.instance.evaluate(new ValueEval[]{
                new StringEval(STARTING_DATE), new NumberEval(151),
                new MockAreaEval(FIRST_HOLIDAY, SECOND_HOLIDAY, THIRD_HOLIDAY) }, EC)).getNumberValue()));
    }
View Full Code Here
81
82
83
84
85
86
87
88
        checkValue(49104, 1, 49134d);
    }

    private void checkValue(int startDate, int monthInc, double expectedResult) {
        EDate eDate = new EDate();
        NumberEval result = (NumberEval) eDate.evaluate(new ValueEval[]{new NumberEval(startDate), new NumberEval(monthInc)}, null);
        assertEquals(expectedResult, result.getNumberValue());
    }
View Full Code Here
87
88
89
90
91
92
93
94
        assertEquals(expectedResult, 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
95
96
97
98
99
100
101
102
103
104
105
106
    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
108
109
110
111
112
113
114
115
116
117
118
119
    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
118
119
120
121
122
123
124
125
        assertEquals(resultDate, instance.getTime());
    }
   
    public void testBug56688() {       
        EDate eDate = new EDate();
        NumberEval result = (NumberEval) eDate.evaluate(new ValueEval[]{new NumberEval(1000), new RefEvalImplementation(new NumberEval(0))}, null);
        assertEquals(1000d, result.getNumberValue());
    }
View Full Code Here
124
125
126
127
128
129
130
131
        assertEquals(1000d, result.getNumberValue());
    }

    public void testRefEvalStartDate() {
        EDate eDate = new EDate();
        NumberEval result = (NumberEval) eDate.evaluate(new ValueEval[]{new RefEvalImplementation(new NumberEval(1000)), new NumberEval(0)}, null);
        assertEquals(1000d, result.getNumberValue());
    }
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.