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

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

59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
        }
        if(arg instanceof BlankEval) {
            return 0;
        }
        if (arg instanceof RefEval) {
            RefEval refEval = (RefEval)arg;
            if (refEval.getNumberOfSheets() > 1) {
                // Multi-Sheet references are not supported
                throw new EvaluationException(ErrorEval.VALUE_INVALID);
            }
           
            ValueEval innerValueEval = refEval.getInnerValueEval(refEval.getFirstSheetIndex());
            if(innerValueEval instanceof NumberEval) {
                return ((NumberEval) innerValueEval).getNumberValue();
            }
            if(innerValueEval instanceof BlankEval) {
                return 0;
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
45
    public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0) {
        ValueEval arg = arg0;
        if (arg instanceof RefEval) {
            // always use the first sheet
            RefEval re = (RefEval)arg;
            arg = re.getInnerValueEval(re.getFirstSheetIndex());
        } else if (arg instanceof AreaEval) {
            // when the arg is an area, choose the top left cell
            arg = ((AreaEval) arg).getRelativeValue(0, 0);
        }
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
133
    }
  }

  private static ValueVector evaluateLookupRange(ValueEval eval) throws EvaluationException {
    if (eval instanceof RefEval) {
      RefEval re = (RefEval) eval;
      return new SingleValueVector(re.getInnerValueEval());
    }
    if (eval instanceof TwoDEval) {
      ValueVector result = LookupUtils.createVector((TwoDEval)eval);
      if (result == null) {
        throw new EvaluationException(ErrorEval.NA);
View Full Code Here
393
394
395
396
397
398
399
400
401
402
403
404
405
    if (eval instanceof TwoDEval) {
      return (TwoDEval) eval;
    }

    if(eval instanceof RefEval) {
      RefEval refEval = (RefEval) eval;
      // Make this cell ref look like a 1x1 area ref.

      // It doesn't matter if eval is a 2D or 3D ref, because that detail is never asked of AreaEval.
      return refEval.offset(0, 0, 0, 0);
    }
    throw EvaluationException.invalidValue();
  }
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
        }
      }
      return;
    }
    if (operand instanceof RefEval) {
      RefEval re = (RefEval) operand;
      collectValue(re.getInnerValueEval(), true, temp);
      return;
    }
    collectValue(operand, false, temp);
  }
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
  private static double getScalarValue(ValueEval arg) throws EvaluationException {

    ValueEval eval;
    if (arg instanceof RefEval) {
      RefEval re = (RefEval) arg;
      if (re.getNumberOfSheets() > 1) {
                throw new EvaluationException(ErrorEval.VALUE_INVALID);
      }
      eval = re.getInnerValueEval(re.getFirstSheetIndex());
    } else {
      eval = arg;
    }

    if (eval == null) {
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
114
115
        }
      }
      return;
    }
    if (arg instanceof RefEval) {
      RefEval re = (RefEval) arg;
      for (int sIx = re.getFirstSheetIndex(); sIx <= re.getLastSheetIndex(); sIx++) {
          collectValue(re.getInnerValueEval(sIx), temp, true);
      }
      return;
    }
    collectValue(arg, temp, true);
View Full Code Here
168
169
170
171
172
173
174
175
176
177
178
179
180
        }
      }
      return;
    }
    if (operand instanceof RefEval) {
      RefEval re = (RefEval) operand;
      for (int sIx = re.getFirstSheetIndex(); sIx <= re.getLastSheetIndex(); sIx++) {
          collectValue(re.getInnerValueEval(sIx), true, temp);
      }
      return;
    }
    collectValue(operand, false, temp);
  }
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
133
134
    }
  }

  private static ValueVector evaluateLookupRange(ValueEval eval) throws EvaluationException {
    if (eval instanceof RefEval) {
      RefEval re = (RefEval) eval;
      if (re.getNumberOfSheets() == 1) {
          return new SingleValueVector(re.getInnerValueEval(re.getFirstSheetIndex()));
      } else {
          return LookupUtils.createVector(re);
      }
    }
    if (eval instanceof TwoDEval) {
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
89
90
          }
        }
        continue;
      }
            if (arg instanceof RefEval) {
                RefEval re = (RefEval) arg;
                for (int sIx = re.getFirstSheetIndex(); sIx <= re.getLastSheetIndex(); sIx++) {
                    ValueEval ve = re.getInnerValueEval(sIx);
                    tempVe = OperandResolver.coerceValueToBoolean(ve, true);
                    if (tempVe != null) {
                        result = partialEvaluate(result, tempVe.booleanValue());
                        atleastOneNonBlank = true;
                    }
View Full Code Here
TOP

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

  • org.apache.poi.ss.formula.functions.BooleanFunction
  • org.apache.poi.ss.formula.functions.EDate
  • org.apache.poi.ss.formula.functions.LookupUtils
  • org.apache.poi.ss.formula.functions.Match
  • org.apache.poi.ss.formula.functions.Mode
  • org.apache.poi.ss.formula.functions.MultiOperandNumericFunction
  • org.apache.poi.ss.formula.functions.Sumproduct
  • org.apache.poi.ss.formula.functions.T
  • org.apache.poi.ss.formula.functions.TestMid
  • 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.