Interface | Description |
---|---|
ArrayFunction | |
ArrayMode |
Interface for those functions that evaluate arguments in array mode depending on context.
|
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 | Description |
---|---|
Address |
Creates a text reference as text, given specified row and column numbers.
|
AggregateFunction | |
Areas |
Returns the number of areas in a reference.
|
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.
|
DMax |
Implementation of the DMax function:
Finds the maximum 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.
|
DSum |
Implementation of the DSum function:
Finds the total value of matching values in a column in an area with given conditions.
|
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.
|
Frequency |
Implementation of Excel 'Analysis ToolPak' function FREQUENCY()
Returns a frequency distribution as a vertical array |
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.
|
MatrixFunction | |
MatrixFunction.MutableValueCollector | |
MatrixFunction.OneArrayArg | |
MatrixFunction.TwoArrayArg | |
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
|
Trend |
Implementation for the Excel function TREND
|
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 | Description |
---|---|
DStarRunner.DStarAlgorithmEnum |
Enum for convenience to identify and source implementations of the D* functions
|
LinearRegressionFunction.FUNCTION | |
MultiOperandNumericFunction.Policy |
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.