Uses of Interface
org.apache.poi.ss.formula.functions.Function

Packages that use Function

Package	Description
io.keikaiex.formula	Classes bridging Keikai Spreadsheet formula functions to ZK EL functions.
io.keikaiex.formula.fn	ZK EL functions implementation that realize Keikai Spreadsheet formula functions.
org.apache.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
org.apache.poi.ss.formula.eval
org.apache.poi.ss.formula.functions

Uses of Function in io.keikaiex.formula

Classes in io.keikaiex.formula that implement Function

Modifier and Type	Class	Description
class	ELEvalFunction	This the default function that delegate the POI function call to EL tld function.

Uses of Function in io.keikaiex.formula.fn

Classes in io.keikaiex.formula.fn that implement Function

Modifier and Type	Class	Description
static class	LookupAndReferenceFunctionImpl.Unique

Fields in io.keikaiex.formula.fn declared as Function

Modifier and Type	Field	Description
static Function	FinanceFunctionImpl.ACCRINT
static Function	FinanceFunctionImpl.ACCRINTM
static Function	FinanceFunctionImpl.AMORDEGRC
static Function	FinanceFunctionImpl.AMORLINC
static Function	StatFunctionImpl.AVERAGEA
static Function	EngineeringFunctionImpl.BESSELI
static Function	EngineeringFunctionImpl.BESSELJ
static Function	EngineeringFunctionImpl.BESSELK
static Function	EngineeringFunctionImpl.BESSELY
static Function	StatFunctionImpl.BETA$DIST
static Function	StatFunctionImpl.BETADIST
static Function	StatFunctionImpl.BETAINV
static Function	EngineeringFunctionImpl.BIN2DEC
static Function	EngineeringFunctionImpl.BIN2HEX
static Function	EngineeringFunctionImpl.BIN2OCT
static Function	StatFunctionImpl.BINOMDIST
static Function	StatFunctionImpl.BINOMINV
static Function	InfoFunctionImpl.CELL
static Function	TextFunctionImpl.CHAR
static Function	StatFunctionImpl.CHIDIST
static Function	StatFunctionImpl.CHIINV
static Function	StatFunctionImpl.CHISQDIST
static Function	StatFunctionImpl.CHISQINV
static Function	TextFunctionImpl.CODE
static Function	EngineeringFunctionImpl.COMPLEX
static Function	StatFunctionImpl.CORREL
static Function	FinanceFunctionImpl.COUPDAYBS
static Function	FinanceFunctionImpl.COUPDAYS
static Function	FinanceFunctionImpl.COUPDAYSNC
static Function	FinanceFunctionImpl.COUPNCD
static Function	FinanceFunctionImpl.COUPNUM
static Function	FinanceFunctionImpl.COUPPCD
static Function	FinanceFunctionImpl.CUMIPMT
static Function	FinanceFunctionImpl.CUMPRINC
static Function	DateTimeFunctionImpl.DATEDIF
static Function	DateTimeFunctionImpl.DATEVALUE
static Function	FinanceFunctionImpl.DB
static Function	FinanceFunctionImpl.DDB
static Function	EngineeringFunctionImpl.DEC2BIN
static Function	EngineeringFunctionImpl.DEC2HEX
static Function	EngineeringFunctionImpl.DEC2OCT
static Function	EngineeringFunctionImpl.DELTA
static Function	FinanceFunctionImpl.DISC
static Function	FinanceFunctionImpl.DOLLARDE
static Function	FinanceFunctionImpl.DOLLARFR
static Function	FinanceFunctionImpl.DURATION
static Function	FinanceFunctionImpl.EFFECT
static Function	DateTimeFunctionImpl.EOMONTH
static Function	EngineeringFunctionImpl.ERF
static Function	EngineeringFunctionImpl.ERFC
static Function	StatFunctionImpl.EXPONDIST
static Function	MathFunctionImpl.FACTDOUBLE
static Function	StatFunctionImpl.FDIST
static Function	StatFunctionImpl.FINV
static Function	TextFunctionImpl.FIXED
static Function	FinanceFunctionImpl.FVSCHEDULE
static Function	StatFunctionImpl.GAMMADIST
static Function	StatFunctionImpl.GAMMAINV
static Function	StatFunctionImpl.GAMMALN
static Function	MathFunctionImpl.GCD
static Function	StatFunctionImpl.GEOMEAN
static Function	EngineeringFunctionImpl.GESTEP
static Function	StatFunctionImpl.HARMEAN
static Function	EngineeringFunctionImpl.HEX2BIN
static Function	EngineeringFunctionImpl.HEX2DEC
static Function	EngineeringFunctionImpl.HEX2OCT
static Function	DateTimeFunctionImpl.HOUR
static Function	StatFunctionImpl.HYPGEOMDIST
static Function	LogicalFunctionImpl.IFERROR
static Function	EngineeringFunctionImpl.IMABS
static Function	EngineeringFunctionImpl.IMAGINARY
static Function	EngineeringFunctionImpl.IMARGUMENT
static Function	EngineeringFunctionImpl.IMCONJUGATE
static Function	EngineeringFunctionImpl.IMCOS
static Function	EngineeringFunctionImpl.IMDIV
static Function	EngineeringFunctionImpl.IMEXP
static Function	EngineeringFunctionImpl.IMLN
static Function	EngineeringFunctionImpl.IMLOG10
static Function	EngineeringFunctionImpl.IMLOG2
static Function	EngineeringFunctionImpl.IMPOWER
static Function	EngineeringFunctionImpl.IMPRODUCT
static Function	EngineeringFunctionImpl.IMREAL
static Function	EngineeringFunctionImpl.IMSIN
static Function	EngineeringFunctionImpl.IMSQRT
static Function	EngineeringFunctionImpl.IMSUB
static Function	EngineeringFunctionImpl.IMSUM
static Function	StatFunctionImpl.INTERCEPT
static Function	FinanceFunctionImpl.INTRATE
static Function	FinanceFunctionImpl.IPMT
static Function	InfoFunctionImpl.ISERR	Excel 2007 help document: ISERR(value): Returns TRUE if value refers to any error value except #N/A
static Function	StatFunctionImpl.KURT
static Function	MathFunctionImpl.LCM
static Function	TextFunctionImpl.LEFTB
static Function	StatFunctionImpl.LINEST
static Function	StatFunctionImpl.LOGNORMDIST
static Function	StatFunctionImpl.LOGNORMINV
static Function	MathFunctionImpl.MDETERM
static Function	DateTimeFunctionImpl.MINUTE
static Function	MathFunctionImpl.MINVERSE
static Function	MathFunctionImpl.MMULT
static Function	StatFunctionImpl.MODESNGL
static Function	MathFunctionImpl.MROUND
static Function	MathFunctionImpl.MULTINOMIAL
static Function	InfoFunctionImpl.N
static Function	StatFunctionImpl.NEGBINOMDIST
static Function	FinanceFunctionImpl.NOMINAL
static Function	StatFunctionImpl.NORMDIST
static Function	StatFunctionImpl.NORMINV
static Function	StatFunctionImpl.NORMSDIST
static Function	StatFunctionImpl.NORMSINV
static Function	FinanceFunctionImpl.NPV
static Function	EngineeringFunctionImpl.OCT2BIN
static Function	EngineeringFunctionImpl.OCT2DEC
static Function	EngineeringFunctionImpl.OCT2HEX
static Function	StatFunctionImpl.POISSON
static Function	StatFunctionImpl.POISSONINV
static Function	FinanceFunctionImpl.PPMT
static Function	FinanceFunctionImpl.PRICE
static Function	FinanceFunctionImpl.PRICEDISC
static Function	FinanceFunctionImpl.PRICEMAT
static Function	TextFunctionImpl.PROPER
static Function	MathFunctionImpl.QUOTIENT
static Function	MathFunctionImpl.RANDBETWEEN
static Function	StatFunctionImpl.RANKEQ
static Function	FinanceFunctionImpl.RECEIVED
static Function	TextFunctionImpl.REPLACE
static Function	TextFunctionImpl.REPLACEB
static Function	TextFunctionImpl.REPT
static Function	MathFunctionImpl.ROMAN
static Function	DateTimeFunctionImpl.SECOND
static Function	StatFunctionImpl.SKEW
static Function	FinanceFunctionImpl.SLN
static Function	StatFunctionImpl.SLOPE
static Function	MathFunctionImpl.SQRTPI
static Function	StatFunctionImpl.STDEV
static Function	TextFunctionImpl.SUBSTITUTE
static Function	FinanceFunctionImpl.SYD
static Function	FinanceFunctionImpl.TBILLEQ
static Function	FinanceFunctionImpl.TBILLPRICE
static Function	FinanceFunctionImpl.TBILLYIELD
static Function	StatFunctionImpl.TDIST
static Function	StatFunctionImpl.TDIST2T
static Function	StatFunctionImpl.TDISTRT
static Function	FinanceFunctionImpl.Temp
static Function	StatFunctionImpl.TINV
static Function	InfoFunctionImpl.TYPE
static Function	TextFunctionImpl.VALUE
static Function	StatFunctionImpl.VAR
static Function	DateTimeFunctionImpl.WEEKDAY
static Function	StatFunctionImpl.WEIBULL
static Function	FinanceFunctionImpl.XNPV
static Function	FinanceFunctionImpl.YIELD
static Function	FinanceFunctionImpl.YIELDDISC
static Function	FinanceFunctionImpl.YIELDMAT

