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`
`protected static Function[]` | `FunctionEval.functions` Array elements corresponding to unimplemented functions are `null`
`static Function` | `RelationalOperationEval.GreaterEqualEval`
`static Function` | `RelationalOperationEval.GreaterThanEval`
`static Function` | `RangeEval.instance`
`static Function` | `ConcatEval.instance`
`static Function` | `UnaryPlusEval.instance`
`static Function` | `UnaryMinusEval.instance`
`static Function` | `IntersectionEval.instance`
`static Function` | `PercentEval.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` | `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` | `Column`
`class` | `Columns` Implementation for Excel COLUMNS function.
`class` | `Complex` Implementation for Excel COMPLEX () 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` | `Dec2Bin` Implementation for Excel Bin2Dec() function.
`class` | `Dec2Hex` Implementation for Excel DELTA() function.
`class` | `Delta` Implementation for Excel DELTA() function.
`class` | `DStarRunner` This class performs a D* calculation.
`class` | `Errortype` Implementation for the ERROR.TYPE() Excel function.
`class` | `Even`
`class` | `FactDouble` Implementation for Excel FACTDOUBLE() function.
`class` | `FinanceFunction`
`class` | `Fixed`
`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` | `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` | `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` | `Na` Implementation of Excel function NA()
`class` | `NotImplementedFunction` This is the default implementation of a Function class.
`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` | `Oct2Dec` Implementation for Excel Oct2Dec() function.
`class` | `Odd`
`class` | `Offset` Implementation for Excel function OFFSET()
`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 WeekNum() function.
`class` | `RowFunc` Implementation for the Excel function ROW
`class` | `Rows` Implementation for Excel ROWS function.
`class` | `Slope` Implementation of Excel function SLOPE()
`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` | `TextFunction`
`class` | `TimeFunc` Implementation for the Excel function TIME
`class` | `Today` Implementation of Excel TODAY() Function
`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
`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.
`static Function` | `NumericFunction.FLOOR`
`static Function` | `FinanceFunction.FV`
`static Function` | `CalendarFieldFunction.HOUR`
`static Function` | `DateFunc.instance`
`static Function` | `WeekdayFunc.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` | `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` | `NumericFunction.MOD`
`static Function` | `CalendarFieldFunction.MONTH`
`static Function` | `BooleanFunction.NOT`
`static Function` | `FinanceFunction.NPER`
`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.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

Copyright 2017 The Apache Software Foundation or its licensors, as applicable.