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) |
ValueEval |
evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
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
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
.Copyright © 2010 - 2020 Adobe. All Rights Reserved