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 and Description
static void	WorkbookEvaluator.registerFunction(java.lang.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 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
class	UnaryMinusEval
class	UnaryPlusEval

Fields in org.apache.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	PercentEval.instance
static Function	ConcatEval.instance
static Function	RangeEval.instance
static Function	UnaryMinusEval.instance
static Function	IntersectionEval.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 and Description
static Function	FunctionEval.getBasicFunction(int functionIndex)

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

Modifier and Type	Method and Description
static void	FunctionEval.registerFunction(java.lang.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 and 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 and 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	Offset Implementation for Excel function OFFSET()
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 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	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	Frequency.instance
static Function	PercentRank.instance
static Function	WeekdayFunc.instance
static Function	DateFunc.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