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

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

40
41
42
43
44
45
46
47
48
49
50
51
            if (evals[0] instanceof AreaEval) {
                AreaEval ae = (AreaEval) evals[0];
                rnum = ae.getFirstRow();
            }
            else if (evals[0] instanceof RefEval) {
                RefEval re = (RefEval) evals[0];
                rnum = re.getRow();
            }
            else { // anything else is not valid argument
                retval = ErrorEval.VALUE_INVALID;
            }
            break;
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
93
        ValueEval retval;
        if (ve instanceof StringValueEval) {
            retval = ve;
        }
        else if (ve instanceof RefEval) {
            RefEval re = (RefEval) ve;
            ValueEval ive = re.getInnerValueEval();
            if (ive instanceof StringValueEval) {
                retval = ive;
            }
            else if (ive instanceof BlankEval) {
                retval = ive;
View Full Code Here
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
    if (eval instanceof AreaEval) {
      return (AreaEval) 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.
      // This code only requires the value array item.
      // anything would be ok for rowIx and colIx, but may as well get it right.
      int rowIx = refEval.getRow();
      int colIx = refEval.getColumn();
      AreaPtg ap = new AreaPtg(rowIx, rowIx, colIx, colIx, false, false, false, false);
      ValueEval value = refEval.getInnerValueEval();
      return new Area2DEval(ap, new ValueEval[] { value, });
    }
    throw EvaluationException.invalidValue();
  }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
117
  private double getScalarValue(Eval arg) throws EvalEx {
   
    Eval eval;
    if (arg instanceof RefEval) {
      RefEval re = (RefEval) arg;
      eval = re.getInnerValueEval();
    } else {
      eval = arg;
    }
   
    if (eval == null) {
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
108
  private static double getScalarValue(Eval arg) throws EvaluationException {
   
    Eval eval;
    if (arg instanceof RefEval) {
      RefEval re = (RefEval) arg;
      eval = re.getInnerValueEval();
    } else {
      eval = arg;
    }
   
    if (eval == null) {
View Full Code Here
360
361
362
363
364
365
366
367
368
369
370
371
   * @return a <tt>NumberEval</tt>, <tt>StringEval</tt>, <tt>BoolEval</tt>,
   *  <tt>BlankEval</tt> or <tt>ErrorEval</tt>. Never <code>null</code>.
   */
  private static ValueEval dereferenceValue(ValueEval evaluationResult, int srcRowNum, int srcColNum) {
    if (evaluationResult instanceof RefEval) {
      RefEval rv = (RefEval) evaluationResult;
      return rv.getInnerValueEval();
    }
    if (evaluationResult instanceof AreaEval) {
      AreaEval ae = (AreaEval) evaluationResult;
      if (ae.isRow()) {
        if(ae.isColumn()) {
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
        }
      }
      return;
    }
    if (operand instanceof RefEval) {
      RefEval re = (RefEval) operand;
      collectValue(re.getInnerValueEval(), true, temp);
      return;
    }
    collectValue(operand, false, temp);
  }
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 AreaEval) {
      ValueVector result = LookupUtils.createVector((AreaEval)eval);
      if (result == null) {
        throw new EvaluationException(ErrorEval.NA);
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
42
            case 1:
                 break;
        }
        ValueEval arg = args[0];
        if (arg instanceof RefEval) {
            RefEval re = (RefEval) arg;
            arg = re.getInnerValueEval();
        }

        if (arg instanceof StringEval) {
            // Text values are returned unmodified
            return arg;
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
   */
  private static ValueEval xlateRefEval(RefEval reval) {
    ValueEval retval = reval.getInnerValueEval();

    if (retval instanceof RefEval) {
      RefEval re = (RefEval) retval;
      retval = xlateRefEval(re);
    }

    return retval;
  }
View Full Code Here
TOP

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

  • org.apache.poi.hssf.record.formula.functions.BooleanFunction
  • org.apache.poi.hssf.record.formula.functions.Column
  • org.apache.poi.hssf.record.formula.functions.Count
  • org.apache.poi.hssf.record.formula.functions.Counta
  • org.apache.poi.hssf.record.formula.functions.Countif
  • org.apache.poi.hssf.record.formula.functions.Date
  • org.apache.poi.hssf.record.formula.functions.Index
  • org.apache.poi.hssf.record.formula.functions.Isblank
  • org.apache.poi.hssf.record.formula.functions.Len
  • org.apache.poi.hssf.record.formula.functions.LogicalFunction
    • 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.