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

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

352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
    if (eval instanceof BoolEval) {
      BoolEval be = (BoolEval) eval;
      return CellValue.valueOf(be.getBooleanValue());
    }
    if (eval instanceof NumericValueEval) {
      NumericValueEval ne = (NumericValueEval) eval;
      return new CellValue(ne.getNumberValue());
    }
    if (eval instanceof StringValueEval) {
      StringValueEval ne = (StringValueEval) eval;
      return new CellValue(ne.getStringValue());
    }
    if (eval instanceof ErrorEval) {
      return CellValue.getError(((ErrorEval)eval).getErrorCode());
    }
    throw new RuntimeException("Unexpected eval class (" + eval.getClass().getName() + ")");
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
171
    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
443
444
445
446
447
448
449
450
451
452
453
      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
47
48
49
50
51
52
53
54
  }
  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
172
173
174
175
176
177
178
179
180
181
182
183
        temp.add(boolEval.getNumberValue());
      }
      return;
    }
    if (ve instanceof NumericValueEval) {
      NumericValueEval ne = (NumericValueEval) ve;
      temp.add(ne.getNumberValue());
      return;
    }
    if (ve instanceof StringValueEval) {
      if (isViaReference) {
        // ignore all ref strings
View Full Code Here
223
224
225
226
227
228
229
230
231
232
233
      // 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
188
189
190
191
192
193
194
195
196
197
198
199
        temp.add(boolEval.getNumberValue());
      }
      return;
    }
    if (ve instanceof NumericValueEval) {
      NumericValueEval ne = (NumericValueEval) ve;
      temp.add(ne.getNumberValue());
      return;
    }
    if (ve instanceof StringValueEval) {
      if (isViaReference) {
        // ignore all ref strings
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
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
    if (eval instanceof BoolEval) {
      BoolEval be = (BoolEval) eval;
      return CellValue.valueOf(be.getBooleanValue());
    }
    if (eval instanceof NumericValueEval) {
      NumericValueEval ne = (NumericValueEval) eval;
      return new CellValue(ne.getNumberValue());
    }
    if (eval instanceof StringValueEval) {
      StringValueEval ne = (StringValueEval) eval;
      return new CellValue(ne.getStringValue());
    }
    if (eval instanceof ErrorEval) {
      return CellValue.getError(((ErrorEval)eval).getErrorCode());
    }
    throw new RuntimeException("Unexpected eval class (" + eval.getClass().getName() + ")");
View Full Code Here
469
470
471
472
473
474
475
476
477
478
479
      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
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.