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

Packages that use Function

Package	Description
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 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
final class	ConcatEval	Implementation of Excel formula token '&'.
final class	IntersectionEval
final class	PercentEval	Implementation of Excel formula token '%'.
final class	RangeEval
class	RelationalOperationEval	Base class for all comparison operator evaluators
class	TwoOperandNumericOperation
final class	UnaryMinusEval
final class	UnaryPlusEval

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

Modifier and Type	Field	Description
static final Function	TwoOperandNumericOperation.AddEval
static final Function	TwoOperandNumericOperation.DivideEval
static final Function	RelationalOperationEval.EqualEval
static final Function	RelationalOperationEval.GreaterEqualEval
static final Function	RelationalOperationEval.GreaterThanEval
static final Function	ConcatEval.instance
static final Function	IntersectionEval.instance
static final Function	PercentEval.instance
static final Function	RangeEval.instance
static final Function	UnaryMinusEval.instance
static final Function	UnaryPlusEval.instance
static final Function	RelationalOperationEval.LessEqualEval
static final Function	RelationalOperationEval.LessThanEval
static final Function	TwoOperandNumericOperation.MultiplyEval
static final Function	RelationalOperationEval.NotEqualEval
static final Function	TwoOperandNumericOperation.PowerEval
static final 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)
static Function	FunctionEval.getBasicFunctionOrNull(int functionIndex)	Like FunctionEval.getBasicFunction(int), but answers null instead of throwing for a function that is not implemented (or for an unknown index), so callers that only want to inspect a function do not pay for an exception.

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	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
final class	Areas	Returns the number of areas in a reference.
final 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.
final class	CalendarFieldFunction	Implementation of Excel functions Date parsing functions: Date - DAY, MONTH and YEAR Time - HOUR, MINUTE and SECOND
final class	Choose
class	Code	Implementation for Excel CODE () function.
final class	Columns	Implementation for Excel COLUMNS function.
class	Complex	Implementation for Excel COMPLEX () function.
class	Correl	Implementation for Excel CORREL() function.
final class	Count	Counts the number of cells that contain numeric data within the list of arguments.
final class	Counta	Counts the number of cells that contain data within the list of arguments.
final class	Countblank	Implementation for the function COUNTBLANK
final class	Countif	Implementation for the function COUNTIF
class	Covar	Implementation for Excel COVAR() and COVARIANCE.P() functions.
final 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.
final class	Dec2Hex	Implementation for Excel DEC2HEX() function.
final class	Delta	Implementation for Excel DELTA() function.
final class	DollarDe	Implementation for Excel DOLLARDE() function.
final class	DollarFr	Implementation for Excel DOLLARFR() function.
final class	DStarRunner	This class performs a D* calculation.
final class	Errortype	Implementation for the ERROR.TYPE() Excel function.
class	FactDouble	Implementation for Excel FACTDOUBLE() function.
class	FinanceFunction
final class	Fixed
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.
final class	Hlookup	Implementation of the HLOOKUP() function.
final class	Hyperlink	Implementation of Excel HYPERLINK function.
final class	IfFunc	Implementation for the Excel function IF
class	Imaginary	Implementation for Excel IMAGINARY() function.
class	ImReal	Implementation for Excel ImReal() function.
final class	Index	Implementation for the Excel function INDEX
final class	Intercept	Implementation of Excel function INTERCEPT()
class	IPMT
final class	Irr	Calculates the internal rate of return.
final 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.
final class	Lookup	Implementation of Excel function LOOKUP.
final class	Match	Implementation for the MATCH() Excel function.
class	MatrixFunction
static final class	MatrixFunction.MutableValueCollector
static class	MatrixFunction.OneArrayArg
static class	MatrixFunction.TwoArrayArg
class	MinaMaxa
class	Mirr	Calculates Modified internal rate of return.
final 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
final class	NormDist	Implementation for Excel NORMDIST() and NORM.DIST() functions.
final class	NormInv	Implementation for Excel NORMINV() and NORM.INV() functions.
final class	NormSDist	Implementation for Excel NORMSDIST() and NORM.S.DIST functions.
final class	NormSInv	Implementation for Excel NORMSINV() and NORM.S.INV() functions.
final class	NotImplementedFunction	This is the default implementation of a Function class.
final 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.
final class	Offset	Implementation for Excel function OFFSET()
final 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
final class	Replace	An implementation of the Excel REPLACE() function:
class	Rept	Implementation for Excel REPT () function.
class	Roman	Implementation for Excel Roman() function.
final class	Rows	Implementation for Excel ROWS function.
final class	Slope	Implementation of Excel function SLOPE()
final class	Standardize	Implementation for Excel STANDARDIZE() function.
final class	Substitute	An implementation of the SUBSTITUTE function:
class	Subtotal	Implementation for the Excel function SUBTOTAL
final class	Sumif	Implementation for the Excel function SUMIF
final class	Sumproduct	Implementation for the Excel function SUMPRODUCT
final class	Sumx2my2	Implementation of Excel function SUMX2MY2()
final class	Sumx2py2	Implementation of Excel function SUMX2PY2()
final class	Sumxmy2	Implementation of Excel function SUMXMY2()
final class	T	Implementation of Excel T() function
final class	TDist	Implementation for Excel TDIST() function.
final class	TDist2t	Implementation for Excel T.DIST.2T() function.
final class	TDistLt	Implementation for Excel T.DIST() function.
final class	TDistRt	Implementation for Excel T.DIST.RT() function.
class	TextFunction
final class	TimeFunc	Implementation for the Excel function TIME
class	TimeValue	Implementation for the TIMEVALUE() Excel function.
final class	Trend	Implementation for the Excel function TREND
final class	Value	Implementation for Excel VALUE() function.
final class	Vlookup	Implementation of the VLOOKUP() function.
final 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 final Function	NumericFunction.ABS
static final Function	NumericFunction.ACOS
static final Function	NumericFunction.ACOSH
static final Function	BooleanFunction.AND
static final Function	NumericFunction.ASIN
static final Function	NumericFunction.ASINH
static final Function	NumericFunction.ATAN
static final Function	NumericFunction.ATAN2
static final Function	NumericFunction.ATANH
static final Function	AggregateFunction.AVEDEV
static final Function	AggregateFunction.AVERAGE
static final Function	AggregateFunction.AVERAGEA
static final Function	NumericFunction.CEILING
static final Function	TextFunction.CHAR	Returns the character specified by a number.
static final Function	TextFunction.CLEAN	An implementation of the CLEAN function: In Excel, the Clean function removes all non-printable characters from a string.
static final Function	NumericFunction.COMBIN
static final Function	TextFunction.CONCATENATE
static final Function	NumericFunction.COS
static final Function	NumericFunction.COSH
static final Function	CalendarFieldFunction.DAY
static final Function	NumericFunction.DEGREES
static final Function	AggregateFunction.DEVSQ
static final Function	NumericFunction.DOLLAR
static final Function	NumericFunction.EVEN
static final Function	TextFunction.EXACT
static final Function	NumericFunction.EXP
static final Function	NumericFunction.FACT
static final Function	BooleanFunction.FALSE
static final Function	TextFunction.FIND	Implementation of the FIND() function.
static final Function	NumericFunction.FLOOR
static final Function	FinanceFunction.FV
static final Function	AggregateFunction.GEOMEAN
static final Function	CalendarFieldFunction.HOUR
static final Function	DateFunc.instance
static final Function	Frequency.instance
static final Function	PercentRank.instance
static final Function	WeekdayFunc.instance
static final Function	NumericFunction.INT
static final Function	LogicalFunction.ISBLANK
static final Function	LogicalFunction.ISERR	Implementation of Excel ISERR() function.
static final Function	LogicalFunction.ISERROR
static final Function	LogicalFunction.ISLOGICAL
static final Function	LogicalFunction.ISNA	Implementation for Excel ISNA() function.
static final Function	LogicalFunction.ISNONTEXT
static final Function	LogicalFunction.ISNUMBER
static final Function	LogicalFunction.ISREF
static final Function	LogicalFunction.ISTEXT
static final Function	AggregateFunction.LARGE
static final Function	TextFunction.LEFT
static final Function	TextFunction.LEN
static final Function	NumericFunction.LN
static final Function	NumericFunction.LOG
static final Function	NumericFunction.LOG10
static final Function	TextFunction.LOWER
static final Function	AggregateFunction.MAX
static final Function	MinaMaxa.MAXA
static final Function	MatrixFunction.MDETERM
static final Function	AggregateFunction.MEDIAN
static final 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 final Function	AggregateFunction.MIN
static final Function	MinaMaxa.MINA
static final Function	CalendarFieldFunction.MINUTE
static final Function	MatrixFunction.MINVERSE
static final Function	MatrixFunction.MMULT
static final Function	NumericFunction.MOD
static final Function	CalendarFieldFunction.MONTH
static final Function	BooleanFunction.NOT
static final Function	FinanceFunction.NPER
static final Function	NumericFunction.ODD
static final Function	BooleanFunction.OR
static final Function	AggregateFunction.PERCENTILE
static final Function	NumericFunction.PI
static final Function	FinanceFunction.PMT
static final Function	NumericFunction.POISSON
static final Function	NumericFunction.POWER
static final Function	AggregateFunction.PRODUCT
static final 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 final Function	FinanceFunction.PV
static final Function	NumericFunction.RADIANS
static final Function	NumericFunction.RAND
static final Function	TextFunction.RIGHT
static final Function	NumericFunction.ROUND
static final Function	NumericFunction.ROUNDDOWN
static final Function	NumericFunction.ROUNDUP
static final Function	TextFunction.SEARCH	Implementation of the FIND() function.
static final Function	CalendarFieldFunction.SECOND
static final Function	NumericFunction.SIGN
static final Function	NumericFunction.SIN
static final Function	NumericFunction.SINH
static final Function	AggregateFunction.SMALL
static final Function	NumericFunction.SQRT
static final Function	AggregateFunction.STDEV
static final Function	AggregateFunction.STDEVA
static final Function	AggregateFunction.STDEVP
static final Function	AggregateFunction.STDEVPA
static final Function	AggregateFunction.SUM
static final Function	AggregateFunction.SUMSQ
static final Function	NumericFunction.TAN
static final Function	NumericFunction.TANH
static final Function	TextFunction.TEXT	An implementation of the TEXT function TEXT returns a number value formatted with the given number formatting string.
static final Function	MatrixFunction.TRANSPOSE
static final Function	TextFunction.TRIM	An implementation of the TRIM function: Removes leading and trailing spaces from value if evaluated operand value is string.
static final Function	BooleanFunction.TRUE
static final Function	NumericFunction.TRUNC
static final Function	TextFunction.UPPER
static final Function	AggregateFunction.VAR
static final Function	AggregateFunction.VARA
static final Function	AggregateFunction.VARP
static final Function	AggregateFunction.VARPA
static final Function	CalendarFieldFunction.YEAR