| Address |
Creates a text reference as text, given specified row and column numbers.
|
| AggregateFunction |
|
| Areas |
Returns the number of areas in a reference.
|
| AverageIf |
Handler for singular AverageIf which has different operand handling than
the generic AverageIfs version.
|
| Averageifs |
Implementation for the Excel function AVERAGEIFS
|
| BaseNumberUtils |
Some utils for converting from and to any base
|
| BesselJ |
Implementation for Excel BESSELJ() function.
|
| 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
|
| CeilingMath |
Implementation for Excel CEILING.MATH() function.
|
| CeilingPrecise |
Implementation for Excel CEILING.PRECISE() function.
|
| Choose |
|
| Code |
Implementation for Excel CODE () function.
|
| Column |
|
| Columns |
Implementation for Excel COLUMNS function.
|
| Complex |
Implementation for Excel COMPLEX () function.
|
| ComplexEx |
|
| ComplexFormat |
|
| Correl |
Implementation for Excel CORREL() 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
|
| Covar |
Implementation for Excel COVAR() and COVARIANCE.P() functions.
|
| DateFunc |
Implementation for the Excel function DATE
|
| DateValue |
Implementation for the DATEVALUE() Excel function.
|
| DAverage |
Implementation of the DAverage function:
Gets the average value of a column in an area with given conditions.
|
| Days |
Calculates the number of days between two dates based on a real year,
which is used in some accounting calculations.
|
| 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.
|
| DCount |
Implementation of the DCount function:
Counts the number of numeric cells in a column in an area with given conditions.
|
| DCountA |
Implementation of the DCountA function:
Counts the number of non-blank cells in a column in an area with given conditions.
|
| Dec2Bin |
Implementation for Excel DEC2BIN() 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.
|
| DollarDe |
Implementation for Excel DOLLARDE() function.
|
| DollarFr |
Implementation for Excel DOLLARFR() function.
|
| DProduct |
Implementation of the DProduct function:
Gets the product value of a column in an area with given conditions.
|
| DStarRunner |
This class performs a D* calculation.
|
| DStdev |
Implementation of the DStdev function:
Gets the standard deviation value of a column in an area with given conditions.
|
| DStdevp |
Implementation of the DStdevp function:
Gets the standard deviation value of a column in an area with given conditions.
|
| DSum |
Implementation of the DSum function:
Finds the total value of matching values in a column in an area with given conditions.
|
| DVar |
Implementation of the DVar function:
Gets the variance value of a column in an area with given conditions.
|
| DVarp |
Implementation of the DVarp function:
Gets the variance value of 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.
|
| FactDouble |
Implementation for Excel FACTDOUBLE() function.
|
| Finance |
Implementation of the financial functions pmt, fv, ppmt, ipmt.
|
| FinanceFunction |
|
| FinanceLib |
This class is a function library for common fiscal functions.
|
| Fixed |
|
| Fixed0ArgFunction |
Deprecated.
|
| 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.
|
| FloorMath |
Implementation for Excel FLOOR.MATH() function.
|
| FloorPrecise |
Implementation for Excel FLOOR.PRECISE() function.
|
| Forecast |
Implementation for Excel FORECAST() and FORECAST.LINEAR() functions.
|
| Frequency |
Implementation of Excel 'Analysis ToolPak' function FREQUENCY()
Returns a frequency distribution as a vertical array
|
| Gcd |
Implementation for Excel GCD() function.
|
| 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.
|
| Lcm |
Implementation for Excel LCM() function.
|
| LinearRegressionFunction |
Base class for linear regression functions.
|
| Log |
|
| 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.
|
| LookupUtils |
Common functionality used by VLOOKUP, HLOOKUP, LOOKUP and MATCH
|
| LookupUtils.CompareResult |
Enumeration to support 4 valued comparison results.
|
| Match |
Implementation for the MATCH() Excel function.
|
| MatrixFunction |
|
| MatrixFunction.MutableValueCollector |
|
| MatrixFunction.OneArrayArg |
|
| MatrixFunction.TwoArrayArg |
|
| Maxifs |
Implementation for the Excel function MAXIFS
|
| MinaMaxa |
|
| Minifs |
Implementation for the Excel function MINIFS
|
| 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()
|
| NormDist |
Implementation for Excel NORMDIST() and NORM.DIST() functions.
|
| NormInv |
Implementation for Excel NORMINV() and NORM.INV() functions.
|
| NormSDist |
Implementation for Excel NORMSDIST() and NORM.S.DIST functions.
|
| NormSInv |
Implementation for Excel NORMSINV() and NORM.S.INV() functions.
|
| 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).
|
| NumberValueFunction |
/**
Implementation for the NUMBERVALUE() Excel function.
|
| NumericFunction |
|
| NumericFunctionHelper |
|
| Oct2Dec |
Implementation for Excel Oct2Dec() function.
|
| Offset |
Implementation for Excel function OFFSET()
|
| OverridableFunction |
A Overridable function to provide the chance of override poi's basic functions
|
| PercentRank |
Implementation of 'the Excel function PERCENTRANK()
Syntax:
PERCENTRANK(array, X, [significance])
|
| Poisson |
|
| 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 Roman() function.
|
| RowFunc |
Implementation for the Excel function ROW
|
| Rows |
Implementation for Excel ROWS function.
|
| Single |
Implementation of the SINGLE function, used by Dynamic Arrays, which is
now largely replaced by the @ character.
|
| Slope |
Implementation of Excel function SLOPE()
|
| Sqrtpi |
Implementation for Excel SQRTPI() function.
|
| Standardize |
Implementation for Excel STANDARDIZE() function.
|
| 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
|
| TDist |
Implementation for Excel TDIST() function.
|
| TDist2t |
Implementation for Excel T.DIST.2T() function.
|
| TDistLt |
Implementation for Excel T.DIST() function.
|
| TDistRt |
Implementation for Excel T.DIST.RT() function.
|
| TextFunction |
|
| TextFunctionHelper |
|
| TimeFunc |
Implementation for the Excel function TIME
|
| TimeValue |
Implementation for the TIMEVALUE() Excel function.
|
| Today |
Implementation of Excel TODAY() Function
|
| Trend |
Implementation for the Excel function TREND
|
| UtilFns |
|
| 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 |
|