Class NumericFunction
java.lang.Object
org.apache.poi.ss.formula.functions.NumericFunction
- All Implemented Interfaces:
Function
- Author:
- Amol S. Deshmukh < amolweb at ya hoo dot com >, Josh Micich, Stephen Wolke (smwolke at geistig.com)
-
Nested Class Summary
Nested ClassesModifier and TypeClassDescriptionstatic class
static class
-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
static final Function
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic void
checkValue
(double result) protected abstract double
final ValueEval
protected static double
singleOperandEvaluate
(ValueEval arg, int srcRowIndex, int srcColumnIndex)
-
Field Details
-
ABS
-
ACOS
-
ACOSH
-
ASIN
-
ASINH
-
ATAN
-
ATANH
-
COS
-
COSH
-
DEGREES
-
DOLLAR
-
EXP
-
FACT
-
INT
-
LN
-
LOG10
-
RADIANS
-
SIGN
-
SIN
-
SINH
-
SQRT
-
TAN
-
TANH
-
ATAN2
-
CEILING
-
COMBIN
-
FLOOR
-
MOD
-
POWER
-
ROUND
-
ROUNDDOWN
-
ROUNDUP
-
TRUNC
-
LOG
-
PI
-
RAND
-
POISSON
-
-
Constructor Details
-
NumericFunction
public NumericFunction()
-
-
Method Details
-
singleOperandEvaluate
protected static double singleOperandEvaluate(ValueEval arg, int srcRowIndex, int srcColumnIndex) throws EvaluationException - Throws:
EvaluationException
-
checkValue
- Throws:
EvaluationException
- (#NUM!) if result is NaN</> or Infinity
-
evaluate
- Specified by:
evaluate
in interfaceFunction
- Parameters:
args
- the evaluated function arguments. Empty values are represented withBlankEval
orMissingArgEval
, nevernull
.srcCellRow
- row index of the cell containing the formula under evaluationsrcCellCol
- column index of the cell containing the formula under evaluation- Returns:
- The evaluated result, possibly an
ErrorEval
, nevernull
. Note - Excel uses the error code #NUM! instead of IEEE NaN, so when numeric functions evaluate toDouble.NaN
be sure to translate the result toErrorEval.NUM_ERROR
.
-
eval
protected abstract double eval(ValueEval[] args, int srcCellRow, int srcCellCol) throws EvaluationException - Throws:
EvaluationException
-