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 | Class and Description |
---|---|
class |
IfNa
Implementation of 'Analysis Toolpak' the Excel function IFNA()
Syntax:
IFNA(test_value, default_value) |
class |
Stdevp |
class |
Stdevs |
class |
Switch
Implementation of 'Analysis Toolpak' Excel function SWITCH()
|
class |
Varp |
class |
Vars |
Modifier and Type | Field and Description |
---|---|
static FreeRefFunction |
Switch.instance |
static FreeRefFunction |
IfNa.instance |
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 an ATP function in runtime.
|
Modifier and Type | Class and Description |
---|---|
class |
AverageIf
Handler for singular AverageIf which has different operand handling than
the generic AverageIfs version.
|
class |
Averageifs
Implementation for the Excel function AVERAGEIFS
|
class |
BesselJ
Implementation for Excel BESSELJ() function.
|
class |
Bin2Dec
Implementation for Excel Bin2Dec() function.
|
class |
CeilingMath
Implementation for Excel CEILING.MATH() function.
|
class |
CeilingPrecise
Implementation for Excel CEILING.PRECISE() function.
|
class |
Complex
Implementation for Excel COMPLEX () function.
|
class |
Countifs
Implementation for the function COUNTIFS
|
class |
Covar
Implementation for Excel COVAR() and COVARIANCE.P() functions.
|
class |
Days
Calculates the number of days between two dates based on a real year,
which is used in some accounting calculations.
|
class |
Dec2Bin
Implementation for Excel DEC2BIN() function.
|
class |
Dec2Hex
Implementation for Excel DELTA() function.
|
class |
Delta
Implementation for Excel DELTA() function.
|
class |
DollarDe
Implementation for Excel DOLLARDE() function.
|
class |
DollarFr
Implementation for Excel DOLLARFR() function.
|
class |
EDate
Implementation for Excel EDATE () function.
|
class |
EOMonth
Implementation for the Excel EOMONTH() function.
|
class |
FactDouble
Implementation for Excel FACTDOUBLE() function.
|
class |
FloorMath
Implementation for Excel FLOOR.MATH() function.
|
class |
FloorPrecise
Implementation for Excel FLOOR.PRECISE() function.
|
class |
Forecast
Implementation for Excel FORECAST() and FORECAST.LINEAR() functions.
|
class |
Gcd
Implementation for Excel GCD() function.
|
class |
Hex2Dec
Implementation for Excel HEX2DEC() function.
|
class |
Imaginary
Implementation for Excel IMAGINARY() function.
|
class |
ImReal
Implementation for Excel ImReal() function.
|
class |
Indirect
Implementation for Excel function INDIRECT
|
class |
Lcm
Implementation for Excel LCM() function.
|
class |
Maxifs
Implementation for the Excel function MAXIFS
|
class |
Minifs
Implementation for the Excel function MINIFS
|
class |
NormDist
Implementation for Excel NORMDIST() and NORM.DIST() functions.
|
class |
NormInv
Implementation for Excel NORMINV() and NORM.INV() functions.
|
class |
NormSDist
Implementation for Excel NORMSDIST() and NORM.S.DIST functions.
|
class |
NormSInv
Implementation for Excel NORMSINV() and NORM.S.INV() functions.
|
class |
NumberValueFunction
/**
Implementation for the NUMBERVALUE() Excel function.
|
class |
Oct2Dec
Implementation for Excel Oct2Dec() function.
|
class |
Poisson |
class |
Quotient
Implementation for Excel QUOTIENT () function.
|
class |
Single
Implementation of the SINGLE function, used by Dynamic Arrays, which is
now largely replaced by the @ character.
|
class |
Sqrtpi
Implementation for Excel SQRTPI() function.
|
class |
Standardize
Implementation for Excel STANDARDIZE() function.
|
class |
Sumifs
Implementation for the Excel function SUMIFS
|
class |
TDist
Implementation for Excel TDIST() function.
|
class |
TDist2t
Implementation for Excel T.DIST.2T() function.
|
class |
TDistLt
Implementation for Excel T.DIST() function.
|
class |
TDistRt
Implementation for Excel T.DIST.RT() function.
|
class |
WeekNum
Implementation for Excel WeekNum() function.
|
Modifier and Type | Method and Description |
---|---|
FreeRefFunction |
AggregatingUDFFinder.findFunction(java.lang.String name)
Returns executor by specified name.
|
FreeRefFunction |
IndexedUDFFinder.findFunction(java.lang.String name) |
FreeRefFunction |
DefaultUDFFinder.findFunction(java.lang.String name) |
FreeRefFunction |
UDFFinder.findFunction(java.lang.String name)
Returns executor by specified name.
|
Constructor and Description |
---|
DefaultUDFFinder(java.lang.String[] functionNames,
FreeRefFunction[] functionImpls) |
Copyright 2022 The Apache Software Foundation or its licensors, as applicable.