Uses of Interface
org.apache.poi.ss.formula.functions.Function
Packages that use Function
Package
Description
This package contains common internal POI code for manipulating formulas.
-
Uses of Function in org.apache.poi.ss.formula
Methods in org.apache.poi.ss.formula with parameters of type FunctionModifier and TypeMethodDescriptionstatic 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 FunctionModifier and TypeClassDescriptionfinal class
final class
final class
Implementation of Excel formula token '%'.final class
class
Base class for all comparison operator evaluatorsclass
final class
final class
Fields in org.apache.poi.ss.formula.eval declared as FunctionModifier and TypeFieldDescriptionstatic final Function
TwoOperandNumericOperation.AddEval
static final Function
TwoOperandNumericOperation.DivideEval
static final Function
RelationalOperationEval.EqualEval
protected static final Function[]
FunctionEval.functions
Array elements corresponding to unimplemented functions arenull
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 FunctionModifier and TypeMethodDescriptionstatic Function
FunctionEval.getBasicFunction
(int functionIndex) Methods in org.apache.poi.ss.formula.eval with parameters of type FunctionModifier and TypeMethodDescriptionstatic 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.functionsModifier and TypeInterfaceDescriptioninterface
Implemented by all functions that can be called with zero argumentsinterface
Implemented by all functions that can be called with one argumentinterface
Implemented by all functions that can be called with two argumentsinterface
Implemented by all functions that can be called with three argumentsinterface
Implemented by all functions that can be called with four argumentsClasses in org.apache.poi.ss.formula.functions that implement FunctionModifier and TypeClassDescriptionclass
Creates a text reference as text, given specified row and column numbers.class
final class
Returns the number of areas in a reference.class
Implementation for Excel Bin2Dec() function.class
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
Implementation of Excel functions Date parsing functions: Date - DAY, MONTH and YEAR Time - HOUR, MINUTE and SECONDfinal class
class
Implementation for Excel CODE () function.final class
final class
Implementation for Excel COLUMNS function.class
Implementation for Excel COMPLEX () function.final class
Counts the number of cells that contain numeric data within the list of arguments.final class
Counts the number of cells that contain data within the list of arguments.final class
Implementation for the function COUNTBLANKfinal class
Implementation for the function COUNTIFfinal class
Implementation for the Excel function DATEclass
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
Implementation for Excel Bin2Dec() function.final class
Implementation for Excel DELTA() function.final class
Implementation for Excel DELTA() function.final class
This class performs a D* calculation.final class
Implementation for the ERROR.TYPE() Excel function.final class
class
Implementation for Excel FACTDOUBLE() function.class
final class
class
Convenience base class for functions that only take zero arguments.class
Convenience base class for functions that must take exactly one argument.class
Convenience base class for functions that must take exactly two arguments.class
Convenience base class for functions that must take exactly three arguments.class
Convenience base class for functions that must take exactly four arguments.class
Implementation of Excel 'Analysis ToolPak' function FREQUENCY()
Returns a frequency distribution as a vertical arrayclass
Implementation for Excel HEX2DEC() function.final class
Implementation of the HLOOKUP() function.final class
Implementation of Excel HYPERLINK function.final class
Implementation for the Excel function IFclass
Implementation for Excel IMAGINARY() function.class
Implementation for Excel ImReal() function.final class
Implementation for the Excel function INDEXfinal class
Implementation of Excel function INTERCEPT()class
final class
Calculates the internal rate of return.final class
Base class for linear regression functions.class
Implementation of the various ISxxx Logical Functions, which take a single expression argument, and return True or False.final class
Implementation of Excel function LOOKUP.final class
Implementation for the MATCH() Excel function.class
static final class
static class
static class
class
class
Calculates Modified internal rate of return.final class
class
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 matterfinal class
Implementation of Excel function NA()final class
This is the default implementation of a Function class.final class
Implementation of Excel NOW() Functionfinal class
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
static class
static class
class
Implementation for Excel Oct2Dec() function.final class
final class
Implementation for Excel function OFFSET()class
Compute the interest portion of a payment.class
Implementation for Excel QUOTIENT () function.class
Returns the rank of a number in a list of numbers.class
Implements the Excel Rate functionfinal class
An implementation of the Excel REPLACE() function:class
Implementation for Excel REPT () function.class
Implementation for Excel WeekNum() function.final class
Implementation for the Excel function ROWfinal class
Implementation for Excel ROWS function.final class
Implementation of Excel function SLOPE()final class
An implementation of the SUBSTITUTE function:class
Implementation for the Excel function SUBTOTALfinal class
Implementation for the Excel function SUMIFfinal class
Implementation for the Excel function SUMPRODUCTfinal class
Implementation of Excel function SUMX2MY2()final class
Implementation of Excel function SUMX2PY2()final class
Implementation of Excel function SUMXMY2()final class
Implementation of Excel T() functionclass
final class
Implementation for the Excel function TIMEfinal class
Implementation of Excel TODAY() Functionfinal class
Implementation for the Excel function TRENDfinal class
Implementation for Excel VALUE() function.final class
Implementation of the VLOOKUP() function.final class
Implementation for the Excel function WEEKDAYclass
Implementation for Excel WeekNum() function.class
Fields in org.apache.poi.ss.formula.functions declared as FunctionModifier and TypeFieldDescriptionstatic 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
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
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
CalendarFieldFunction.HOUR
static final Function
DateFunc.instance
static final Function
Frequency.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
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.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.VARP
static final Function
CalendarFieldFunction.YEAR