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 classstatic class -
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Functionstatic final Function -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic voidcheckValue(double result) protected abstract doublefinal ValueEvalprotected static doublesingleOperandEvaluate(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:
evaluatein interfaceFunction- Parameters:
args- the evaluated function arguments. Empty values are represented withBlankEvalorMissingArgEval, 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.NaNbe sure to translate the result toErrorEval.NUM_ERROR.
-
eval
protected abstract double eval(ValueEval[] args, int srcCellRow, int srcCellCol) throws EvaluationException - Throws:
EvaluationException
-