Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

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

Packages that use Function
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
`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
`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
`static Function` | `TwoOperandNumericOperation.AddEval`
`static Function` | `TwoOperandNumericOperation.DivideEval`
`static Function` | `RelationalOperationEval.EqualEval`
`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` | `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
`static Function` | `FunctionEval.getBasicFunction(int functionIndex)`

Methods in org.apache.poi.ss.formula.eval with parameters of type Function
`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
`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.apache.poi.ss.formula.functions that implement Function
`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.
`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` | `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` | `XYNumericFunction`

Fields in org.apache.poi.ss.formula.functions declared as Function
`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` | `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.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`

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES