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

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

146
147
148
149
150
151
152
153
154
155
156
        }
      }
      return;
    }
    if (operand instanceof RefEval) {
      RefEval re = (RefEval) operand;
      collectValue(re.getInnerValueEval(), true, temp);
      return;
    }
    collectValue((ValueEval)operand, false, temp);
  }
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
134
    }
  }

  private static ValueVector evaluateLookupRange(Eval 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
366
367
368
369
370
371
372
373
374
375
376
377
378
    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.
      return refEval.offset(0, 0, 0, 0);
    }
    throw EvaluationException.invalidValue();
  }
View Full Code Here
444
445
446
447
448
449
450
451
452
453
454
455
   * @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, short 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
66
67
68
69
70
71
72
73
74
75
76
77
        if (eval instanceof AreaEval) {
            AreaEval ae = (AreaEval) eval;
            return countAreaEval(ae);
        }
        if (eval instanceof RefEval) {
            RefEval refEval = (RefEval)eval;
      return countValue(refEval.getInnerValueEval());
        }
        if (eval instanceof NumberEval) {
            return 1;
        }
        if (eval instanceof StringEval) {
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
112
    }
  }

  private static ValueEval[] evaluateLookupRange(Eval eval) throws EvaluationException {
    if (eval instanceof RefEval) {
      RefEval re = (RefEval) eval;
      return new ValueEval[] { re.getInnerValueEval(), };
    }
    if (eval instanceof AreaEval) {
      AreaEval ae = (AreaEval) eval;
      if(!ae.isColumn() && !ae.isRow()) {
        throw new EvaluationException(ErrorEval.NA);
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
77
        if (eval instanceof AreaEval) {
            AreaEval ae = (AreaEval) eval;
            return countAreaEval(ae);
        }
        if (eval instanceof RefEval) {
            RefEval refEval = (RefEval)eval;
      return countValue(refEval.getInnerValueEval());
        }
        if (eval instanceof NumberEval) {
            return 1;
        }
   
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
   */
  private static int convertIndexArgToZeroBase(Eval ev) {
    NumberEval ne;
    if(ev instanceof RefEval) {
      // TODO - write junit to justify this
      RefEval re = (RefEval) ev;
      ne = (NumberEval) re.getInnerValueEval();
    } else {
      ne = (NumberEval)ev;
    }
   
    return (int)ne.getNumberValue() - 1;
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
                 * For now this is a tempfix solution since this may
                 * require a more generic fix at the level of
                 * HSSFFormulaEvaluator where we store an array
                 * of RefEvals as the "values" array.
                 */
                RefEval re = new Ref2DEval(null, values[j]);
                ValueEval ve = singleOperandEvaluate(re, srcRow, srcCol);
               
                if (ve instanceof NumericValueEval) {
                    NumericValueEval nve = (NumericValueEval) ve;
                    retval.add(nve.getNumberValue());
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
45
            case 1:
                 break;
        }
        Eval 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
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.