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

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

50
51
52
53
54
55
56
57
  }
  private static void confirmInt(int expected, ValueEval actualEval) {
    if(!(actualEval instanceof NumericValueEval)) {
      fail("Expected numeric result");
    }
    NumericValueEval nve = (NumericValueEval)actualEval;
    assertEquals(expected, nve.getNumberValue(), 0);
  }
View Full Code Here
164
165
166
167
168
169
170
171
172
173
174
175
    if(match_type instanceof ErrorEval) {
      throw new EvaluationException((ErrorEval)match_type);
    }
    if(match_type instanceof NumericValueEval) {
      NumericValueEval ne = (NumericValueEval) match_type;
      return ne.getNumberValue();
    }
    if (match_type instanceof StringEval) {
      StringEval se = (StringEval) match_type;
      Double d = OperandResolver.parseDouble(se.getStringValue());
      if(d == null) {
View Full Code Here
446
447
448
449
450
451
452
453
454
455
456
      throw EvaluationException.invalidValue();
      // This is in contrast to the code below,, where NumberEvals values (for
      // example 0.01) *do* resolve to equivalent boolean values.
    }
    if (valEval instanceof NumericValueEval) {
      NumericValueEval nve = (NumericValueEval) valEval;
      // zero is FALSE, everything else is TRUE
      return 0.0 != nve.getNumberValue();
    }
    throw new RuntimeException("Unexpected eval type (" + valEval.getClass().getName() + ")");
  }
View Full Code Here
42
43
44
45
46
47
48
49
  }
  private static void confirmDouble(double expected, ValueEval actualEval) {
    if(!(actualEval instanceof NumericValueEval)) {
      throw new AssertionFailedError("Expected numeric result");
    }
    NumericValueEval nve = (NumericValueEval)actualEval;
    assertEquals(expected, nve.getNumberValue(), 0);
  }
View Full Code Here
39
40
41
42
43
44
45
46
  }
  private static void confirmDouble(double expected, ValueEval actualEval) {
    if(!(actualEval instanceof NumericValueEval)) {
      fail("Expected numeric result");
    }
    NumericValueEval nve = (NumericValueEval)actualEval;
    assertEquals(expected, nve.getNumberValue(), 0);
  }
View Full Code Here
46
47
48
49
50
51
52
53
  }
  private static void confirmInt(int expected, ValueEval actualEval) {
    if(!(actualEval instanceof NumericValueEval)) {
      fail("Expected numeric result");
    }
    NumericValueEval nve = (NumericValueEval)actualEval;
    assertEquals(expected, nve.getNumberValue(), 0);
  }
View Full Code Here
42
43
44
45
46
47
48
49
  }
  private static void confirmDouble(double expected, ValueEval actualEval) {
    if(!(actualEval instanceof NumericValueEval)) {
      throw new AssertionFailedError("Expected numeric result");
    }
    NumericValueEval nve = (NumericValueEval)actualEval;
    assertEquals(expected, nve.getNumberValue(), 0);
  }
View Full Code Here
413
414
415
416
417
418
419
420
421
422
423
      throw EvaluationException.invalidValue();
      // This is in contrast to the code below,, where NumberEvals values (for
      // example 0.01) *do* resolve to equivalent boolean values.
    }
    if (valEval instanceof NumericValueEval) {
      NumericValueEval nve = (NumericValueEval) valEval;
      // zero is FALSE, everything else is TRUE
      return 0.0 != nve.getNumberValue();
    }
    throw new RuntimeException("Unexpected eval type (" + valEval.getClass().getName() + ")");
  }
View Full Code Here
220
221
222
223
224
225
226
227
228
229
230
      // Note for area SUMPRODUCTs, string values are interpreted as zero
      // even if they would parse as valid numeric values
      return 0;
    }
    if(ve instanceof NumericValueEval) {
      NumericValueEval nve = (NumericValueEval) ve;
      return nve.getNumberValue();
    }
    throw new RuntimeException("Unexpected value eval class ("
        + ve.getClass().getName() + ")");
  }
View Full Code Here
163
164
165
166
167
168
169
170
171
172
173
174
    if(match_type instanceof ErrorEval) {
      throw new EvaluationException((ErrorEval)match_type);
    }
    if(match_type instanceof NumericValueEval) {
      NumericValueEval ne = (NumericValueEval) match_type;
      return ne.getNumberValue();
    }
    if (match_type instanceof StringEval) {
      StringEval se = (StringEval) match_type;
      Double d = OperandResolver.parseDouble(se.getStringValue());
      if(d == null) {
View Full Code Here
TOP

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

  • org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator
  • org.apache.poi.ss.formula.functions.LookupUtils
  • org.apache.poi.ss.formula.functions.Match
  • org.apache.poi.ss.formula.functions.MultiOperandNumericFunction
  • org.apache.poi.ss.formula.functions.NumericFunctionInvoker
  • org.apache.poi.ss.formula.functions.Sumproduct
  • org.apache.poi.ss.formula.functions.TestMatch
  • org.apache.poi.ss.formula.functions.TestSumif
  • org.apache.poi.ss.formula.functions.TestSumproduct
    • 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.