| Modifier and Type | Class and Description |
|---|---|
| public class | AnalysisToolPak
Analysis Toolpack Function Definitions |
| pack-priv class | ArgumentsEvaluator
Evaluator for formula arguments. |
| public class | DateParser
Deprecated
in 5.0.0 - use Parser for java dates.
org.
|
| pack-priv class | IfError
Implementation of 'Analysis Toolpak' Excel function IFERROR() Returns an error text if there is an error in the evaluation Syntax IFERROR(expression, string) |
| public class | IfNa
Implementation of 'Analysis Toolpak' the Excel function IFNA() Syntax: IFNA(test_value, default_value)
test_value The value to be tested
default_value The value to be tested
Returns |
| pack-priv class | Ifs
Implementation of 'Analysis Toolpak' Excel function IFS() The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. |
| pack-priv class | MRound
Implementation of Excel 'Analysis ToolPak' function MROUND() Returns a number rounded to the desired multiple. |
| pack-priv class | NetworkdaysFunction
Implementation of Excel 'Analysis ToolPak' function NETWORKDAYS() Returns the number of workdays given a starting and an ending date, considering an interval of holidays. |
| pack-priv class | ParityFunction
Implementation of Excel 'Analysis ToolPak' function ISEVEN() ISODD() |
| pack-priv class | PercentRankExcFunction
Implementation of 'Analysis Toolpak' the Excel function PERCENTRANK.EXC() Syntax: PERCENTRANK.EXC(array, X, [significance]) array The array or range of data with numeric values that defines relative standing. |
| pack-priv class | PercentRankIncFunction
Implementation of 'Analysis Toolpak' the Excel function PERCENTRANK.INC() Syntax: PERCENTRANK.INC(array, X, [significance]) array The array or range of data with numeric values that defines relative standing. |
| pack-priv class | RandBetween
Implementation of Excel 'Analysis ToolPak' function RANDBETWEEN() Returns a random integer number between the numbers you specify. |
| public class | |
| public class | |
| public class | Switch
Implementation of 'Analysis Toolpak' Excel function SWITCH() The SWITCH function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. |
| pack-priv class | TextJoinFunction
Implementation of Excel function TEXTJOIN() Syntax TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...) delimiter A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string. |
| public class | |
| public class | |
| public class | WorkdayCalculator
A calculator for workdays, considering dates as excel representations. |
| pack-priv class | WorkdayFunction
Implementation of Excel 'Analysis ToolPak' function WORKDAY() Returns the date past a number of workdays beginning at a start date, considering an interval of holidays. |
| pack-priv class | WorkdayIntlFunction
Implementation of Excel 'Analysis ToolPak' function WORKDAY.INTL() Returns the date past a number of workdays beginning at a start date, considering an interval of holidays. |
| pack-priv class | XLookupFunction
Implementation of Excel function XLOOKUP() Syntax XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929 |
| pack-priv class | XMatchFunction
Implementation of Excel function XMATCH() Syntax XMATCH(lookup_value, lookup_array, [match_mode], [search_mode]) https://support.microsoft.com/en-us/office/xmatch-function-d966da31-7a6b-4a13-a1c6-5a33ed6a0312 |
| pack-priv class | YearFrac
Implementation of Excel 'Analysis ToolPak' function YEARFRAC() Returns the fraction of the year spanned by two dates. |
| pack-priv class | YearFracCalculator
Internal calculation methods for Excel 'Analysis ToolPak' function YEARFRAC() Algorithm inspired by www.dwheeler.com/yearfrac |