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

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

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

org.apache.poi.hssf.record.formula.eval.RefEval
@author Amol S Deshmukh < amolweb at ya hoo dot com >RefEval is the super interface for Ref2D and Ref3DEval. Basically a RefEval impl should contain reference to the original ReferencePtg or Ref3DPtg as well as the final "value" resulting from the evaluation of the cell reference. Thus if the HSSFCell has type CELL_TYPE_NUMERIC, the contained value object should be of type NumberEval; if cell type is CELL_TYPE_STRING, contained value object should be of type StringEval

                stack.push(ptgEval);
            }
        }
        ValueEval value = ((ValueEval) stack.pop());
        if (value instanceof RefEval) {
            RefEval rv = (RefEval) value;
            value = rv.getInnerValueEval();
        }
        else if (value instanceof AreaEval) {
            AreaEval ae = (AreaEval) value;
            if (ae.isRow()) 
                value = ae.getValueAt(ae.getFirstRow(), srcColNum);

View Full Code Here

    // text (first) arg type is number, other args are strings with fractional digits 
    confirmMid(new NumberEval(123456), new StringEval("3.1"), new StringEval("2.9"), "34");
    
    // startPos is 1x1 area ref, numChars is cell ref
    AreaEval aeStart = new Area2DEval(new AreaPtg("A1:A1"), new ValueEval[] { new NumberEval(2), } );
    RefEval reNumChars = new Ref2DEval(new RefPtg("B1"), new NumberEval(3));
    confirmMid(new StringEval("galactic"), aeStart, reNumChars, "ala");


    confirmMid(new StringEval("galactic"), new NumberEval(3.1), BlankEval.INSTANCE, "");


    confirmMid(new StringEval("galactic"), new NumberEval(3), BoolEval.FALSE, "");

View Full Code Here

    assertEquals(expected, nve.getNumberValue(), 0);
  }


  public void testScalarSimple() {
    
    RefEval refEval = new Ref2DEval(new RefPtg("A1"), new NumberEval(3));
    Eval[] args = {
      refEval, 
      new NumberEval(2),
    };
    Eval result = invokeSumproduct(args);

View Full Code Here

   * @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

                stack.push(ptgEval);
            }
        }
        ValueEval value = ((ValueEval) stack.pop());
        if (value instanceof RefEval) {
            RefEval rv = (RefEval) value;
            value = rv.getInnerValueEval();
        }
        else if (value instanceof AreaEval) {
            AreaEval ae = (AreaEval) value;
            if (ae.isRow()) 
                value = ae.getValueAt(ae.getFirstRow(), srcColNum);

View Full Code Here

        }
      }
      return;
    }
    if (operand instanceof RefEval) {
      RefEval re = (RefEval) operand;
      collectValue(re.getInnerValueEval(), true, temp);
      return;
    }
    collectValue(operand, false, temp);
  }

View Full Code Here

    }
  }


  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


  private static double getScalarValue(ValueEval arg) throws EvaluationException {


    ValueEval eval;
    if (arg instanceof RefEval) {
      RefEval re = (RefEval) arg;
      eval = re.getInnerValueEval();
    } else {
      eval = arg;
    }


    if (eval == null) {

View Full Code Here

        }
      }
      return;
    }
    if (arg instanceof RefEval) {
      RefEval re = (RefEval) arg;
      collectValue(re.getInnerValueEval(), temp, true);
      return;
    }
    collectValue(arg, temp, true);


  }

View Full Code Here

    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

0 1 2 3 4 5 6 7 8 9

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

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.