Package org.apache.poi.hssf.record.formula.eval

Examples of org.apache.poi.hssf.record.formula.eval.NumberEval

96
97
98
99
100
101
102
103
104
105
    try {
      ValueEval lookupValue = OperandResolver.getSingleValue(arg0, srcRowIndex, srcColumnIndex);
      ValueVector lookupRange = evaluateLookupRange(arg1);
      int index = findIndexOfValue(lookupValue, lookupRange, matchExact, findLargestLessThanOrEqual);
      return new NumberEval(index + 1); // +1 to convert to 1-based
    } catch (EvaluationException e) {
      return e.getErrorEval();
    }
  }
View Full Code Here
88
89
90
91
92
93
94
    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
155
156
157
158
159
160
161
        }
        acc += term;
      }
    }

    return new NumberEval(acc);
  }
View Full Code Here
38
39
40
41
42
43
44
    } else if (arg0 instanceof RefEval) {
      result = 1;
    } else { // anything else is not valid argument
      return ErrorEval.VALUE_INVALID;
    }
    return new NumberEval(result);
  }
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
245
246
247
248
249
250
251
        result = haystack.toUpperCase().indexOf(needle.toUpperCase(), startIndex);
      }
      if (result == -1) {
        return ErrorEval.VALUE_INVALID;
      }
      return new NumberEval(result + 1);
    }
View Full Code Here
43
44
45
46
47
48
49
    try {
      result = evaluate(evalArg(arg0, srcRowIndex, srcColumnIndex), evalArg(arg1, srcRowIndex, srcColumnIndex), evalArg(arg2, srcRowIndex, srcColumnIndex));
    } catch (EvaluationException e) {
      return e.getErrorEval();
    }
    return new NumberEval(result);
  }
View Full Code Here
266
267
268
269
270
271
272
273
    protected NumberLookupComparer(NumberEval ne) {
      super(ne);
      _value = ne.getNumberValue();
    }
    protected CompareResult compareSameType(ValueEval other) {
      NumberEval ne = (NumberEval) other;
      return CompareResult.valueOf(Double.compare(_value, ne.getNumberValue()));
    }
View Full Code Here
213
214
215
216
217
218
219
220
221
222
223
224
          // 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 {
        return false;
      }
      return evaluate(Double.compare(testValue, _value));
    }
View Full Code Here
47
48
49
50
51
52
53
      result = evaluate(getYear(d0), (int) (d1 - 1), (int) d2);
      NumericFunction.checkValue(result);
    } catch (EvaluationException e) {
      return e.getErrorEval();
    }
    return new NumberEval(result);
  }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.record.formula.eval.NumberEval

  • org.apache.poi.hssf.record.formula.atp.YearFrac
  • org.apache.poi.hssf.record.formula.functions.Avedev
  • org.apache.poi.hssf.record.formula.functions.CalendarFieldFunction
  • org.apache.poi.hssf.record.formula.functions.Column
  • org.apache.poi.hssf.record.formula.functions.Columns
  • org.apache.poi.hssf.record.formula.functions.Cosh
  • org.apache.poi.hssf.record.formula.functions.Count
  • org.apache.poi.hssf.record.formula.functions.Counta
  • org.apache.poi.hssf.record.formula.functions.Countblank
  • org.apache.poi.hssf.record.formula.functions.Countif
    • 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.