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 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 Description class
ConcatEval
class
IntersectionEval
class
PercentEval
Implementation of Excel formula token '%'.class
RangeEval
class
RelationalOperationEval
Base class for all comparison operator evaluatorsclass
TwoOperandNumericOperation
class
UnaryMinusEval
class
UnaryPlusEval
Fields in org.apache.poi.ss.formula.eval declared as Function Modifier and Type Field Description static Function
TwoOperandNumericOperation. AddEval
static Function
TwoOperandNumericOperation. DivideEval
static Function
RelationalOperationEval. EqualEval
protected static Function[]
FunctionEval. functions
Array elements corresponding to unimplemented functions arenull
static Function
RelationalOperationEval. GreaterEqualEval
static Function
RelationalOperationEval. GreaterThanEval
static Function
ConcatEval. instance
static Function
IntersectionEval. instance
static Function
PercentEval. instance
static Function
RangeEval. instance
static Function
UnaryMinusEval. 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 Description static Function
FunctionEval. getBasicFunction(int functionIndex)
Methods in org.apache.poi.ss.formula.eval with parameters of type Function Modifier and Type Method 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 Description interface
Function0Arg
Implemented by all functions that can be called with zero argumentsinterface
Function1Arg
Implemented by all functions that can be called with one argumentinterface
Function2Arg
Implemented by all functions that can be called with two argumentsinterface
Function3Arg
Implemented by all functions that can be called with three argumentsinterface
Function4Arg
Implemented by all functions that can be called with four argumentsClasses in org.apache.poi.ss.formula.functions that implement Function Modifier and Type Class 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
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 SECONDclass
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 COUNTBLANKclass
Countif
Implementation for the function COUNTIFclass
DateFunc
Implementation for the Excel function DATEclass
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
Frequency
Implementation of Excel 'Analysis ToolPak' function FREQUENCY()
Returns a frequency distribution as a vertical arrayclass
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 IFclass
Imaginary
Implementation for Excel IMAGINARY() function.class
ImReal
Implementation for Excel ImReal() function.class
Index
Implementation for the Excel function INDEXclass
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 matterclass
Na
Implementation of Excel function NA()class
NotImplementedFunction
This is the default implementation of a Function class.class
Now
Implementation of Excel NOW() Functionclass
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 functionclass
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 ROWclass
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 SUBTOTALclass
Sumif
Implementation for the Excel function SUMIFclass
Sumproduct
Implementation for the Excel function SUMPRODUCTclass
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() functionclass
TextFunction
class
TimeFunc
Implementation for the Excel function TIMEclass
Today
Implementation of Excel TODAY() Functionclass
Trend
Implementation for the Excel function TRENDclass
Value
Implementation for Excel VALUE() function.class
Vlookup
Implementation of the VLOOKUP() function.class
WeekdayFunc
Implementation for the Excel function WEEKDAYclass
WeekNum
Implementation for Excel WeekNum() function.class
XYNumericFunction
Fields in org.apache.poi.ss.formula.functions declared as Function Modifier and Type Field 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
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
Frequency. 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
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
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
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. VARP
static Function
CalendarFieldFunction. YEAR
-