|
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 |
|