Package | Description |
---|---|
org.apache.poi.ss.formula.eval | |
org.apache.poi.ss.formula.functions | |
org.apache.poi.ss.util |
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
|
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) |
Modifier and Type | Method and Description |
---|---|
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) |
protected double |
NumericFunction.OneArg.eval(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
double |
IPMT.eval(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
double |
PPMT.eval(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
protected abstract double |
NumericFunction.OneArg.evaluate(double d) |
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 |
NumericFunction.TwoArg.evaluate(double d0,
double d1) |
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 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) |
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.
|
protected static double |
NumericFunction.singleOperandEvaluate(ValueEval arg,
int srcRowIndex,
int srcColumnIndex) |
protected double |
MatrixFunction.singleOperandEvaluate(ValueEval arg,
int srcCellRow,
int srcCellCol) |
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.
|
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.