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

Packages that use EvaluationException

Package	Description
io.keikai.model.impl.sys.formula	Keikai Spreadsheet Internal Book Model Implementation classes.
io.keikaiex.formula.fn	ZK EL functions implementation that realize Keikai Spreadsheet formula functions.
org.apache.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
org.apache.poi.ss.formula.eval
org.apache.poi.ss.formula.functions
org.apache.poi.ss.util

Uses of EvaluationException in io.keikai.model.impl.sys.formula

Methods in io.keikai.model.impl.sys.formula that throw EvaluationException

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

Uses of EvaluationException in io.keikaiex.formula.fn

Methods in io.keikaiex.formula.fn that throw EvaluationException

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

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

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

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

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	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	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 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.
static ValueEval	OperandResolver.getSingleValueInNameFormula(ValueEval arg, int srcCellRow, int srcCellCol)
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	Description
protected ValueEval	AverageIf.aggregateMatchingCells(org.apache.poi.ss.formula.functions.Baseifs.Aggregator aggregator, AreaEval sumRange, AreaEval testRange, org.apache.poi.ss.formula.functions.CountUtils.I_MatchPredicate mp)
static void	NumericFunction.checkValue(double result)
static double	NumericFunctionHelper.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)
static int	UtilFns.dsm(Date settle, Date maturi, int basis)
double	IPMT.eval(ValueEval[] args, int srcCellRow, int srcCellCol)
protected abstract double	NumericFunction.eval(ValueEval[] args, int srcCellRow, int srcCellCol)
double	PPMT.eval(ValueEval[] args, int srcCellRow, int srcCellCol)
protected double	FinanceFunction.evaluate(double[] ds)
protected abstract double	FinanceFunction.evaluate(double rate, double arg1, double arg2, double arg3, boolean type)
protected abstract double[][]	MatrixFunction.OneArrayArg.evaluate(double[][] d1)
protected abstract double[][]	MatrixFunction.TwoArrayArg.evaluate(double[][] d1, double[][] d2)
protected double	Mirr.evaluate(double[] values)
static double	Mode.evaluate(double[] v)	if v is zero length or contains no duplicates, return value is Double.NaN.
protected abstract double	MultiOperandNumericFunction.evaluate(double[] values)
protected static double	TextFunction.evaluateDoubleArg(ValueEval arg, int srcCellRow, int srcCellCol)
static double	TextFunctionHelper.evaluateDoubleArg(ValueEval eval, 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)
static int	TextFunctionHelper.evaluateIntArg(ValueEval eval, int srcCellRow, int srcCellCol)
protected static String	TextFunction.evaluateStringArg(ValueEval eval, int srcRow, int srcCol)
static String	TextFunctionHelper.evaluateStringArg(ValueEval eval, int srcCellRow, int srcCellCol)
protected double[]	MultiOperandNumericFunction.getNumberArray(ValueEval[] operands)	Returns a double array that contains values for the numeric cells from among the list of operands.
static org.apache.commons.math3.stat.regression.SimpleRegression	UtilFns.getRegre(double[] xs, double[] ys)	Return a commons math Regression class
static List<ValueEval>	PercentRank.getValues(ValueEval eval, int srcRowIndex, int srcColumnIndex)
static int	LookupUtils.lookupFirstIndexOfValue(ValueEval lookupValue, LookupUtils.ValueVector vector, boolean isRangeLookup)
static int	LookupUtils.lookupIndexOfExactValue(ValueEval lookupValue, TwoDEval tableArray, int columnIndex)
static String	UtilFns.padZero(String num, int places)
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 boolean	UtilFns.stringToBoolean(ValueEval arg)
static Date	UtilFns.stringToDate(ValueEval arg)	Convert a String to Date
static Double	UtilFns.stringToDouble(String str, boolean nullable)	Convert a string to double
static double[]	UtilFns.toDoubleArray(Object[] objs)	Convert an object array to a double array
static double[]	UtilFns.toDoubleArray(List ls)	Convert a list to a double array
static double[][]	UtilFns.toDoubleMatrix(ValueEval arg, int srcRowIndex, int srcColumnIndex)
static int[]	UtilFns.toIntArray(Object[] objs)	Convert an object array to an int array
static List	UtilFns.toList(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static ComplexEx	UtilFns.validateComplex(String complex)	Validate given String value, return associated complex.
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	Description
static Calendar	DateParser.parseDate(String strVal)
static LocalDate	DateParser.parseLocalDate(String strVal)	Parses a date from a string.