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

Packages that use EvaluationException

Package	Description
org.zkoss.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
org.zkoss.poi.ss.formula.atp
org.zkoss.poi.ss.formula.eval
org.zkoss.poi.ss.formula.functions
org.zkoss.zss.model.impl.sys.formula	ZK Spreadsheet Internal Book Model Implementation classes.
org.zkoss.zssex.formula.fn	ZK EL functions implementation that realize ZK Spreadsheet formula functions.

Uses of EvaluationException in org.zkoss.poi.ss.formula

Methods in org.zkoss.poi.ss.formula that throw EvaluationException

Modifier and Type	Method and Description
static java.util.List<java.lang.Double>	AreaEvalHelper.toDoubleList(ValueEval valueEval, int srcRowIndex, int srcColumnIndex)
static double[][]	AreaEvalHelper.toDoubleMatrix(ValueEval valueEval, int relativeRowIndex, int relativeColumnIndex)

Uses of EvaluationException in org.zkoss.poi.ss.formula.atp

Methods in org.zkoss.poi.ss.formula.atp that throw EvaluationException

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

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

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

Modifier and Type	Method and Description
static EvaluationException	EvaluationException.invalidRef() #REF!
static EvaluationException	EvaluationException.invalidValue() #VALUE!
static EvaluationException	EvaluationException.numberError() #NUM!

Methods in org.zkoss.poi.ss.formula.eval that throw EvaluationException

Modifier and Type	Method and Description
static ValueEval	OperandResolver.chooseMultipleElementsFromArea(AreaEval ae, int srcCellRow, int srcCellCol)
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.
static long	OperandResolver.coerceValueToLong(ValueEval ev) Applies some conversion rules if the supplied value is not already a long integer.
protected abstract double	TwoOperandNumericOperation.evaluate(double d0, double d1)
static ValueEval	OperandResolver.getMultipleValue(ValueEval arg, int srcCellRow, int srcCellCol)
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.zkoss.poi.ss.formula.functions

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

Modifier and Type	Method and Description
static double	NumericFunctionHelper.checkValue(double result)
static void	NumericFunction.checkValue(double result)
static int	UtilFns.dsm(java.util.Date settle, java.util.Date maturi, int basis)
protected abstract double	NumericFunction.eval(ValueEval[] args, int srcCellRow, int srcCellCol)
protected double	NumericFunction.OneArg.eval(ValueEval[] args, int srcCellRow, int srcCellCol)
protected abstract double	NumericFunction.OneArg.evaluate(double d)
protected abstract double	MultiOperandNumericFunction.evaluate(double[] values)
static double	Mode.evaluate(double[] v) if v is zero length or contains no duplicates, return value is Double.NaN.
protected double	FinanceFunction.evaluate(double[] ds)
protected abstract double	NumericFunction.TwoArg.evaluate(double d0, double d1)
protected abstract double	FinanceFunction.evaluate(double rate, double arg1, double arg2, double arg3, boolean type)
static double	TextFunctionHelper.evaluateDoubleArg(ValueEval eval, int srcCellRow, int srcCellCol)
protected static double	TextFunction.evaluateDoubleArg(ValueEval arg, int srcCellRow, int srcCellCol)
static boolean	IfFunc.evaluateFirstArg(ValueEval arg, int srcCellRow, int srcCellCol)
static int	Choose.evaluateFirstArg(ValueEval arg0, int srcRowIndex, int srcColumnIndex)
protected abstract ValueEval	TextFunction.evaluateFunc(ValueEval[] args, int srcCellRow, int srcCellCol)
static int	TextFunctionHelper.evaluateIntArg(ValueEval eval, int srcCellRow, int srcCellCol)
protected static int	TextFunction.evaluateIntArg(ValueEval arg, int srcCellRow, int srcCellCol)
static java.lang.String	TextFunctionHelper.evaluateStringArg(ValueEval eval, 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 SimpleRegression	UtilFns.getRegre(double[] xs, double[] ys) Return a commons math Regression class
static java.lang.String	UtilFns.padZero(java.lang.String num, int places)
protected static double	NumericFunction.singleOperandEvaluate(ValueEval arg, int srcRowIndex, int srcColumnIndex)
protected static boolean	NumericFunction.singleOperandEvaluateToBoolean(ValueEval arg, int srcRowIndex, int srcColumnIndex)
static boolean	UtilFns.stringToBoolean(ValueEval arg)
static java.util.Date	UtilFns.stringToDate(ValueEval arg) Convert a String to Date
static java.lang.Double	UtilFns.stringToDouble(java.lang.String str, boolean nullable) Convert a string to double
static double[]	UtilFns.toDoubleArray(java.util.List ls) Convert a list to a double array
static double[]	UtilFns.toDoubleArray(java.lang.Object[] objs) Convert an object array to a double array
static double[][]	UtilFns.toDoubleMatrix(ValueEval arg, int srcRowIndex, int srcColumnIndex)
static int[]	UtilFns.toIntArray(java.lang.Object[] objs) Convert an object array to an int array
static java.util.List	UtilFns.toList(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static Complex	UtilFns.validateComplex(java.lang.String complex) Validate given String value, return associated complex.

Uses of EvaluationException in org.zkoss.zss.model.impl.sys.formula

Methods in org.zkoss.zss.model.impl.sys.formula that throw EvaluationException

Modifier and Type	Method and Description
static EvaluationResult	FormulaEngineImpl.convertToEvaluationResult(ValueEval value)
protected static org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl.ResultValueEval	FormulaEngineImpl.getResolvedValue(ValueEval value)

Uses of EvaluationException in org.zkoss.zssex.formula.fn

Methods in org.zkoss.zssex.formula.fn that throw EvaluationException

Modifier and Type	Method and Description
static double	EngineeringFunctionImpl.engineeringBesseli(double x, int n)
static int	MathFunctionImpl.gcd(int m, int n) Returns the greatest common divisor
static Complex[]	EngineeringFunctionImpl.toComplexArray(ValueEval[] args, int srcCellRow, int srcCellCol) Convert an object array to a complex array