Uses of Function in org.apache.poi.ss.formula

Methods in org.apache.poi.ss.formula with parameters of type Function

Modifier and Type	Method	Description
static void	WorkbookEvaluator.registerFunction(String name, Function func)	Register a function in runtime.

Uses of Function in org.apache.poi.ss.formula.eval

Classes in org.apache.poi.ss.formula.eval that implement Function

Modifier and Type	Class	Description
class	ConcatEval
class	IntersectionEval
class	PercentEval	Implementation of Excel formula token '%'.
class	RangeEval
class	RelationalOperationEval	Base class for all comparison operator evaluators
class	TwoOperandNumericOperation
class	UnaryMinusEval
class	UnaryPlusEval

Fields in org.apache.poi.ss.formula.eval declared as Function

Modifier and Type	Field	Description
static Function	TwoOperandNumericOperation.AddEval
static Function	TwoOperandNumericOperation.DivideEval
static Function	RelationalOperationEval.EqualEval
protected static Function[]	FunctionEval.functions	Array elements corresponding to unimplemented functions are null
static Function	RelationalOperationEval.GreaterEqualEval
static Function	RelationalOperationEval.GreaterThanEval
static Function	ConcatEval.instance
static Function	IntersectionEval.instance
static Function	PercentEval.instance
static Function	RangeEval.instance
static Function	UnaryMinusEval.instance
static Function	UnaryPlusEval.instance
static Function	RelationalOperationEval.LessEqualEval
static Function	RelationalOperationEval.LessThanEval
static Function	TwoOperandNumericOperation.MultiplyEval
static Function	RelationalOperationEval.NotEqualEval
static Function	TwoOperandNumericOperation.PowerEval
static Function	TwoOperandNumericOperation.SubtractEval

