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

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

130
131
132
133
134
135
136
137
                new StringEval(STARTING_DATE.toString()), 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.toString()), new NumberEval(-5), new StringEval(RETROATIVE_HOLIDAY.toString()) }, 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.toString()), new NumberEval(151),
                new MockAreaEval(FIRST_HOLIDAY, SECOND_HOLIDAY, THIRD_HOLIDAY) }, EC)).getNumberValue()));
    }
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
222
          // x is text that is not a number
          return false;
        }
        return _value == val.doubleValue();
      } else if((x instanceof NumberEval)) {
        NumberEval ne = (NumberEval) x;
        testValue = ne.getNumberValue();
            } else if((x instanceof BlankEval)) {
                switch (getCode()) {
                    case CmpOp.NE:
                        // Excel counts blank values in range as not equal to any value. See Bugzilla 51498
                        return true;
View Full Code Here
94
95
96
97
98
99
100
    }

    if (Double.isNaN(d) || Double.isInfinite(d))
      return ErrorEval.NUM_ERROR;

    return new NumberEval(d);
  }
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
51
52
53
        }
        for (int i = 0; i < args.length; ) {
            ValueEval firstArg = args[i];
            ValueEval secondArg = args[i + 1];
            i += 2;
            NumberEval evaluate = (NumberEval) new Countif().evaluate(new ValueEval[]{firstArg, secondArg}, ec.getRowIndex(), ec.getColumnIndex());
            if (result == null) {
                result = evaluate.getNumberValue();
            } else if (evaluate.getNumberValue() < result) {
                result = evaluate.getNumberValue();
            }
        }
        return new NumberEval(result == null ? 0 : result);
    }
View Full Code Here
89
90
91
92
93
94
95
    double term = 1D;
    for(int n=0; n<maxN; n++) {
      double val = getScalarValue(evalArgs[n]);
      term *= val;
    }
    return new NumberEval(term);
  }
View Full Code Here
159
160
161
162
163
164
165
        }
        acc += term;
      }
    }

    return new NumberEval(acc);
  }
View Full Code Here
78
79
80
81
82
83
84
            sum++;

            value = "-" + String.valueOf(sum);
        }

        return new NumberEval(Long.parseLong(value));
    }
View Full Code Here
86
87
88
89
90
91
92
      }
      result = evaluate(values);
    } catch (EvaluationException e) {
      return e.getErrorEval();
    }
    return new NumberEval(result);
  }
View Full Code Here
94
95
96
97
98
99
100
    }

    if (Double.isNaN(d) || Double.isInfinite(d))
      return ErrorEval.NUM_ERROR;

    return new NumberEval(d);
  }
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.