Package | Description |
---|---|
org.apache.poi.ss.formula |
This package contains common internal POI code for manipulating formulas.
|
org.apache.poi.ss.formula.atp | |
org.apache.poi.ss.formula.functions | |
org.apache.poi.ss.formula.udf |
Modifier and Type | Field and Description |
---|---|
static FreeRefFunction |
OperationEvaluationContext.UDF |
Modifier and Type | Method and Description |
---|---|
FreeRefFunction |
OperationEvaluationContext.findUserDefinedFunction(java.lang.String functionName) |
FreeRefFunction |
WorkbookEvaluator.findUserDefinedFunction(java.lang.String functionName) |
Modifier and Type | Method and Description |
---|---|
static void |
WorkbookEvaluator.registerFunction(java.lang.String name,
FreeRefFunction func)
Register a ATP function in runtime.
|
Modifier and Type | Method and Description |
---|---|
FreeRefFunction |
AnalysisToolPak.findFunction(java.lang.String name) |
Modifier and Type | Method and Description |
---|---|
static void |
AnalysisToolPak.registerFunction(java.lang.String name,
FreeRefFunction func)
Register a ATP function in runtime.
|
Modifier and Type | Class and Description |
---|---|
class |
Bin2Dec
Implementation for Excel Bin2Dec() function.
Syntax:
Bin2Dec (number) Converts a binary number to decimal. |
class |
Complex
Implementation for Excel COMPLEX () function.
Syntax:
COMPLEX (real_num,i_num,suffix ) Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj. |
class |
Countifs
Implementation for the function COUNTIFS
|
class |
Dec2Bin
Implementation for Excel Bin2Dec() function.
Syntax:
Bin2Dec (number,[places] ) Converts a decimal number to binary. |
class |
Dec2Hex
Implementation for Excel DELTA() function.
Syntax:
DEC2HEX (number,places ) Converts a decimal number to hexadecimal. |
class |
Delta
Implementation for Excel DELTA() function.
Syntax:
DELTA (number1,number2 ) Tests whether two values are equal. |
class |
EDate
Implementation for Excel EDATE () function.
|
class |
EOMonth
Implementation for the Excel EOMONTH() function.
EOMONTH() returns the date of the last day of a month..
Syntax:
EOMONTH(start_date,months) start_date is the starting date of the calculation months is the number of months to be added to start_date, to give a new date. |
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 |
Indirect
Implementation for Excel function INDIRECT
INDIRECT() returns the cell or area reference denoted by the text argument.
Syntax:
INDIRECT(ref_text,isA1Style)
ref_text a string representation of the desired reference as it would
normally be written in a cell formula.
isA1Style (default TRUE) specifies whether the ref_text should be interpreted as A1-style or R1C1-style. |
class |
Oct2Dec
Implementation for Excel Oct2Dec() function.
|
class |
Quotient
Implementation for Excel QUOTIENT () function.
|
class |
Sumifs
Implementation for the Excel function SUMIFS
|
class |
WeekNum
Implementation for Excel WeekNum() function.
Syntax:
WeekNum (Serial_num,Return_type) Returns a number that indicates where the week falls numerically within a year. |
Modifier and Type | Field and Description |
---|---|
static FreeRefFunction |
WeekNum.instance |
static FreeRefFunction |
Dec2Bin.instance |
static FreeRefFunction |
EDate.instance |
static FreeRefFunction |
Complex.instance |
static FreeRefFunction |
Oct2Dec.instance |
static FreeRefFunction |
EOMonth.instance |
static FreeRefFunction |
Hex2Dec.instance |
static FreeRefFunction |
Bin2Dec.instance |
static FreeRefFunction |
FactDouble.instance |
static FreeRefFunction |
Quotient.instance |
static FreeRefFunction |
Indirect.instance |
static FreeRefFunction |
Dec2Hex.instance |
static FreeRefFunction |
Sumifs.instance |
static FreeRefFunction |
Countifs.instance |
static FreeRefFunction |
Imaginary.instance |
static FreeRefFunction |
ImReal.instance |
static FreeRefFunction |
Delta.instance |
Modifier and Type | Method and Description |
---|---|
FreeRefFunction |
UDFFinder.findFunction(java.lang.String name)
Returns executor by specified name.
|
FreeRefFunction |
DefaultUDFFinder.findFunction(java.lang.String name) |
FreeRefFunction |
AggregatingUDFFinder.findFunction(java.lang.String name)
Returns executor by specified name.
|
FreeRefFunction |
IndexedUDFFinder.findFunction(java.lang.String name) |
Constructor and Description |
---|
DefaultUDFFinder(java.lang.String[] functionNames,
FreeRefFunction[] functionImpls) |
Copyright 2015 The Apache Software Foundation or its licensors, as applicable.