Methods in org.apache.poi.ss.formula.eval that return Function

Modifier and Type	Method	Description
static Function	FunctionEval.getBasicFunction(int functionIndex)

Methods in org.apache.poi.ss.formula.eval with parameters of type Function

Modifier and Type	Method	Description
static void	FunctionEval.registerFunction(String name, Function func)	Register a new function in runtime.

Uses of Function in org.apache.poi.ss.formula.functions

Subinterfaces of Function in org.apache.poi.ss.formula.functions

Modifier and Type	Interface	Description
interface	Function0Arg	Deprecated. replaced by lambda expressions in 5.0.1
interface	Function1Arg	Implemented by all functions that can be called with one argument
interface	Function2Arg	Implemented by all functions that can be called with two arguments
interface	Function3Arg	Implemented by all functions that can be called with three arguments
interface	Function4Arg	Implemented by all functions that can be called with four arguments

Classes in org.apache.poi.ss.formula.functions that implement Function

Modifier and Type	Class	Description
class	Address	Creates a text reference as text, given specified row and column numbers.
class	AggregateFunction
class	Areas	Returns the number of areas in a reference.
class	BesselJ	Implementation for Excel BESSELJ() function.
class	Bin2Dec	Implementation for Excel Bin2Dec() function.
class	BooleanFunction	Here are the general rules concerning Boolean functions: Blanks are ignored (not either true or false) Strings are ignored if part of an area ref or cell ref, otherwise they must be 'true' or 'false' Numbers: 0 is false.
class	CalendarFieldFunction	Implementation of Excel functions Date parsing functions: Date - DAY, MONTH and YEAR Time - HOUR, MINUTE and SECOND
class	Choose
class	Code	Implementation for Excel CODE () function.
class	Columns	Implementation for Excel COLUMNS function.
class	Complex	Implementation for Excel COMPLEX () function.
class	Correl	Implementation for Excel CORREL() function.
class	Count	Counts the number of cells that contain numeric data within the list of arguments.
class	Counta	Counts the number of cells that contain data within the list of arguments.
class	Countblank	Implementation for the function COUNTBLANK
class	Countif	Implementation for the function COUNTIF
class	Covar	Implementation for Excel COVAR() and COVARIANCE.P() functions.
class	DateFunc	Implementation for the Excel function DATE
class	DateValue	Implementation for the DATEVALUE() Excel function.
class	Days360	Calculates the number of days between two dates based on a 360-day year (twelve 30-day months), 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	DStarRunner	This class performs a D* calculation.
class	Errortype	Implementation for the ERROR.TYPE() Excel function.
class	FactDouble	Implementation for Excel FACTDOUBLE() function.
class	FinanceFunction
class	Fixed
class	Fixed0ArgFunction	Deprecated. replaced by lambda expressions in 5.1.0
class	Fixed1ArgFunction	Convenience base class for functions that must take exactly one argument.
class	Fixed2ArgFunction	Convenience base class for functions that must take exactly two arguments.
class	Fixed3ArgFunction	Convenience base class for functions that must take exactly three arguments.
class	Fixed4ArgFunction	Convenience base class for functions that must take exactly four arguments.
class	Forecast	Implementation for Excel FORECAST() and FORECAST.LINEAR() functions.
class	Frequency	Implementation of Excel 'Analysis ToolPak' function FREQUENCY() Returns a frequency distribution as a vertical array
class	Hex2Dec	Implementation for Excel HEX2DEC() function.
class	Hlookup	Implementation of the HLOOKUP() function.
class	Hyperlink	Implementation of Excel HYPERLINK function.
class	IfFunc	Implementation for the Excel function IF
class	Imaginary	Implementation for Excel IMAGINARY() function.
class	ImReal	Implementation for Excel ImReal() function.
class	Index	Implementation for the Excel function INDEX
class	Intercept	Implementation of Excel function INTERCEPT()
class	IPMT
class	Irr	Calculates the internal rate of return.
class	LinearRegressionFunction	Base class for linear regression functions.
class	LogicalFunction	Implementation of the various ISxxx Logical Functions, which take a single expression argument, and return True or False.
class	Lookup	Implementation of Excel function LOOKUP.
class	Match	Implementation for the MATCH() Excel function.
class	MatrixFunction
static class	MatrixFunction.MutableValueCollector
static class	MatrixFunction.OneArrayArg
static class	MatrixFunction.TwoArrayArg
class	MinaMaxa
class	Mirr	Calculates Modified internal rate of return.
class	Mode
class	MultiOperandNumericFunction	This is the super class for all excel function evaluator classes that take variable number of operands, and where the order of operands does not matter
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	NotImplementedFunction	This is the default implementation of a Function class.
class	Npv	Calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values).
class	NumericFunction
class	Oct2Dec	Implementation for Excel Oct2Dec() function.
class	OverridableFunction	A Overridable function to provide the chance of override poi's basic functions
class	PercentRank	Implementation of 'the Excel function PERCENTRANK() Syntax: PERCENTRANK(array, X, [significance])
class	PPMT	Compute the interest portion of a payment.
class	Quotient	Implementation for Excel QUOTIENT () function.
class	Rank	Returns the rank of a number in a list of numbers.
class	Rate	Implements the Excel Rate function
class	Replace	An implementation of the Excel REPLACE() function:
class	Rept	Implementation for Excel REPT () function.
class	Roman	Implementation for Excel Roman() function.
class	Rows	Implementation for Excel ROWS function.
class	Slope	Implementation of Excel function SLOPE()
class	Standardize	Implementation for Excel STANDARDIZE() function.
class	Substitute	An implementation of the SUBSTITUTE function:
class	Subtotal	Implementation for the Excel function SUBTOTAL
class	Sumif	Implementation for the Excel function SUMIF
class	Sumproduct	Implementation for the Excel function SUMPRODUCT
class	Sumx2my2	Implementation of Excel function SUMX2MY2()
class	Sumx2py2	Implementation of Excel function SUMX2PY2()
class	Sumxmy2	Implementation of Excel function SUMXMY2()
class	T	Implementation of Excel T() function
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	TextFunction
class	TimeFunc	Implementation for the Excel function TIME
class	TimeValue	Implementation for the TIMEVALUE() Excel function.
class	Trend	Implementation for the Excel function TREND
class	Value	Implementation for Excel VALUE() function.
class	Vlookup	Implementation of the VLOOKUP() function.
class	WeekdayFunc	Implementation for the Excel function WEEKDAY
class	WeekNum	Implementation for Excel WeekNum() function.
class	XYNumericFunction

