Modifier and Type | Class and Description |
---|---|
static class |
NumericFunction.OneArg |
static class |
NumericFunction.TwoArg |
Modifier and Type | Field and Description |
---|---|
static Function |
ABS |
static Function |
ACOS |
static Function |
ACOSH |
static Function |
ASIN |
static Function |
ASINH |
static Function |
ATAN |
static Function |
ATAN2 |
static Function |
ATANH |
static Function |
CEILING |
static Function |
COMBIN |
static Function |
COS |
static Function |
COSH |
static Function |
DEGREES |
static Function |
DOLLAR |
static Function |
EXP |
static Function |
FACT |
static Function |
FLOOR |
static Function |
INT |
static Function |
LN |
static Function |
LOG |
static Function |
LOG10 |
static Function |
MOD |
static Function |
PI |
static Function |
POISSON |
static Function |
POWER |
static Function |
RADIANS |
static Function |
RAND |
static Function |
ROUND |
static Function |
ROUNDDOWN |
static Function |
ROUNDUP |
static Function |
SIGN |
static Function |
SIN |
static Function |
SINH |
static Function |
SQRT |
static Function |
TAN |
static Function |
TANH |
static Function |
TRUNC |
Constructor and Description |
---|
NumericFunction() |
Modifier and Type | Method and Description |
---|---|
static void |
checkValue(double result) |
protected abstract double |
eval(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
protected static double |
singleOperandEvaluate(ValueEval arg,
int srcRowIndex,
int srcColumnIndex) |
public static final Function ABS
public static final Function ACOS
public static final Function ACOSH
public static final Function ASIN
public static final Function ASINH
public static final Function ATAN
public static final Function ATANH
public static final Function COS
public static final Function COSH
public static final Function DEGREES
public static final Function DOLLAR
public static final Function EXP
public static final Function FACT
public static final Function INT
public static final Function LN
public static final Function LOG10
public static final Function RADIANS
public static final Function SIGN
public static final Function SIN
public static final Function SINH
public static final Function SQRT
public static final Function TAN
public static final Function TANH
public static final Function ATAN2
public static final Function CEILING
public static final Function COMBIN
public static final Function FLOOR
public static final Function MOD
public static final Function POWER
public static final Function ROUND
public static final Function ROUNDDOWN
public static final Function ROUNDUP
public static final Function TRUNC
public static final Function LOG
public static final Function PI
public static final Function RAND
public static final Function POISSON
protected static double singleOperandEvaluate(ValueEval arg, int srcRowIndex, int srcColumnIndex) throws EvaluationException
EvaluationException
public static void checkValue(double result) throws EvaluationException
EvaluationException
- (#NUM!) if result is NaN> or Infinitypublic final ValueEval evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
evaluate
in interface Function
args
- the evaluated function arguments. Empty values are represented with
BlankEval
or MissingArgEval
, never null
.srcCellRow
- row index of the cell containing the formula under evaluationsrcCellCol
- column index of the cell containing the formula under evaluationErrorEval
, never null
.
Note - Excel uses the error code #NUM! instead of IEEE NaN, so when
numeric functions evaluate to Double.NaN
be sure to translate the result to ErrorEval.NUM_ERROR
.protected abstract double eval(ValueEval[] args, int srcCellRow, int srcCellCol) throws EvaluationException
EvaluationException
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.