Uses of Interface
org.zkoss.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.zkoss.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
org.zkoss.poi.ss.formula.eval
org.zkoss.poi.ss.formula.functions

Uses of Function in io.keikaiex.formula

Classes in io.keikaiex.formula that implement Function

Modifier and Type	Class and 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

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

Modifier and Type	Field and 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	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.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.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.zkoss.poi.ss.formula

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

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

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

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

Modifier and Type	Class and 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
static class	TwoOperandNumericOperation.MultiplyFunc
class	UnaryMinusEval
class	UnaryPlusEval

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

Modifier and Type	Field and 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	UnaryPlusEval.instance
static Function	UnaryMinusEval.instance
static Function	RangeEval.instance
static Function	PercentEval.instance
static Function	IntersectionEval.instance
static Function	ConcatEval.instance
static Function	RelationalOperationEval.LessEqualEval
static Function	RelationalOperationEval.LessThanEval
static Function	RelationalOperationEval.NotEqualEval
static Function	TwoOperandNumericOperation.PowerEval
static Function	TwoOperandNumericOperation.SubtractEval

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

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

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

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

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

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

Modifier and Type	Interface and Description
interface	Function0Arg Implemented by all functions that can be called with zero arguments
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.zkoss.poi.ss.formula.functions that implement Function

Modifier and Type	Class and Description
class	Address Creates a text reference as text, given specified row and column numbers.
class	AggregateFunction
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.
static class	BooleanFunction.OneArg
class	CalendarFieldFunction Implementation of Excel functions Date parsing functions: Date - DAY, MONTH and YEAR Time - HOUR, MINUTE and SECOND
class	Choose
class	Column
class	Columns Implementation for Excel COLUMNS 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	DateFunc Implementation for the Excel function DATE
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	Errortype Implementation for the ERROR.TYPE() Excel function.
class	Even
class	FinanceFunction
class	Fixed0ArgFunction Convenience base class for functions that only take zero arguments.
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	Hlookup Implementation of the HLOOKUP() function. HLOOKUP finds a column in a lookup table by the first row value and returns the value from another row. Syntax: HLOOKUP(lookup_value, table_array, row_index_num, range_lookup) lookup_value The value to be found in the first column of the table array. table_array An area reference for the lookup data.
class	Hyperlink Implementation of Excel HYPERLINK function. In Excel this function has special behaviour - it causes the displayed cell value to behave like a hyperlink in the GUI.
class	IfFunc Implementation for the Excel function IF
class	Index Implementation for the Excel function INDEX
class	Irr Calculates the internal rate of return.
class	LogicalFunction
class	Lookup Implementation of Excel function LOOKUP. LOOKUP finds an index row in a lookup table by the first column value and returns the value from another column.
class	Match Implementation for the MATCH() Excel function. Syntax: MATCH(lookup_value, lookup_array, match_type) Returns a 1-based index specifying at what position in the lookup_array the specified lookup_value is found. Specific matching behaviour can be modified with the optional match_type parameter.
class	MinaMaxa
class	Mode
class	MultiOperandNumericFunction
class	Na Implementation of Excel function NA()
class	NotImplementedFunction
class	Now Implementation of Excel NOW() Function
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
static class	NumericFunction.OneArg
static class	NumericFunction.TwoArg
class	Odd
class	Offset Implementation for Excel function OFFSET() OFFSET returns an area reference that is a specified number of rows and columns from a reference cell or area. Syntax: OFFSET(reference, rows, cols, height, width) reference is the base reference. rows is the number of rows up or down from the base reference. cols is the number of columns left or right from the base reference. height (default same height as base reference) is the row count for the returned area reference. width (default same width as base reference) is the column count for the returned area reference.
class	OverridableFunction A Overridable function to provide the chance of override poi's basic functions
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: Replaces part of a text string based on the number of characters you specify, with another text string. Syntax: REPLACE(oldText, startNum, numChars, newText) oldText The text string containing characters to replace startNum The position of the first character to replace (1-based) numChars The number of characters to replace newText The new text value to replace the removed section
class	RowFunc Implementation for the Excel function ROW
class	Rows Implementation for Excel ROWS function.
class	Substitute An implementation of the SUBSTITUTE function: Substitutes text in a text string with new text, some number of times.
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() Calculates the sum of differences of squares in two arrays of the same size. Syntax: SUMX2MY2(arrayX, arrayY) result = Σi: 0..n(xi2-yi2)
class	Sumx2py2 Implementation of Excel function SUMX2PY2() Calculates the sum of squares in two arrays of the same size. Syntax: SUMX2PY2(arrayX, arrayY) result = Σi: 0..n(xi2+yi2)
class	Sumxmy2 Implementation of Excel function SUMXMY2() Calculates the sum of squares of differences between two arrays of the same size. Syntax: SUMXMY2(arrayX, arrayY) result = Σi: 0..n(xi-yi)2
class	T Implementation of Excel T() function If the argument is a text or error value it is returned unmodified.
class	TextFunction
class	TimeFunc Implementation for the Excel function TIME
class	Today Implementation of Excel TODAY() Function
class	Value Implementation for Excel VALUE() function. Syntax: VALUE(text) Converts the text argument to a number.
class	Vlookup Implementation of the VLOOKUP() function. VLOOKUP finds a row in a lookup table by the first column value and returns the value from another column. Syntax: VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) lookup_value The value to be found in the first column of the table array. table_array An area reference for the lookup data.
class	WeekdayFunc Implementation for the Excel function WEEKDAY
class	XYNumericFunction

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

Modifier and Type	Field and 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	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	TextFunction.EXACT
static Function	NumericFunction.EXP
static Function	NumericFunction.FACT
static Function	BooleanFunction.FALSE
static Function	TextFunction.FIND Implementation of the FIND() function. Syntax: FIND(find_text, within_text, start_num) FIND returns the character position of the first (case sensitive) occurrence of find_text inside within_text.
static Function	NumericFunction.FLOOR
static Function	FinanceFunction.FV
static Function	CalendarFieldFunction.HOUR
static Function	WeekdayFunc.instance
static Function	DateFunc.instance
static Function	NumericFunction.INT
static Function	LogicalFunction.ISBLANK
static Function	LogicalFunction.ISERROR
static Function	LogicalFunction.ISLOGICAL
static Function	LogicalFunction.ISNA Implementation for Excel ISNA() function. Syntax: ISNA(value) value The value to be tested Returns TRUE if the specified value is '#N/A', FALSE otherwise.
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	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. Syntax: MID(text, start_num, num_chars) Author: Manda Wilson < wilson at c bio dot msk cc dot org >
static Function	AggregateFunction.MIN
static Function	MinaMaxa.MINA
static Function	CalendarFieldFunction.MINUTE
static Function	NumericFunction.MOD
static Function	CalendarFieldFunction.MONTH
static Function	BooleanFunction.NOT
static Function	FinanceFunction.NPER
static Function	BooleanFunction.OR
static Function	NumericFunction.PI
static Function	FinanceFunction.PMT
static Function	NumericFunction.POISSON
static Function	NumericFunction.POWER
static Function	AggregateFunction.PRODUCT
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. Syntax: SEARCH(find_text, within_text, start_num) SEARCH is a case-insensitive version of FIND()
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.STDEVP
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	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.VARP
static Function	CalendarFieldFunction.YEAR

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

Constructor and Description
OverridableFunction(String name, Function original)