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

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

355
356
357
358
359
360
361
362
363
364
365
366
    if (eval instanceof NumberEval) {
      NumberEval ne = (NumberEval) eval;
      return new CellValue(ne.getNumberValue());
    }
    if (eval instanceof BoolEval) {
      BoolEval be = (BoolEval) eval;
      return CellValue.valueOf(be.getBooleanValue());
    }
    if (eval instanceof StringEval) {
      StringEval ne = (StringEval) eval;
      return new CellValue(ne.getStringValue());
    }
View Full Code Here
265
266
267
268
269
270
271
272
273
274
275
276
    if (eval instanceof NumberEval) {
      NumberEval ne = (NumberEval) eval;
      return new CellValue(ne.getNumberValue());
    }
    if (eval instanceof BoolEval) {
      BoolEval be = (BoolEval) eval;
      return CellValue.valueOf(be.getBooleanValue());
    }
    if (eval instanceof StringEval) {
      StringEval ne = (StringEval) eval;
      return new CellValue(ne.getStringValue());
    }
View Full Code Here
254
255
256
257
258
259
260
261
262
263
264
265
          // x is text that is not a boolean
          return false;
        }
        testValue = boolToInt(val.booleanValue());
      } else if((x instanceof BoolEval)) {
        BoolEval be = (BoolEval) x;
        testValue = boolToInt(be.getBooleanValue());
      } else {
        return false;
      }
      return evaluate(testValue - _value);
    }
View Full Code Here
260
261
262
263
264
265
266
267
268
269
270
271
          // x is text that is not a boolean
          return false;
        }
        testValue = boolToInt(val.booleanValue());
      } else if((x instanceof BoolEval)) {
        BoolEval be = (BoolEval) x;
        testValue = boolToInt(be.getBooleanValue());
            } 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
269
270
271
272
273
274
275
276
277
278
279
280
    if (eval instanceof NumberEval) {
      NumberEval ne = (NumberEval) eval;
      return new CellValue(ne.getNumberValue());
    }
    if (eval instanceof BoolEval) {
      BoolEval be = (BoolEval) eval;
      return CellValue.valueOf(be.getBooleanValue());
    }
    if (eval instanceof StringEval) {
      StringEval ne = (StringEval) eval;
      return new CellValue(ne.getStringValue());
    }
View Full Code Here
348
349
350
351
352
353
354
355
356
357
358
359
   * @param cell
   */
  private CellValue evaluateFormulaCellValue(Cell cell) {
    ValueEval eval = _bookEvaluator.evaluate(new HSSFEvaluationCell((HSSFCell)cell));
    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());
    }
View Full Code Here
418
419
420
421
422
423
424
425
426
427
428
429
      // this does not get the default value
      return false;
    }
    if(valEval instanceof BoolEval) {
      // Happy day flow
      BoolEval boolEval = (BoolEval) valEval;
      return boolEval.getBooleanValue();
    }

    if (valEval instanceof StringEval) {
      String stringValue = ((StringEval) valEval).getStringValue();
      if(stringValue.length() < 1) {
View Full Code Here
309
310
311
312
313
314
315
316
317
318
319
320
    protected BooleanLookupComparer(BoolEval be) {
      super(be);
      _value = be.getBooleanValue();
    }
    protected CompareResult compareSameType(ValueEval other) {
      BoolEval be = (BoolEval) other;
      boolean otherVal = be.getBooleanValue();
      if(_value == otherVal) {
        return CompareResult.EQUAL;
      }
      // TRUE > FALSE
      if(_value) {
View Full Code Here
260
261
262
263
264
265
266
267
268
269
270
271
          // x is text that is not a boolean
          return false;
        }
        testValue = boolToInt(val.booleanValue());
      } else if((x instanceof BoolEval)) {
        BoolEval be = (BoolEval) x;
        testValue = boolToInt(be.getBooleanValue());
            } 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
166
167
168
169
170
171
172
173
174
175
176
177
    if (ve == null) {
      throw new IllegalArgumentException("ve must not be null");
    }
    if (ve instanceof BoolEval) {
      if (!isViaReference || _isReferenceBoolCounted) {
        BoolEval boolEval = (BoolEval) ve;
        temp.add(boolEval.getNumberValue());
      }
      return;
    }
    if (ve instanceof NumericValueEval) {
      NumericValueEval ne = (NumericValueEval) ve;
View Full Code Here
TOP

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

  • org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator
  • org.apache.poi.ss.formula.functions.Countif$BooleanMatcher
  • org.apache.poi.ss.formula.functions.LookupUtils
  • org.apache.poi.ss.formula.functions.LookupUtils$BooleanLookupComparer
  • org.apache.poi.ss.formula.functions.MultiOperandNumericFunction
  • org.apache.poi.ss.formula.TestEvaluationCache$EvalListener
  • org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator
    • 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.