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

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

Interface Summary
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
Address | Creates a text reference as text, given specified row and column numbers.
AggregateFunction |
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
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.
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.
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.
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.
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 WeekNum() 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
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
DStarRunner.DStarAlgorithmEnum |
LinearRegressionFunction.FUNCTION |

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

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