Package | Description |
---|---|
org.apache.poi.ss.formula.eval | |
org.apache.poi.ss.formula.functions |
Modifier and Type | Class and Description |
---|---|
class |
PercentEval
Implementation of Excel formula token '%'.
|
class |
UnaryMinusEval |
class |
UnaryPlusEval |
Modifier and Type | Class and Description |
---|---|
class |
Bin2Dec
Implementation for Excel Bin2Dec() function.
Syntax:
Bin2Dec (number) Converts a binary number to decimal. |
class |
CalendarFieldFunction
Implementation of Excel functions Date parsing functions:
Date - DAY, MONTH and YEAR
Time - HOUR, MINUTE and SECOND
|
class |
Code
Implementation for Excel CODE () function.
Syntax:
CODE (text ) Returns a numeric code for the first character in a text string. |
class |
Columns
Implementation for Excel COLUMNS function.
|
class |
Countblank
Implementation for the function COUNTBLANK
|
class |
Errortype
Implementation for the ERROR.TYPE() Excel function.
|
class |
Even |
class |
FactDouble
Implementation for Excel FACTDOUBLE() function.
Syntax:
FACTDOUBLE (number) Returns the double factorial of a number. |
class |
Hex2Dec
Implementation for Excel HEX2DEC() function.
Syntax:
HEX2DEC (number) Converts a hexadecimal number to decimal. |
class |
Imaginary
Implementation for Excel IMAGINARY() function.
Syntax:
IMAGINARY (Inumber) Returns the imaginary coefficient of a complex number in x + yi or x + yj text format. |
class |
ImReal
Implementation for Excel ImReal() function.
Syntax:
ImReal (Inumber) Returns the real coefficient of a complex number in x + yi or x + yj text format. |
class |
LogicalFunction |
static class |
NumericFunction.OneArg |
class |
Oct2Dec
Implementation for Excel Oct2Dec() function.
|
class |
Odd |
class |
Rows
Implementation for Excel ROWS function.
|
class |
T
Implementation of Excel T() function
If the argument is a text or error value it is returned unmodified.
|
class |
Value
Implementation for Excel VALUE() function.
Syntax:
VALUE(text) Converts the text argument to a number. |
Copyright 2015 The Apache Software Foundation or its licensors, as applicable.