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

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

203
204
205
206
207
208
209
210
211
212
213
214
          default:
            // never matches (also inconsistent with above three cases).
            // for example '>5' does not match '6',
            return false;
        }
        StringEval se = (StringEval)x;
        Double val = OperandResolver.parseDouble(se.getStringValue());
        if(val == null) {
          // x is text that is not a number
          return false;
        }
        return _value == val.doubleValue();
View Full Code Here
252
253
254
255
256
257
258
259
260
261
262
263
        if (true) { // change to false to observe more intuitive behaviour
          // Note - Unlike with numbers, it seems that COUNTIF never matches
          // boolean values when the target(x) is a string
          return false;
        }
        StringEval se = (StringEval)x;
        Boolean val = parseBoolean(se.getStringValue());
        if(val == null) {
          // x is text that is not a boolean
          return false;
        }
        testValue = boolToInt(val.booleanValue());
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
153
    // Error handling for lookup_range arg is also unusual
    if(eval instanceof NumericValueEval) {
      throw new EvaluationException(ErrorEval.NA);
    }
    if (eval instanceof StringEval) {
      StringEval se = (StringEval) eval;
      Double d = OperandResolver.parseDouble(se.getStringValue());
      if(d == null) {
        // plain string
        throw new EvaluationException(ErrorEval.VALUE_INVALID);
      }
      // else looks like a number
View Full Code Here
168
169
170
171
172
173
174
175
176
177
178
179
    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) {
        // plain string
        throw new EvaluationException(ErrorEval.VALUE_INVALID);
      }
      // if the string parses as a number, it is OK
View Full Code Here
317
318
319
320
321
322
323
324
325
326
327
           switch(srcCell.getCachedFormulaResultType()) {
             case Cell.CELL_TYPE_NUMERIC:
               result = new NumberEval(srcCell.getNumericCellValue());
               break;
             case Cell.CELL_TYPE_STRING:
               result =  new StringEval(srcCell.getStringCellValue());
               break;
             case Cell.CELL_TYPE_BLANK:
               result = BlankEval.instance;
               break;
             case Cell.CELL_TYPE_BOOLEAN:
View Full Code Here
388
389
390
391
392
393
394
395
396
397
398
    int cellType = cell.getCellType();
    switch (cellType) {
      case Cell.CELL_TYPE_NUMERIC:
        return new NumberEval(cell.getNumericCellValue());
      case Cell.CELL_TYPE_STRING:
        return new StringEval(cell.getStringCellValue());
      case Cell.CELL_TYPE_BOOLEAN:
        return BoolEval.valueOf(cell.getBooleanCellValue());
      case Cell.CELL_TYPE_BLANK:
        return BlankEval.instance;
      case Cell.CELL_TYPE_ERROR:
View Full Code Here
647
648
649
650
651
652
653
654
655
656
657
       }
       if (ptg instanceof NumberPtg) {
           return new NumberEval(((NumberPtg)ptg).getValue());
       }
       if (ptg instanceof StringPtg) {
           return new StringEval(((StringPtg) ptg).getValue());
       }
       if (ptg instanceof BoolPtg) {
           return BoolEval.valueOf(((BoolPtg) ptg).getValue());
       }
       if (ptg instanceof ErrPtg) {
View Full Code Here
67
68
69
70
71
72
73
        if (strb.toString().length() > 32767) {
            return ErrorEval.VALUE_INVALID;
        }

        return new StringEval(strb.toString());
    }
View Full Code Here
109
110
111
112
113
114
115
        //If DEC2BIN requires more than places characters, it returns the #NUM! error value.
        if (binary.length() > placesNumber) {
            return ErrorEval.NUM_ERROR;
        }

        return new StringEval(binary);
    }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
        }
        if (number > 3999) {
            return ErrorEval.VALUE_INVALID;
        }
        if (number == 0) {
            return new StringEval("");
        }

        int form = 0;
        try {
            ValueEval ve = OperandResolver.getSingleValue(formVE, srcRowIndex, srcColumnIndex);
            form = OperandResolver.coerceValueToInt(ve);
        } catch (EvaluationException e) {
            return ErrorEval.NUM_ERROR;
        }

        if (form > 4 || form < 0) {
            return ErrorEval.VALUE_INVALID;
        }

        String result = this.integerToRoman(number);

        if (form == 0) {
            return new StringEval(result);
        }

        return new StringEval(makeConcise(result, form));
    }
View Full Code Here
TOP

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

  • org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator
  • org.apache.poi.ss.formula.atp.TestNetworkdaysFunction
  • org.apache.poi.ss.formula.atp.TestNetworkdaysFunction$MockAreaEval
  • org.apache.poi.ss.formula.atp.TestWorkdayFunction
  • org.apache.poi.ss.formula.atp.TestWorkdayFunction$MockAreaEval
  • org.apache.poi.ss.formula.BaseTestExternalFunctions$MyFunc
  • org.apache.poi.ss.formula.BaseTestExternalFunctions$MyFunc2
  • org.apache.poi.ss.formula.eval.forked.ForkedEvaluator
  • org.apache.poi.ss.formula.functions.Complex
  • org.apache.poi.ss.formula.functions.Countif$BooleanMatcher
    • 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.