Fields in org.apache.poi.ss.formula.functions declared as Function

Modifier and Type	Field	Description
static Function	NumericFunction.ABS
static Function	NumericFunction.ACOS
static Function	NumericFunction.ACOSH
static Function	BooleanFunction.AND
static Function	NumericFunction.ASIN
static Function	NumericFunction.ASINH
static Function	NumericFunction.ATAN
static Function	NumericFunction.ATAN2
static Function	NumericFunction.ATANH
static Function	AggregateFunction.AVEDEV
static Function	AggregateFunction.AVERAGE
static Function	AggregateFunction.AVERAGEA
static Function	NumericFunction.CEILING
static Function	TextFunction.CHAR	Returns the character specified by a number.
static Function	TextFunction.CLEAN	An implementation of the CLEAN function: In Excel, the Clean function removes all non-printable characters from a string.
static Function	NumericFunction.COMBIN
static Function	TextFunction.CONCATENATE
static Function	NumericFunction.COS
static Function	NumericFunction.COSH
static Function	CalendarFieldFunction.DAY
static Function	NumericFunction.DEGREES
static Function	AggregateFunction.DEVSQ
static Function	NumericFunction.DOLLAR
static Function	NumericFunction.EVEN
static Function	TextFunction.EXACT
static Function	NumericFunction.EXP
static Function	NumericFunction.FACT
static Function	BooleanFunction.FALSE
static Function	TextFunction.FIND	Implementation of the FIND() function.
static Function	NumericFunction.FLOOR
static Function	FinanceFunction.FV
static Function	AggregateFunction.GEOMEAN
static Function	CalendarFieldFunction.HOUR
static Function	DateFunc.instance
static Function	Frequency.instance
static Function	PercentRank.instance
static Function	WeekdayFunc.instance
static Function	NumericFunction.INT
static Function	LogicalFunction.ISBLANK
static Function	LogicalFunction.ISERR	Implementation of Excel ISERR() function.
static Function	LogicalFunction.ISERROR
static Function	LogicalFunction.ISLOGICAL
static Function	LogicalFunction.ISNA	Implementation for Excel ISNA() function.
static Function	LogicalFunction.ISNONTEXT
static Function	LogicalFunction.ISNUMBER
static Function	LogicalFunction.ISREF
static Function	LogicalFunction.ISTEXT
static Function	AggregateFunction.LARGE
static Function	TextFunction.LEFT
static Function	TextFunction.LEN
static Function	NumericFunction.LN
static Function	NumericFunction.LOG
static Function	NumericFunction.LOG10
static Function	TextFunction.LOWER
static Function	AggregateFunction.MAX
static Function	MinaMaxa.MAXA
static Function	MatrixFunction.MDETERM
static Function	AggregateFunction.MEDIAN
static Function	TextFunction.MID	An implementation of the MID function MID returns a specific number of characters from a text string, starting at the specified position.
static Function	AggregateFunction.MIN
static Function	MinaMaxa.MINA
static Function	CalendarFieldFunction.MINUTE
static Function	MatrixFunction.MINVERSE
static Function	MatrixFunction.MMULT
static Function	NumericFunction.MOD
static Function	CalendarFieldFunction.MONTH
static Function	BooleanFunction.NOT
static Function	FinanceFunction.NPER
static Function	NumericFunction.ODD
static Function	BooleanFunction.OR
static Function	AggregateFunction.PERCENTILE
static Function	NumericFunction.PI
static Function	FinanceFunction.PMT
static Function	NumericFunction.POISSON
static Function	NumericFunction.POWER
static Function	AggregateFunction.PRODUCT
static Function	TextFunction.PROPER	Implementation of the PROPER function: Normalizes all words (separated by non-word characters) by making the first letter upper and the rest lower case.
static Function	FinanceFunction.PV
static Function	NumericFunction.RADIANS
static Function	NumericFunction.RAND
static Function	TextFunction.RIGHT
static Function	NumericFunction.ROUND
static Function	NumericFunction.ROUNDDOWN
static Function	NumericFunction.ROUNDUP
static Function	TextFunction.SEARCH	Implementation of the FIND() function.
static Function	CalendarFieldFunction.SECOND
static Function	NumericFunction.SIGN
static Function	NumericFunction.SIN
static Function	NumericFunction.SINH
static Function	AggregateFunction.SMALL
static Function	NumericFunction.SQRT
static Function	AggregateFunction.STDEV
static Function	AggregateFunction.STDEVA
static Function	AggregateFunction.STDEVP
static Function	AggregateFunction.STDEVPA
static Function	AggregateFunction.SUM
static Function	AggregateFunction.SUMSQ
static Function	NumericFunction.TAN
static Function	NumericFunction.TANH
static Function	TextFunction.TEXT	An implementation of the TEXT function TEXT returns a number value formatted with the given number formatting string.
static Function	MatrixFunction.TRANSPOSE
static Function	TextFunction.TRIM	An implementation of the TRIM function: Removes leading and trailing spaces from value if evaluated operand value is string.
static Function	BooleanFunction.TRUE
static Function	NumericFunction.TRUNC
static Function	TextFunction.UPPER
static Function	AggregateFunction.VAR
static Function	AggregateFunction.VARA
static Function	AggregateFunction.VARP
static Function	AggregateFunction.VARPA
static Function	CalendarFieldFunction.YEAR

Constructors in org.apache.poi.ss.formula.functions with parameters of type Function

Constructor	Description
OverridableFunction(String name, Function original)