Uses of Class
org.apache.poi.ss.formula.eval.EvaluationException

Packages that use EvaluationException

Package	Description
org.apache.poi.ss.formula.eval
org.apache.poi.ss.formula.functions
org.apache.poi.ss.util

Uses of EvaluationException in org.apache.poi.ss.formula.eval

Methods in org.apache.poi.ss.formula.eval that return EvaluationException

Modifier and Type	Method and Description
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.ss.formula.eval that throw EvaluationException

Modifier and Type	Method and Description
static ValueEval	OperandResolver.chooseSingleElementFromArea(AreaEval ae, int srcCellRow, int 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 java.lang.Boolean	OperandResolver.coerceValueToBoolean(ValueEval ve, boolean stringsAreBlanks)
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() ).
protected abstract double	TwoOperandNumericOperation.evaluate(double d0, double d1)
static ValueEval	OperandResolver.getSingleValue(ValueEval arg, int srcCellRow, int srcCellCol) Retrieves a single value from a variety of different argument types according to standard Excel rules.
protected double	TwoOperandNumericOperation.singleOperandEvaluate(ValueEval arg, int srcCellRow, int srcCellCol)

Uses of EvaluationException in org.apache.poi.ss.formula.functions

Methods in org.apache.poi.ss.formula.functions that throw EvaluationException

Modifier and Type	Method and Description
protected ValueEval	AverageIf.aggregateMatchingCells(Baseifs.Aggregator aggregator, AreaEval sumRange, AreaEval testRange, CountUtils.I_MatchPredicate mp)
static void	NumericFunction.checkValue(double result)
static void	MatrixFunction.checkValues(double[] results)
double[]	MatrixFunction.MutableValueCollector.collectValues(ValueEval... operands)
protected abstract double[]	MatrixFunction.OneArrayArg.collectValues(ValueEval arg)
protected abstract double[]	MatrixFunction.TwoArrayArg.collectValues(ValueEval arg)
protected abstract double	NumericFunction.eval(ValueEval[] args, int srcCellRow, int srcCellCol)
double	PPMT.eval(ValueEval[] args, int srcCellRow, int srcCellCol)
double	IPMT.eval(ValueEval[] args, int srcCellRow, int srcCellCol)
protected abstract double	MultiOperandNumericFunction.evaluate(double[] values)
protected double	Mirr.evaluate(double[] values)
protected double	FinanceFunction.evaluate(double[] ds)
static double	Mode.evaluate(double[] v) if v is zero length or contains no duplicates, return value is Double.NaN.
protected abstract double[][]	MatrixFunction.OneArrayArg.evaluate(double[][] d1)
protected abstract double[][]	MatrixFunction.TwoArrayArg.evaluate(double[][] d1, double[][] d2)
protected abstract double	FinanceFunction.evaluate(double rate, double arg1, double arg2, double arg3, boolean type)
protected static double	TextFunction.evaluateDoubleArg(ValueEval arg, int srcCellRow, int srcCellCol)
static int	Choose.evaluateFirstArg(ValueEval arg0, int srcRowIndex, int srcColumnIndex)
static boolean	IfFunc.evaluateFirstArg(ValueEval arg, int srcCellRow, int srcCellCol)
protected abstract ValueEval	TextFunction.evaluateFunc(ValueEval[] args, int srcCellRow, int srcCellCol)
protected static int	TextFunction.evaluateIntArg(ValueEval arg, int srcCellRow, int srcCellCol)
protected static java.lang.String	TextFunction.evaluateStringArg(ValueEval eval, int srcRow, int srcCol)
protected double[]	MultiOperandNumericFunction.getNumberArray(ValueEval[] operands) Returns a double array that contains values for the numeric cells from among the list of operands.
static java.util.List<ValueEval>	PercentRank.getValues(ValueEval eval, int srcRowIndex, int srcColumnIndex)
static int	LookupUtils.lookupFirstIndexOfValue(ValueEval lookupValue, LookupUtils.ValueVector vector, boolean isRangeLookup)
static boolean	LookupUtils.resolveRangeLookupArg(ValueEval rangeLookupArg, int srcCellRow, int srcCellCol) Resolves the last (optional) parameter (range_lookup) to the VLOOKUP and HLOOKUP functions.
static int	LookupUtils.resolveRowOrColIndexArg(ValueEval rowColIndexArg, int srcCellRow, int srcCellCol) Processes the third argument to VLOOKUP, or HLOOKUP (col_index_num or row_index_num respectively). Sample behaviour: Sample behaviour Input ReturnValue Thrown Error 54 2.92 "5"4 "2.18e1"21 "-$2"-3* FALSE-1* TRUE0 "TRUE" #REF! "abc" #REF! "" #REF! <blank> #VALUE! Note - out of range errors (result index too high) are handled by the caller.
static TwoDEval	LookupUtils.resolveTableArrayArg(ValueEval eval) The second argument (table_array) should be an area ref, but can actually be a cell ref, in which case it is interpreted as a 1x1 area ref.
protected double	MatrixFunction.singleOperandEvaluate(ValueEval arg, int srcCellRow, int srcCellCol)
protected static double	NumericFunction.singleOperandEvaluate(ValueEval arg, int srcRowIndex, int srcColumnIndex)
static int	LookupUtils.xlookupIndexOfValue(ValueEval lookupValue, LookupUtils.ValueVector vector, LookupUtils.MatchMode matchMode, LookupUtils.SearchMode searchMode)

Uses of EvaluationException in org.apache.poi.ss.util

Methods in org.apache.poi.ss.util that throw EvaluationException

Modifier and Type	Method and Description
static java.util.Calendar	DateParser.parseDate(java.lang.String strVal)
static java.time.LocalDate	DateParser.parseLocalDate(java.lang.String strVal) Parses a date from a string.