Uses of Class
org.apache.poi.hssf.record.formula.eval.EvaluationException

Packages that use EvaluationException
org.apache.poi.hssf.record.formula.eval   
 

Uses of EvaluationException in org.apache.poi.hssf.record.formula.eval
 

Methods in org.apache.poi.hssf.record.formula.eval that return EvaluationException
static EvaluationException EvaluationException.invalidRef()
          #REF! - Illegal or deleted cell reference
static EvaluationException EvaluationException.invalidValue()
          #VALUE! - Wrong type of operand
static EvaluationException EvaluationException.numberError()
          #NUM! - Value range overflow
 

Methods in org.apache.poi.hssf.record.formula.eval that throw EvaluationException
static ValueEval OperandResolver.chooseSingleElementFromArea(AreaEval ae, int srcCellRow, short srcCellCol)
          Implements (some perhaps not well known) Excel functionality to select a single cell from an area depending on the coordinates of the calling cell.
static double OperandResolver.coerceValueToDouble(ValueEval ev)
          Applies some conversion rules if the supplied value is not already a number.
static int OperandResolver.coerceValueToInt(ValueEval ev)
          Applies some conversion rules if the supplied value is not already an integer.
Value is first coerced to a double ( See coerceValueToDouble() ).

Excel typically converts doubles to integers by truncating toward negative infinity.
The equivalent java code is:
  return (int)Math.floor(d);
not:
  return (int)d; // wrong - rounds toward zero

static ValueEval OperandResolver.getSingleValue(Eval arg, int srcCellRow, short srcCellCol)
          Retrieves a single value from a variety of different argument types according to standard Excel rules.
 



Copyright 2008 The Apache Software Foundation or its licensors, as applicable.