Package org.apache.poi.ss.formula.functions

Interface Summary

Interface	Description
ArrayFunction
ArrayMode	Interface for those functions that evaluate arguments in array mode depending on context.
FreeRefFunction	For most Excel functions, involving references ((cell, area), (2d, 3d)), the references are passed in as arguments, and the exact location remains fixed.
Function	Common interface for all implementations of Excel built-in functions.
Function0Arg	Implemented by all functions that can be called with zero arguments
Function1Arg	Implemented by all functions that can be called with one argument
Function2Arg	Implemented by all functions that can be called with two arguments
Function3Arg	Implemented by all functions that can be called with three arguments
Function4Arg	Implemented by all functions that can be called with four arguments
IDStarAlgorithm	Interface specifying how an algorithm to be used by DStarRunner should look like.
XYNumericFunction.Accumulator

Class Summary

Class	Description
Address	Creates a text reference as text, given specified row and column numbers.
AggregateFunction
Areas	Returns the number of areas in a reference.
BaseNumberUtils	Some utils for converting from and to any base
Bin2Dec	Implementation for Excel Bin2Dec() function.
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.
CalendarFieldFunction	Implementation of Excel functions Date parsing functions: Date - DAY, MONTH and YEAR Time - HOUR, MINUTE and SECOND
Choose
Code	Implementation for Excel CODE () function.
Column
Columns	Implementation for Excel COLUMNS function.
Complex	Implementation for Excel COMPLEX () function.
Count	Counts the number of cells that contain numeric data within the list of arguments.
Counta	Counts the number of cells that contain data within the list of arguments.
Countblank	Implementation for the function COUNTBLANK
Countif	Implementation for the function COUNTIF
Countif.ErrorMatcher
Countif.StringMatcher
Countifs	Implementation for the function COUNTIFS
DateFunc	Implementation for the Excel function DATE
DateValue	Implementation for the DATEVALUE() Excel function.
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.
Dec2Bin	Implementation for Excel Bin2Dec() function.
Dec2Hex	Implementation for Excel DELTA() function.
Delta	Implementation for Excel DELTA() function.
DGet	Implementation of the DGet function: Finds the value of a column in an area with given conditions.
DMax	Implementation of the DMax function: Finds the maximum value of a column in an area with given conditions.
DMin	Implementation of the DMin function: Finds the minimum value of a column in an area with given conditions.
DStarRunner	This class performs a D* calculation.
DSum	Implementation of the DSum function: Finds the total value of matching values in a column in an area with given conditions.
EDate	Implementation for Excel EDATE () function.
EOMonth	Implementation for the Excel EOMONTH() function.
Errortype	Implementation for the ERROR.TYPE() Excel function.
Even
FactDouble	Implementation for Excel FACTDOUBLE() function.
Finance	Implementation of the financial functions pmt, fv, ppmt, ipmt.
FinanceFunction
FinanceLib
Fixed
Fixed0ArgFunction	Convenience base class for functions that only take zero arguments.
Fixed1ArgFunction	Convenience base class for functions that must take exactly one argument.
Fixed2ArgFunction	Convenience base class for functions that must take exactly two arguments.
Fixed3ArgFunction	Convenience base class for functions that must take exactly three arguments.
Fixed4ArgFunction	Convenience base class for functions that must take exactly four arguments.
Frequency	Implementation of Excel 'Analysis ToolPak' function FREQUENCY() Returns a frequency distribution as a vertical array
Hex2Dec	Implementation for Excel HEX2DEC() function.
Hlookup	Implementation of the HLOOKUP() function.
Hyperlink	Implementation of Excel HYPERLINK function.
IfFunc	Implementation for the Excel function IF
Imaginary	Implementation for Excel IMAGINARY() function.
ImReal	Implementation for Excel ImReal() function.
Index	Implementation for the Excel function INDEX
Indirect	Implementation for Excel function INDIRECT
Intercept	Implementation of Excel function INTERCEPT()
IPMT
Irr	Calculates the internal rate of return.
LinearRegressionFunction	Base class for linear regression functions.
LogicalFunction	Implementation of the various ISxxx Logical Functions, which take a single expression argument, and return True or False.
Lookup	Implementation of Excel function LOOKUP.
Match	Implementation for the MATCH() Excel function.
MatrixFunction
MatrixFunction.MutableValueCollector
MatrixFunction.OneArrayArg
MatrixFunction.TwoArrayArg
MinaMaxa
Mirr	Calculates Modified internal rate of return.
Mode
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
Na	Implementation of Excel function NA()
NotImplementedFunction	This is the default implementation of a Function class.
Now	Implementation of Excel NOW() Function
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).
NumericFunction
NumericFunction.OneArg
NumericFunction.TwoArg
Oct2Dec	Implementation for Excel Oct2Dec() function.
Odd
Offset	Implementation for Excel function OFFSET()
PPMT	Compute the interest portion of a payment.
Quotient	Implementation for Excel QUOTIENT () function.
Rank	Returns the rank of a number in a list of numbers.
Rate	Implements the Excel Rate function
Replace	An implementation of the Excel REPLACE() function:
Rept	Implementation for Excel REPT () function.
Roman	Implementation for Excel Roman() function.
RowFunc	Implementation for the Excel function ROW
Rows	Implementation for Excel ROWS function.
Slope	Implementation of Excel function SLOPE()
Substitute	An implementation of the SUBSTITUTE function:
Subtotal	Implementation for the Excel function SUBTOTAL
Sumif	Implementation for the Excel function SUMIF
Sumifs	Implementation for the Excel function SUMIFS
Sumproduct	Implementation for the Excel function SUMPRODUCT
Sumx2my2	Implementation of Excel function SUMX2MY2()
Sumx2py2	Implementation of Excel function SUMX2PY2()
Sumxmy2	Implementation of Excel function SUMXMY2()
T	Implementation of Excel T() function
TextFunction
TimeFunc	Implementation for the Excel function TIME
Today	Implementation of Excel TODAY() Function
Trend	Implementation for the Excel function TREND
Value	Implementation for Excel VALUE() function.
Vlookup	Implementation of the VLOOKUP() function.
WeekdayFunc	Implementation for the Excel function WEEKDAY
WeekNum	Implementation for Excel WeekNum() function.
XYNumericFunction

Enum Summary

Enum	Description
DStarRunner.DStarAlgorithmEnum	Enum for convenience to identify and source implementations of the D* functions
LinearRegressionFunction.FUNCTION
MultiOperandNumericFunction.Policy