Documentation

Calculation

Table of Contents

CALCULATION_REGEXP_CELLREF  = '((([^\s,!&%^\/\*\+<>=:`-]*)|('.*?')|(\".*?\"))!)?\$?\b([a-z]{1,3})\$?(\d{1,7})(?![\w.])'
CALCULATION_REGEXP_CELLREF_RELATIVE  = '((([^\s\(,!&%^\/\*\+<>=:`-]*)|('.*?')|(\".*?\"))!)?(\$?\b[a-z]{1,3})(\$?\d{1,7})(?![\w.])'
CALCULATION_REGEXP_COLUMN_RANGE  = '(((([^\s\(,!&%^\/\*\+<>=:`-]*)|('.*?')|(\".*?\"))!)?(\$?[a-z]{1,3})):(?![.*])'
CALCULATION_REGEXP_COLUMNRANGE_RELATIVE  = '(\$?[a-z]{1,3}):(\$?[a-z]{1,3})'
CALCULATION_REGEXP_DEFINEDNAME  = '((([^\s,!&%^\/\*\+<>=-]*)|('.*?')|(\".*?\"))!)?([_\p{L}][_\p{L}\p{N}\.]*)'
CALCULATION_REGEXP_ERROR  = '\#[A-Z][A-Z0_\/]*[!\?]?'
CALCULATION_REGEXP_FUNCTION  = '@?(?:_xlfn\.)?([\p{L}][\p{L}\p{N}\.]*)[\s]*\('
CALCULATION_REGEXP_NUMBER  = '[-+]?\d*\.?\d+(e[-+]?\d+)?'
Regular Expressions
CALCULATION_REGEXP_OPENBRACE  = '\('
CALCULATION_REGEXP_ROW_RANGE  = '(((([^\s\(,!&%^\/\*\+<>=:`-]*)|('.*?')|(\".*?\"))!)?(\$?[1-9][0-9]{0,6})):(?![.*])'
CALCULATION_REGEXP_ROWRANGE_RELATIVE  = '(\$?\d{1,7}):(\$?\d{1,7})'
CALCULATION_REGEXP_STRING  = '"(?:[^"]|"")*"'
FORMULA_CLOSE_FUNCTION_BRACE  = ')'
FORMULA_CLOSE_MATRIX_BRACE  = '}'
FORMULA_OPEN_FUNCTION_BRACE  = '('
FORMULA_OPEN_MATRIX_BRACE  = '{'
FORMULA_STRING_QUOTE  = '"'
RETURN_ARRAY_AS_ARRAY  = 'array'
RETURN_ARRAY_AS_ERROR  = 'error'
constants
RETURN_ARRAY_AS_VALUE  = 'value'
$cyclicFormulaCount  : int
Number of iterations for cyclic formulae.
$excelConstants  : array<string, mixed>
Excel constant string translations to their PHP equivalents Constant conversion from text name/value to actual (datatyped) value.
$formulaError  : null|string
Error message for any error that was raised/thrown by the calculation engine.
$localeBoolean  : array<string, string>
Locale-specific translations for Excel constants (True, False and Null).
$suppressFormulaErrors  : bool
Flag to determine how formula errors should be handled If true, then a user error will be triggered If false, then an exception will be thrown.
$binaryOperators  : array<string|int, mixed>
List of binary operators (those that expect two operands).
$branchPruner  : BranchPruner
$branchPruningEnabled  : bool
$calculationCache  : array<string|int, mixed>
Calculation cache.
$calculationCacheEnabled  : bool
Calculation cache enabled.
$cellStack  : mixed
$comparisonOperators  : mixed
$controlFunctions  : mixed
$cyclicFormulaCell  : mixed
$cyclicFormulaCounter  : int
Current iteration counter for cyclic formulae If the value is 0 (or less) then cyclic formulae will throw an exception, otherwise they will iterate to the limit defined here before returning a result.
$cyclicReferenceStack  : CyclicReferenceStack
An array of the nested cell references accessed by the calculation engine, used for the debug log.
$debugLog  : Logger
The debug log generated by the calculation engine.
$functionReplaceFromExcel  : mixed
$functionReplaceFromLocale  : mixed
$functionReplaceToExcel  : mixed
$functionReplaceToLocale  : mixed
$instance  : Calculation
Instance of this class.
$localeArgumentSeparator  : string
Locale-specific argument separator for function arguments.
$localeFunctions  : mixed
$localeLanguage  : string
The current locale setting.
$operatorAssociativity  : mixed
$operatorPrecedence  : mixed
$operators  : array<string|int, mixed>
List of operators that can be used within formulae The true/false value indicates whether it is a binary operator or a unary operator.
$phpSpreadsheetFunctions  : mixed
$referenceHelper  : ReferenceHelper
Reference Helper.
$returnArrayAsType  : mixed
$spreadsheet  : Spreadsheet
Instance of the spreadsheet this Calculation Engine is using.
$validLocaleLanguages  : array<string|int, string>
List of available locale settings Note that this is read for the locale subdirectory only when requested.
__clone()  : mixed
__clone implementation. Cloning should not be allowed in a Singleton!
__construct()  : mixed
_calculateFormulaValue()  : mixed
Parse a cell formula and calculate its value.
_translateFormulaToEnglish()  : mixed
_translateFormulaToLocale()  : mixed
calculate()  : mixed
Calculate cell value (using formula from a cell ID) Retained for backward compatibility.
calculateCellValue()  : mixed
Calculate the value of a cell formula.
calculateFormula()  : mixed
Calculate the value of a formula.
clearCalculationCache()  : void
Clear calculation cache.
clearCalculationCacheForWorksheet()  : void
Clear calculation cache for a specified worksheet.
disableBranchPruning()  : void
disableCalculationCache()  : void
Disable calculation cache.
enableBranchPruning()  : void
enableCalculationCache()  : void
Enable calculation cache.
extractCellRange()  : mixed
Extract range values.
extractNamedRange()  : mixed
Extract range values.
flushInstance()  : void
Flush the calculation cache for any existing instance of this class but only if a Calculation instance exists.
getArrayReturnType()  : string
Return the Array Return Type (Array or Value of first element in the array).
getCalculationCacheEnabled()  : bool
Is calculation caching enabled?
getDebugLog()  : Logger
Get the Logger for this calculation engine instance.
getFALSE()  : string
Return the locale-specific translation of FALSE.
getFunctions()  : array<string|int, mixed>
Get a list of all implemented functions as an array of function objects.
getImplementedFunctionNames()  : array<string|int, mixed>
Get a list of implemented Excel function names.
getInstance()  : self
Get an instance of this class.
getLocale()  : string
Get the currently defined locale code.
getMatrixDimensions()  : array<string|int, int>
Read the dimensions of a matrix, and re-index it with straight numeric keys starting from row 0, column 0.
getTRUE()  : string
Return the locale-specific translation of TRUE.
getValueFromCache()  : bool
isImplemented()  : bool
Is a specific function implemented?
localeFunc()  : mixed
parseFormula()  : array<string|int, mixed>|bool
Validate and parse a formula string.
renameCalculationCacheForWorksheet()  : void
Rename calculation cache for a specified worksheet.
saveValueToCache()  : void
setArrayReturnType()  : bool
Set the Array Return Type (Array or Value of first element in the array).
setBranchPruningEnabled()  : void
Enable/disable calculation cache.
setCalculationCacheEnabled()  : void
Enable/disable calculation cache.
setLocale()  : bool
Set the locale code.
translateSeparator()  : string
unwrapResult()  : mixed
Remove quotes used as a wrapper to identify string values.
wrapResult()  : mixed
Wrap string values in quotes.
raiseFormulaError()  : false
Trigger an error, but nicely, if need be.
addCellReference()  : array<string|int, mixed>
Add cell reference if needed while making sure that it is the last argument.
addDefaultArgumentValues()  : array<string|int, mixed>
checkMatrixOperands()  : array<string|int, mixed>
Ensure that paired matrix operands are both matrices and of the same size.
convertMatrixReferences()  : false|string
dataTestReference()  : mixed
evaluateDefinedName()  : mixed|string
executeArrayComparison()  : array<string|int, mixed>
executeBinaryComparisonOperation()  : mixed
executeNumericBinaryOperation()  : bool|mixed
getArgumentDefaultValue()  : null|mixed
getLocaleFile()  : string
getTokensAsString()  : mixed
internalParseFormula()  : array<int, mixed>|false
loadLocales()  : void
processTokenStack()  : array<int, mixed>|false
resizeMatricesExtend()  : void
Ensure that paired matrix operands are both matrices of the same size.
resizeMatricesShrink()  : void
Ensure that paired matrix operands are both matrices of the same size.
showTypeDetails()  : null|string
Format type and details of an operand for display in the log (based on operand type).
showValue()  : mixed
Format details of an operand for display in the log (based on operand type).
translateFormula()  : string
translateFormulaBlock()  : string
validateBinaryOperand()  : mixed

Constants

CALCULATION_REGEXP_CELLREF

public mixed CALCULATION_REGEXP_CELLREF = '((([^\s,!&%^\/\*\+<>=:`-]*)|('.*?')|(\".*?\"))!)?\$?\b([a-z]{1,3})\$?(\d{1,7})(?![\w.])'

CALCULATION_REGEXP_CELLREF_RELATIVE

public mixed CALCULATION_REGEXP_CELLREF_RELATIVE = '((([^\s\(,!&%^\/\*\+<>=:`-]*)|('.*?')|(\".*?\"))!)?(\$?\b[a-z]{1,3})(\$?\d{1,7})(?![\w.])'

CALCULATION_REGEXP_COLUMN_RANGE

public mixed CALCULATION_REGEXP_COLUMN_RANGE = '(((([^\s\(,!&%^\/\*\+<>=:`-]*)|('.*?')|(\".*?\"))!)?(\$?[a-z]{1,3})):(?![.*])'

CALCULATION_REGEXP_COLUMNRANGE_RELATIVE

public mixed CALCULATION_REGEXP_COLUMNRANGE_RELATIVE = '(\$?[a-z]{1,3}):(\$?[a-z]{1,3})'

CALCULATION_REGEXP_DEFINEDNAME

public mixed CALCULATION_REGEXP_DEFINEDNAME = '((([^\s,!&%^\/\*\+<>=-]*)|('.*?')|(\".*?\"))!)?([_\p{L}][_\p{L}\p{N}\.]*)'

CALCULATION_REGEXP_ERROR

public mixed CALCULATION_REGEXP_ERROR = '\#[A-Z][A-Z0_\/]*[!\?]?'

CALCULATION_REGEXP_FUNCTION

public mixed CALCULATION_REGEXP_FUNCTION = '@?(?:_xlfn\.)?([\p{L}][\p{L}\p{N}\.]*)[\s]*\('

CALCULATION_REGEXP_NUMBER

Regular Expressions

public mixed CALCULATION_REGEXP_NUMBER = '[-+]?\d*\.?\d+(e[-+]?\d+)?'

CALCULATION_REGEXP_OPENBRACE

public mixed CALCULATION_REGEXP_OPENBRACE = '\('

CALCULATION_REGEXP_ROW_RANGE

public mixed CALCULATION_REGEXP_ROW_RANGE = '(((([^\s\(,!&%^\/\*\+<>=:`-]*)|('.*?')|(\".*?\"))!)?(\$?[1-9][0-9]{0,6})):(?![.*])'

CALCULATION_REGEXP_ROWRANGE_RELATIVE

public mixed CALCULATION_REGEXP_ROWRANGE_RELATIVE = '(\$?\d{1,7}):(\$?\d{1,7})'

CALCULATION_REGEXP_STRING

public mixed CALCULATION_REGEXP_STRING = '"(?:[^"]|"")*"'

FORMULA_CLOSE_FUNCTION_BRACE

public mixed FORMULA_CLOSE_FUNCTION_BRACE = ')'

FORMULA_CLOSE_MATRIX_BRACE

public mixed FORMULA_CLOSE_MATRIX_BRACE = '}'

FORMULA_OPEN_FUNCTION_BRACE

public mixed FORMULA_OPEN_FUNCTION_BRACE = '('

FORMULA_OPEN_MATRIX_BRACE

public mixed FORMULA_OPEN_MATRIX_BRACE = '{'

FORMULA_STRING_QUOTE

public mixed FORMULA_STRING_QUOTE = '"'

RETURN_ARRAY_AS_ARRAY

public mixed RETURN_ARRAY_AS_ARRAY = 'array'

RETURN_ARRAY_AS_ERROR

constants

public mixed RETURN_ARRAY_AS_ERROR = 'error'

RETURN_ARRAY_AS_VALUE

public mixed RETURN_ARRAY_AS_VALUE = 'value'

Properties

$cyclicFormulaCount

Number of iterations for cyclic formulae.

public int $cyclicFormulaCount = 1

$excelConstants

Excel constant string translations to their PHP equivalents Constant conversion from text name/value to actual (datatyped) value.

public static array<string, mixed> $excelConstants = ['TRUE' => true, 'FALSE' => false, 'NULL' => null]

$formulaError

Error message for any error that was raised/thrown by the calculation engine.

public null|string $formulaError

$localeBoolean

Locale-specific translations for Excel constants (True, False and Null).

public static array<string, string> $localeBoolean = ['TRUE' => 'TRUE', 'FALSE' => 'FALSE', 'NULL' => 'NULL']

$suppressFormulaErrors

Flag to determine how formula errors should be handled If true, then a user error will be triggered If false, then an exception will be thrown.

public bool $suppressFormulaErrors = false

$binaryOperators

List of binary operators (those that expect two operands).

private static array<string|int, mixed> $binaryOperators = ['+' => true, '-' => true, '*' => true, '/' => true, '^' => true, '&' => true, '>' => true, '<' => true, '=' => true, '>=' => true, '<=' => true, '<>' => true, '∩' => true, '∪' => true, ':' => true]

$branchPruningEnabled

private bool $branchPruningEnabled = true

$calculationCache

Calculation cache.

private array<string|int, mixed> $calculationCache = []

$calculationCacheEnabled

Calculation cache enabled.

private bool $calculationCacheEnabled = true

$comparisonOperators

private static mixed $comparisonOperators = ['>' => true, '<' => true, '=' => true, '>=' => true, '<=' => true, '<>' => true]

$controlFunctions

private static mixed $controlFunctions = ['MKMATRIX' => ['argumentCount' => '*', 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInternalMakeMatrix::class, 'make']], 'NAME.ERROR' => ['argumentCount' => '*', 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'NAME']], 'WILDCARDMATCH' => ['argumentCount' => '2', 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInternalWildcardMatch::class, 'compare']]]

$cyclicFormulaCell

private mixed $cyclicFormulaCell = ''

$cyclicFormulaCounter

Current iteration counter for cyclic formulae If the value is 0 (or less) then cyclic formulae will throw an exception, otherwise they will iterate to the limit defined here before returning a result.

private int $cyclicFormulaCounter = 1

$cyclicReferenceStack

An array of the nested cell references accessed by the calculation engine, used for the debug log.

private CyclicReferenceStack $cyclicReferenceStack

$debugLog

The debug log generated by the calculation engine.

private Logger $debugLog

$functionReplaceFromExcel

private static mixed $functionReplaceFromExcel

$functionReplaceFromLocale

private static mixed $functionReplaceFromLocale

$functionReplaceToExcel

private static mixed $functionReplaceToExcel

$functionReplaceToLocale

private static mixed $functionReplaceToLocale

$localeArgumentSeparator

Locale-specific argument separator for function arguments.

private static string $localeArgumentSeparator = ','

$localeFunctions

private static mixed $localeFunctions = []

$localeLanguage

The current locale setting.

private static string $localeLanguage = 'en_us'

$operatorAssociativity

private static mixed $operatorAssociativity = [ '^' => 0, // Exponentiation '*' => 0, '/' => 0, // Multiplication and Division '+' => 0, '-' => 0, // Addition and Subtraction '&' => 0, // Concatenation '∪' => 0, '∩' => 0, ':' => 0, // Union, Intersect and Range '>' => 0, '<' => 0, '=' => 0, '>=' => 0, '<=' => 0, '<>' => 0, ]

$operatorPrecedence

private static mixed $operatorPrecedence = [ ':' => 9, // Range '∩' => 8, // Intersect '∪' => 7, // Union '~' => 6, // Negation '%' => 5, // Percentage '^' => 4, // Exponentiation '*' => 3, '/' => 3, // Multiplication and Division '+' => 2, '-' => 2, // Addition and Subtraction '&' => 1, // Concatenation '>' => 0, '<' => 0, '=' => 0, '>=' => 0, '<=' => 0, '<>' => 0, ]

$operators

List of operators that can be used within formulae The true/false value indicates whether it is a binary operator or a unary operator.

private static array<string|int, mixed> $operators = ['+' => true, '-' => true, '*' => true, '/' => true, '^' => true, '&' => true, '%' => false, '~' => false, '>' => true, '<' => true, '=' => true, '>=' => true, '<=' => true, '<>' => true, '∩' => true, '∪' => true, ':' => true]

$phpSpreadsheetFunctions

private static mixed $phpSpreadsheetFunctions = ['ABS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigAbsolute::class, 'evaluate'], 'argumentCount' => '1'], 'ACCRINT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialSecuritiesAccruedInterest::class, 'periodic'], 'argumentCount' => '4-8'], 'ACCRINTM' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialSecuritiesAccruedInterest::class, 'atMaturity'], 'argumentCount' => '3-5'], 'ACOS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigCosine::class, 'acos'], 'argumentCount' => '1'], 'ACOSH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigCosine::class, 'acosh'], 'argumentCount' => '1'], 'ACOT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigCotangent::class, 'acot'], 'argumentCount' => '1'], 'ACOTH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigCotangent::class, 'acoth'], 'argumentCount' => '1'], 'ADDRESS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefAddress::class, 'cell'], 'argumentCount' => '2-5'], 'AGGREGATE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '3+'], 'AMORDEGRC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialAmortization::class, 'AMORDEGRC'], 'argumentCount' => '6,7'], 'AMORLINC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialAmortization::class, 'AMORLINC'], 'argumentCount' => '6,7'], 'AND' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOGICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLogicalOperations::class, 'logicalAnd'], 'argumentCount' => '1+'], 'ARABIC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigArabic::class, 'evaluate'], 'argumentCount' => '1'], 'AREAS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '1'], 'ARRAYTOTEXT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'ASC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '1'], 'ASIN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigSine::class, 'asin'], 'argumentCount' => '1'], 'ASINH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigSine::class, 'asinh'], 'argumentCount' => '1'], 'ATAN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigTangent::class, 'atan'], 'argumentCount' => '1'], 'ATAN2' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigTangent::class, 'atan2'], 'argumentCount' => '2'], 'ATANH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigTangent::class, 'atanh'], 'argumentCount' => '1'], 'AVEDEV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalAverages::class, 'averageDeviations'], 'argumentCount' => '1+'], 'AVERAGE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalAverages::class, 'average'], 'argumentCount' => '1+'], 'AVERAGEA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalAverages::class, 'averageA'], 'argumentCount' => '1+'], 'AVERAGEIF' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalConditional::class, 'AVERAGEIF'], 'argumentCount' => '2,3'], 'AVERAGEIFS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalConditional::class, 'AVERAGEIFS'], 'argumentCount' => '3+'], 'BAHTTEXT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '1'], 'BASE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigBase::class, 'evaluate'], 'argumentCount' => '2,3'], 'BESSELI' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringBesselI::class, 'BESSELI'], 'argumentCount' => '2'], 'BESSELJ' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringBesselJ::class, 'BESSELJ'], 'argumentCount' => '2'], 'BESSELK' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringBesselK::class, 'BESSELK'], 'argumentCount' => '2'], 'BESSELY' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringBesselY::class, 'BESSELY'], 'argumentCount' => '2'], 'BETADIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsBeta::class, 'distribution'], 'argumentCount' => '3-5'], 'BETA.DIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '4-6'], 'BETAINV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsBeta::class, 'inverse'], 'argumentCount' => '3-5'], 'BETA.INV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsBeta::class, 'inverse'], 'argumentCount' => '3-5'], 'BIN2DEC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringConvertBinary::class, 'toDecimal'], 'argumentCount' => '1'], 'BIN2HEX' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringConvertBinary::class, 'toHex'], 'argumentCount' => '1,2'], 'BIN2OCT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringConvertBinary::class, 'toOctal'], 'argumentCount' => '1,2'], 'BINOMDIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsBinomial::class, 'distribution'], 'argumentCount' => '4'], 'BINOM.DIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsBinomial::class, 'distribution'], 'argumentCount' => '4'], 'BINOM.DIST.RANGE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsBinomial::class, 'range'], 'argumentCount' => '3,4'], 'BINOM.INV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsBinomial::class, 'inverse'], 'argumentCount' => '3'], 'BITAND' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringBitWise::class, 'BITAND'], 'argumentCount' => '2'], 'BITOR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringBitWise::class, 'BITOR'], 'argumentCount' => '2'], 'BITXOR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringBitWise::class, 'BITXOR'], 'argumentCount' => '2'], 'BITLSHIFT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringBitWise::class, 'BITLSHIFT'], 'argumentCount' => '2'], 'BITRSHIFT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringBitWise::class, 'BITRSHIFT'], 'argumentCount' => '2'], 'CEILING' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigCeiling::class, 'ceiling'], 'argumentCount' => '1-2'], 'CEILING.MATH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigCeiling::class, 'math'], 'argumentCount' => '1-3'], 'CEILING.PRECISE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigCeiling::class, 'precise'], 'argumentCount' => '1,2'], 'CELL' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '1,2'], 'CHAR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataCharacterConvert::class, 'character'], 'argumentCount' => '1'], 'CHIDIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsChiSquared::class, 'distributionRightTail'], 'argumentCount' => '2'], 'CHISQ.DIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsChiSquared::class, 'distributionLeftTail'], 'argumentCount' => '3'], 'CHISQ.DIST.RT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsChiSquared::class, 'distributionRightTail'], 'argumentCount' => '2'], 'CHIINV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsChiSquared::class, 'inverseRightTail'], 'argumentCount' => '2'], 'CHISQ.INV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsChiSquared::class, 'inverseLeftTail'], 'argumentCount' => '2'], 'CHISQ.INV.RT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsChiSquared::class, 'inverseRightTail'], 'argumentCount' => '2'], 'CHITEST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsChiSquared::class, 'test'], 'argumentCount' => '2'], 'CHISQ.TEST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsChiSquared::class, 'test'], 'argumentCount' => '2'], 'CHOOSE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefSelection::class, 'CHOOSE'], 'argumentCount' => '2+'], 'CLEAN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataTrim::class, 'nonPrintable'], 'argumentCount' => '1'], 'CODE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataCharacterConvert::class, 'code'], 'argumentCount' => '1'], 'COLUMN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefRowColumnInformation::class, 'COLUMN'], 'argumentCount' => '-1', 'passCellReference' => true, 'passByReference' => [true]], 'COLUMNS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefRowColumnInformation::class, 'COLUMNS'], 'argumentCount' => '1'], 'COMBIN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigCombinations::class, 'withoutRepetition'], 'argumentCount' => '2'], 'COMBINA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigCombinations::class, 'withRepetition'], 'argumentCount' => '2'], 'COMPLEX' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplex::class, 'COMPLEX'], 'argumentCount' => '2,3'], 'CONCAT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataConcatenate::class, 'CONCATENATE'], 'argumentCount' => '1+'], 'CONCATENATE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataConcatenate::class, 'CONCATENATE'], 'argumentCount' => '1+'], 'CONFIDENCE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalConfidence::class, 'CONFIDENCE'], 'argumentCount' => '3'], 'CONFIDENCE.NORM' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalConfidence::class, 'CONFIDENCE'], 'argumentCount' => '3'], 'CONFIDENCE.T' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '3'], 'CONVERT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringConvertUOM::class, 'CONVERT'], 'argumentCount' => '3'], 'CORREL' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalTrends::class, 'CORREL'], 'argumentCount' => '2'], 'COS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigCosine::class, 'cos'], 'argumentCount' => '1'], 'COSH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigCosine::class, 'cosh'], 'argumentCount' => '1'], 'COT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigCotangent::class, 'cot'], 'argumentCount' => '1'], 'COTH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigCotangent::class, 'coth'], 'argumentCount' => '1'], 'COUNT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalCounts::class, 'COUNT'], 'argumentCount' => '1+'], 'COUNTA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalCounts::class, 'COUNTA'], 'argumentCount' => '1+'], 'COUNTBLANK' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalCounts::class, 'COUNTBLANK'], 'argumentCount' => '1'], 'COUNTIF' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalConditional::class, 'COUNTIF'], 'argumentCount' => '2'], 'COUNTIFS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalConditional::class, 'COUNTIFS'], 'argumentCount' => '2+'], 'COUPDAYBS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCoupons::class, 'COUPDAYBS'], 'argumentCount' => '3,4'], 'COUPDAYS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCoupons::class, 'COUPDAYS'], 'argumentCount' => '3,4'], 'COUPDAYSNC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCoupons::class, 'COUPDAYSNC'], 'argumentCount' => '3,4'], 'COUPNCD' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCoupons::class, 'COUPNCD'], 'argumentCount' => '3,4'], 'COUPNUM' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCoupons::class, 'COUPNUM'], 'argumentCount' => '3,4'], 'COUPPCD' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCoupons::class, 'COUPPCD'], 'argumentCount' => '3,4'], 'COVAR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalTrends::class, 'COVAR'], 'argumentCount' => '2'], 'COVARIANCE.P' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalTrends::class, 'COVAR'], 'argumentCount' => '2'], 'COVARIANCE.S' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2'], 'CRITBINOM' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsBinomial::class, 'inverse'], 'argumentCount' => '3'], 'CSC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigCosecant::class, 'csc'], 'argumentCount' => '1'], 'CSCH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigCosecant::class, 'csch'], 'argumentCount' => '1'], 'CUBEKPIMEMBER' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_CUBE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'CUBEMEMBER' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_CUBE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'CUBEMEMBERPROPERTY' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_CUBE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'CUBERANKEDMEMBER' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_CUBE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'CUBESET' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_CUBE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'CUBESETCOUNT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_CUBE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'CUBEVALUE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_CUBE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'CUMIPMT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowConstantPeriodicCumulative::class, 'interest'], 'argumentCount' => '6'], 'CUMPRINC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowConstantPeriodicCumulative::class, 'principal'], 'argumentCount' => '6'], 'DATE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelDate::class, 'fromYMD'], 'argumentCount' => '3'], 'DATEDIF' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelDifference::class, 'interval'], 'argumentCount' => '2,3'], 'DATESTRING' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'DATEVALUE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelDateValue::class, 'fromString'], 'argumentCount' => '1'], 'DAVERAGE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATABASE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDatabaseDAverage::class, 'evaluate'], 'argumentCount' => '3'], 'DAY' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelDateParts::class, 'day'], 'argumentCount' => '1'], 'DAYS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelDays::class, 'between'], 'argumentCount' => '2'], 'DAYS360' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelDays360::class, 'between'], 'argumentCount' => '2,3'], 'DB' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialDepreciation::class, 'DB'], 'argumentCount' => '4,5'], 'DBCS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '1'], 'DCOUNT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATABASE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDatabaseDCount::class, 'evaluate'], 'argumentCount' => '3'], 'DCOUNTA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATABASE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDatabaseDCountA::class, 'evaluate'], 'argumentCount' => '3'], 'DDB' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialDepreciation::class, 'DDB'], 'argumentCount' => '4,5'], 'DEC2BIN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringConvertDecimal::class, 'toBinary'], 'argumentCount' => '1,2'], 'DEC2HEX' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringConvertDecimal::class, 'toHex'], 'argumentCount' => '1,2'], 'DEC2OCT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringConvertDecimal::class, 'toOctal'], 'argumentCount' => '1,2'], 'DECIMAL' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2'], 'DEGREES' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigAngle::class, 'toDegrees'], 'argumentCount' => '1'], 'DELTA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringCompare::class, 'DELTA'], 'argumentCount' => '1,2'], 'DEVSQ' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDeviations::class, 'sumSquares'], 'argumentCount' => '1+'], 'DGET' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATABASE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDatabaseDGet::class, 'evaluate'], 'argumentCount' => '3'], 'DISC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialSecuritiesRates::class, 'discount'], 'argumentCount' => '4,5'], 'DMAX' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATABASE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDatabaseDMax::class, 'evaluate'], 'argumentCount' => '3'], 'DMIN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATABASE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDatabaseDMin::class, 'evaluate'], 'argumentCount' => '3'], 'DOLLAR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataFormat::class, 'DOLLAR'], 'argumentCount' => '1,2'], 'DOLLARDE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialDollar::class, 'decimal'], 'argumentCount' => '2'], 'DOLLARFR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialDollar::class, 'fractional'], 'argumentCount' => '2'], 'DPRODUCT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATABASE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDatabaseDProduct::class, 'evaluate'], 'argumentCount' => '3'], 'DSTDEV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATABASE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDatabaseDStDev::class, 'evaluate'], 'argumentCount' => '3'], 'DSTDEVP' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATABASE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDatabaseDStDevP::class, 'evaluate'], 'argumentCount' => '3'], 'DSUM' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATABASE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDatabaseDSum::class, 'evaluate'], 'argumentCount' => '3'], 'DURATION' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '5,6'], 'DVAR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATABASE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDatabaseDVar::class, 'evaluate'], 'argumentCount' => '3'], 'DVARP' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATABASE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDatabaseDVarP::class, 'evaluate'], 'argumentCount' => '3'], 'ECMA.CEILING' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '1,2'], 'EDATE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelMonth::class, 'adjust'], 'argumentCount' => '2'], 'EFFECT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialInterestRate::class, 'effective'], 'argumentCount' => '2'], 'ENCODEURL' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_WEB, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationWebService::class, 'urlEncode'], 'argumentCount' => '1'], 'EOMONTH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelMonth::class, 'lastDay'], 'argumentCount' => '2'], 'ERF' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringErf::class, 'ERF'], 'argumentCount' => '1,2'], 'ERF.PRECISE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringErf::class, 'ERFPRECISE'], 'argumentCount' => '1'], 'ERFC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringErfC::class, 'ERFC'], 'argumentCount' => '1'], 'ERFC.PRECISE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringErfC::class, 'ERFC'], 'argumentCount' => '1'], 'ERROR.TYPE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationExcelError::class, 'type'], 'argumentCount' => '1'], 'EVEN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigRound::class, 'even'], 'argumentCount' => '1'], 'EXACT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataText::class, 'exact'], 'argumentCount' => '2'], 'EXP' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigExp::class, 'evaluate'], 'argumentCount' => '1'], 'EXPONDIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsExponential::class, 'distribution'], 'argumentCount' => '3'], 'EXPON.DIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsExponential::class, 'distribution'], 'argumentCount' => '3'], 'FACT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigFactorial::class, 'fact'], 'argumentCount' => '1'], 'FACTDOUBLE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigFactorial::class, 'factDouble'], 'argumentCount' => '1'], 'FALSE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOGICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLogicalBoolean::class, 'FALSE'], 'argumentCount' => '0'], 'FDIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '3'], 'F.DIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsF::class, 'distribution'], 'argumentCount' => '4'], 'F.DIST.RT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '3'], 'FILTER' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefFilter::class, 'filter'], 'argumentCount' => '2-3'], 'FILTERXML' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_WEB, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2'], 'FIND' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataSearch::class, 'sensitive'], 'argumentCount' => '2,3'], 'FINDB' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataSearch::class, 'sensitive'], 'argumentCount' => '2,3'], 'FINV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '3'], 'F.INV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '3'], 'F.INV.RT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '3'], 'FISHER' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsFisher::class, 'distribution'], 'argumentCount' => '1'], 'FISHERINV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsFisher::class, 'inverse'], 'argumentCount' => '1'], 'FIXED' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataFormat::class, 'FIXEDFORMAT'], 'argumentCount' => '1-3'], 'FLOOR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigFloor::class, 'floor'], 'argumentCount' => '1-2'], 'FLOOR.MATH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigFloor::class, 'math'], 'argumentCount' => '1-3'], 'FLOOR.PRECISE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigFloor::class, 'precise'], 'argumentCount' => '1-2'], 'FORECAST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalTrends::class, 'FORECAST'], 'argumentCount' => '3'], 'FORECAST.ETS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '3-6'], 'FORECAST.ETS.CONFINT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '3-6'], 'FORECAST.ETS.SEASONALITY' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2-4'], 'FORECAST.ETS.STAT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '3-6'], 'FORECAST.LINEAR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalTrends::class, 'FORECAST'], 'argumentCount' => '3'], 'FORMULATEXT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefFormula::class, 'text'], 'argumentCount' => '1', 'passCellReference' => true, 'passByReference' => [true]], 'FREQUENCY' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2'], 'FTEST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2'], 'F.TEST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2'], 'FV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowConstantPeriodic::class, 'futureValue'], 'argumentCount' => '3-5'], 'FVSCHEDULE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowSingle::class, 'futureValue'], 'argumentCount' => '2'], 'GAMMA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsGamma::class, 'gamma'], 'argumentCount' => '1'], 'GAMMADIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsGamma::class, 'distribution'], 'argumentCount' => '4'], 'GAMMA.DIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsGamma::class, 'distribution'], 'argumentCount' => '4'], 'GAMMAINV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsGamma::class, 'inverse'], 'argumentCount' => '3'], 'GAMMA.INV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsGamma::class, 'inverse'], 'argumentCount' => '3'], 'GAMMALN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsGamma::class, 'ln'], 'argumentCount' => '1'], 'GAMMALN.PRECISE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsGamma::class, 'ln'], 'argumentCount' => '1'], 'GAUSS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsStandardNormal::class, 'gauss'], 'argumentCount' => '1'], 'GCD' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigGcd::class, 'evaluate'], 'argumentCount' => '1+'], 'GEOMEAN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalAveragesMean::class, 'geometric'], 'argumentCount' => '1+'], 'GESTEP' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringCompare::class, 'GESTEP'], 'argumentCount' => '1,2'], 'GETPIVOTDATA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2+'], 'GROWTH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalTrends::class, 'GROWTH'], 'argumentCount' => '1-4'], 'HARMEAN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalAveragesMean::class, 'harmonic'], 'argumentCount' => '1+'], 'HEX2BIN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringConvertHex::class, 'toBinary'], 'argumentCount' => '1,2'], 'HEX2DEC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringConvertHex::class, 'toDecimal'], 'argumentCount' => '1'], 'HEX2OCT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringConvertHex::class, 'toOctal'], 'argumentCount' => '1,2'], 'HLOOKUP' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefHLookup::class, 'lookup'], 'argumentCount' => '3,4'], 'HOUR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelTimeParts::class, 'hour'], 'argumentCount' => '1'], 'HYPERLINK' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefHyperlink::class, 'set'], 'argumentCount' => '1,2', 'passCellReference' => true], 'HYPGEOMDIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsHyperGeometric::class, 'distribution'], 'argumentCount' => '4'], 'HYPGEOM.DIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '5'], 'IF' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOGICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLogicalConditional::class, 'statementIf'], 'argumentCount' => '1-3'], 'IFERROR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOGICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLogicalConditional::class, 'IFERROR'], 'argumentCount' => '2'], 'IFNA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOGICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLogicalConditional::class, 'IFNA'], 'argumentCount' => '2'], 'IFS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOGICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLogicalConditional::class, 'IFS'], 'argumentCount' => '2+'], 'IMABS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMABS'], 'argumentCount' => '1'], 'IMAGINARY' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplex::class, 'IMAGINARY'], 'argumentCount' => '1'], 'IMARGUMENT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMARGUMENT'], 'argumentCount' => '1'], 'IMCONJUGATE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMCONJUGATE'], 'argumentCount' => '1'], 'IMCOS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMCOS'], 'argumentCount' => '1'], 'IMCOSH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMCOSH'], 'argumentCount' => '1'], 'IMCOT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMCOT'], 'argumentCount' => '1'], 'IMCSC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMCSC'], 'argumentCount' => '1'], 'IMCSCH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMCSCH'], 'argumentCount' => '1'], 'IMDIV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexOperations::class, 'IMDIV'], 'argumentCount' => '2'], 'IMEXP' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMEXP'], 'argumentCount' => '1'], 'IMLN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMLN'], 'argumentCount' => '1'], 'IMLOG10' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMLOG10'], 'argumentCount' => '1'], 'IMLOG2' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMLOG2'], 'argumentCount' => '1'], 'IMPOWER' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMPOWER'], 'argumentCount' => '2'], 'IMPRODUCT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexOperations::class, 'IMPRODUCT'], 'argumentCount' => '1+'], 'IMREAL' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplex::class, 'IMREAL'], 'argumentCount' => '1'], 'IMSEC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMSEC'], 'argumentCount' => '1'], 'IMSECH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMSECH'], 'argumentCount' => '1'], 'IMSIN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMSIN'], 'argumentCount' => '1'], 'IMSINH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMSINH'], 'argumentCount' => '1'], 'IMSQRT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMSQRT'], 'argumentCount' => '1'], 'IMSUB' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexOperations::class, 'IMSUB'], 'argumentCount' => '2'], 'IMSUM' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexOperations::class, 'IMSUM'], 'argumentCount' => '1+'], 'IMTAN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringComplexFunctions::class, 'IMTAN'], 'argumentCount' => '1'], 'INDEX' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefMatrix::class, 'index'], 'argumentCount' => '1-4'], 'INDIRECT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefIndirect::class, 'INDIRECT'], 'argumentCount' => '1,2', 'passCellReference' => true], 'INFO' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '1'], 'INT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigIntClass::class, 'evaluate'], 'argumentCount' => '1'], 'INTERCEPT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalTrends::class, 'INTERCEPT'], 'argumentCount' => '2'], 'INTRATE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialSecuritiesRates::class, 'interest'], 'argumentCount' => '4,5'], 'IPMT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowConstantPeriodicInterest::class, 'payment'], 'argumentCount' => '4-6'], 'IRR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowVariablePeriodic::class, 'rate'], 'argumentCount' => '1,2'], 'ISBLANK' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationValue::class, 'isBlank'], 'argumentCount' => '1'], 'ISERR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationErrorValue::class, 'isErr'], 'argumentCount' => '1'], 'ISERROR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationErrorValue::class, 'isError'], 'argumentCount' => '1'], 'ISEVEN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationValue::class, 'isEven'], 'argumentCount' => '1'], 'ISFORMULA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationValue::class, 'isFormula'], 'argumentCount' => '1', 'passCellReference' => true, 'passByReference' => [true]], 'ISLOGICAL' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationValue::class, 'isLogical'], 'argumentCount' => '1'], 'ISNA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationErrorValue::class, 'isNa'], 'argumentCount' => '1'], 'ISNONTEXT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationValue::class, 'isNonText'], 'argumentCount' => '1'], 'ISNUMBER' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationValue::class, 'isNumber'], 'argumentCount' => '1'], 'ISO.CEILING' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '1,2'], 'ISODD' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationValue::class, 'isOdd'], 'argumentCount' => '1'], 'ISOWEEKNUM' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelWeek::class, 'isoWeekNumber'], 'argumentCount' => '1'], 'ISPMT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowConstantPeriodicInterest::class, 'schedulePayment'], 'argumentCount' => '4'], 'ISREF' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationValue::class, 'isRef'], 'argumentCount' => '1', 'passCellReference' => true, 'passByReference' => [true]], 'ISTEXT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationValue::class, 'isText'], 'argumentCount' => '1'], 'ISTHAIDIGIT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'JIS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '1'], 'KURT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDeviations::class, 'kurtosis'], 'argumentCount' => '1+'], 'LARGE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalSize::class, 'large'], 'argumentCount' => '2'], 'LCM' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigLcm::class, 'evaluate'], 'argumentCount' => '1+'], 'LEFT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataExtract::class, 'left'], 'argumentCount' => '1,2'], 'LEFTB' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataExtract::class, 'left'], 'argumentCount' => '1,2'], 'LEN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataText::class, 'length'], 'argumentCount' => '1'], 'LENB' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataText::class, 'length'], 'argumentCount' => '1'], 'LINEST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalTrends::class, 'LINEST'], 'argumentCount' => '1-4'], 'LN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigLogarithms::class, 'natural'], 'argumentCount' => '1'], 'LOG' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigLogarithms::class, 'withBase'], 'argumentCount' => '1,2'], 'LOG10' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigLogarithms::class, 'base10'], 'argumentCount' => '1'], 'LOGEST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalTrends::class, 'LOGEST'], 'argumentCount' => '1-4'], 'LOGINV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsLogNormal::class, 'inverse'], 'argumentCount' => '3'], 'LOGNORMDIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsLogNormal::class, 'cumulative'], 'argumentCount' => '3'], 'LOGNORM.DIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsLogNormal::class, 'distribution'], 'argumentCount' => '4'], 'LOGNORM.INV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsLogNormal::class, 'inverse'], 'argumentCount' => '3'], 'LOOKUP' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefLookup::class, 'lookup'], 'argumentCount' => '2,3'], 'LOWER' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataCaseConvert::class, 'lower'], 'argumentCount' => '1'], 'MATCH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefExcelMatch::class, 'MATCH'], 'argumentCount' => '2,3'], 'MAX' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalMaximum::class, 'max'], 'argumentCount' => '1+'], 'MAXA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalMaximum::class, 'maxA'], 'argumentCount' => '1+'], 'MAXIFS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalConditional::class, 'MAXIFS'], 'argumentCount' => '3+'], 'MDETERM' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigMatrixFunctions::class, 'determinant'], 'argumentCount' => '1'], 'MDURATION' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '5,6'], 'MEDIAN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalAverages::class, 'median'], 'argumentCount' => '1+'], 'MEDIANIF' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2+'], 'MID' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataExtract::class, 'mid'], 'argumentCount' => '3'], 'MIDB' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataExtract::class, 'mid'], 'argumentCount' => '3'], 'MIN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalMinimum::class, 'min'], 'argumentCount' => '1+'], 'MINA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalMinimum::class, 'minA'], 'argumentCount' => '1+'], 'MINIFS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalConditional::class, 'MINIFS'], 'argumentCount' => '3+'], 'MINUTE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelTimeParts::class, 'minute'], 'argumentCount' => '1'], 'MINVERSE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigMatrixFunctions::class, 'inverse'], 'argumentCount' => '1'], 'MIRR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowVariablePeriodic::class, 'modifiedRate'], 'argumentCount' => '3'], 'MMULT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigMatrixFunctions::class, 'multiply'], 'argumentCount' => '2'], 'MOD' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigOperations::class, 'mod'], 'argumentCount' => '2'], 'MODE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalAverages::class, 'mode'], 'argumentCount' => '1+'], 'MODE.MULT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '1+'], 'MODE.SNGL' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalAverages::class, 'mode'], 'argumentCount' => '1+'], 'MONTH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelDateParts::class, 'month'], 'argumentCount' => '1'], 'MROUND' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigRound::class, 'multiple'], 'argumentCount' => '2'], 'MULTINOMIAL' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigFactorial::class, 'multinomial'], 'argumentCount' => '1+'], 'MUNIT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigMatrixFunctions::class, 'identity'], 'argumentCount' => '1'], 'N' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationValue::class, 'asNumber'], 'argumentCount' => '1'], 'NA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationExcelError::class, 'NA'], 'argumentCount' => '0'], 'NEGBINOMDIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsBinomial::class, 'negative'], 'argumentCount' => '3'], 'NEGBINOM.DIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '4'], 'NETWORKDAYS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelNetworkDays::class, 'count'], 'argumentCount' => '2-3'], 'NETWORKDAYS.INTL' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2-4'], 'NOMINAL' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialInterestRate::class, 'nominal'], 'argumentCount' => '2'], 'NORMDIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsNormal::class, 'distribution'], 'argumentCount' => '4'], 'NORM.DIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsNormal::class, 'distribution'], 'argumentCount' => '4'], 'NORMINV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsNormal::class, 'inverse'], 'argumentCount' => '3'], 'NORM.INV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsNormal::class, 'inverse'], 'argumentCount' => '3'], 'NORMSDIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsStandardNormal::class, 'cumulative'], 'argumentCount' => '1'], 'NORM.S.DIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsStandardNormal::class, 'distribution'], 'argumentCount' => '1,2'], 'NORMSINV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsStandardNormal::class, 'inverse'], 'argumentCount' => '1'], 'NORM.S.INV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsStandardNormal::class, 'inverse'], 'argumentCount' => '1'], 'NOT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOGICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLogicalOperations::class, 'NOT'], 'argumentCount' => '1'], 'NOW' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelCurrent::class, 'now'], 'argumentCount' => '0'], 'NPER' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowConstantPeriodic::class, 'periods'], 'argumentCount' => '3-5'], 'NPV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowVariablePeriodic::class, 'presentValue'], 'argumentCount' => '2+'], 'NUMBERSTRING' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'NUMBERVALUE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataFormat::class, 'NUMBERVALUE'], 'argumentCount' => '1+'], 'OCT2BIN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringConvertOctal::class, 'toBinary'], 'argumentCount' => '1,2'], 'OCT2DEC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringConvertOctal::class, 'toDecimal'], 'argumentCount' => '1'], 'OCT2HEX' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_ENGINEERING, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationEngineeringConvertOctal::class, 'toHex'], 'argumentCount' => '1,2'], 'ODD' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigRound::class, 'odd'], 'argumentCount' => '1'], 'ODDFPRICE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '8,9'], 'ODDFYIELD' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '8,9'], 'ODDLPRICE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '7,8'], 'ODDLYIELD' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '7,8'], 'OFFSET' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefOffset::class, 'OFFSET'], 'argumentCount' => '3-5', 'passCellReference' => true, 'passByReference' => [true]], 'OR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOGICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLogicalOperations::class, 'logicalOr'], 'argumentCount' => '1+'], 'PDURATION' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowSingle::class, 'periods'], 'argumentCount' => '3'], 'PEARSON' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalTrends::class, 'CORREL'], 'argumentCount' => '2'], 'PERCENTILE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalPercentiles::class, 'PERCENTILE'], 'argumentCount' => '2'], 'PERCENTILE.EXC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2'], 'PERCENTILE.INC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalPercentiles::class, 'PERCENTILE'], 'argumentCount' => '2'], 'PERCENTRANK' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalPercentiles::class, 'PERCENTRANK'], 'argumentCount' => '2,3'], 'PERCENTRANK.EXC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2,3'], 'PERCENTRANK.INC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalPercentiles::class, 'PERCENTRANK'], 'argumentCount' => '2,3'], 'PERMUT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalPermutations::class, 'PERMUT'], 'argumentCount' => '2'], 'PERMUTATIONA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalPermutations::class, 'PERMUTATIONA'], 'argumentCount' => '2'], 'PHONETIC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '1'], 'PHI' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '1'], 'PI' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => 'pi', 'argumentCount' => '0'], 'PMT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowConstantPeriodicPayments::class, 'annuity'], 'argumentCount' => '3-5'], 'POISSON' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsPoisson::class, 'distribution'], 'argumentCount' => '3'], 'POISSON.DIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsPoisson::class, 'distribution'], 'argumentCount' => '3'], 'POWER' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigOperations::class, 'power'], 'argumentCount' => '2'], 'PPMT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowConstantPeriodicPayments::class, 'interestPayment'], 'argumentCount' => '4-6'], 'PRICE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialSecuritiesPrice::class, 'price'], 'argumentCount' => '6,7'], 'PRICEDISC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialSecuritiesPrice::class, 'priceDiscounted'], 'argumentCount' => '4,5'], 'PRICEMAT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialSecuritiesPrice::class, 'priceAtMaturity'], 'argumentCount' => '5,6'], 'PROB' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '3,4'], 'PRODUCT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigOperations::class, 'product'], 'argumentCount' => '1+'], 'PROPER' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataCaseConvert::class, 'proper'], 'argumentCount' => '1'], 'PV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowConstantPeriodic::class, 'presentValue'], 'argumentCount' => '3-5'], 'QUARTILE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalPercentiles::class, 'QUARTILE'], 'argumentCount' => '2'], 'QUARTILE.EXC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2'], 'QUARTILE.INC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalPercentiles::class, 'QUARTILE'], 'argumentCount' => '2'], 'QUOTIENT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigOperations::class, 'quotient'], 'argumentCount' => '2'], 'RADIANS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigAngle::class, 'toRadians'], 'argumentCount' => '1'], 'RAND' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigRandom::class, 'rand'], 'argumentCount' => '0'], 'RANDARRAY' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigRandom::class, 'randArray'], 'argumentCount' => '0-5'], 'RANDBETWEEN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigRandom::class, 'randBetween'], 'argumentCount' => '2'], 'RANK' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalPercentiles::class, 'RANK'], 'argumentCount' => '2,3'], 'RANK.AVG' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2,3'], 'RANK.EQ' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalPercentiles::class, 'RANK'], 'argumentCount' => '2,3'], 'RATE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowConstantPeriodicInterest::class, 'rate'], 'argumentCount' => '3-6'], 'RECEIVED' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialSecuritiesPrice::class, 'received'], 'argumentCount' => '4-5'], 'REPLACE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataReplace::class, 'replace'], 'argumentCount' => '4'], 'REPLACEB' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataReplace::class, 'replace'], 'argumentCount' => '4'], 'REPT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataConcatenate::class, 'builtinREPT'], 'argumentCount' => '2'], 'RIGHT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataExtract::class, 'right'], 'argumentCount' => '1,2'], 'RIGHTB' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataExtract::class, 'right'], 'argumentCount' => '1,2'], 'ROMAN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigRoman::class, 'evaluate'], 'argumentCount' => '1,2'], 'ROUND' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigRound::class, 'round'], 'argumentCount' => '2'], 'ROUNDBAHTDOWN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'ROUNDBAHTUP' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'ROUNDDOWN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigRound::class, 'down'], 'argumentCount' => '2'], 'ROUNDUP' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigRound::class, 'up'], 'argumentCount' => '2'], 'ROW' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefRowColumnInformation::class, 'ROW'], 'argumentCount' => '-1', 'passCellReference' => true, 'passByReference' => [true]], 'ROWS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefRowColumnInformation::class, 'ROWS'], 'argumentCount' => '1'], 'RRI' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowSingle::class, 'interestRate'], 'argumentCount' => '3'], 'RSQ' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalTrends::class, 'RSQ'], 'argumentCount' => '2'], 'RTD' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '1+'], 'SEARCH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataSearch::class, 'insensitive'], 'argumentCount' => '2,3'], 'SEARCHB' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataSearch::class, 'insensitive'], 'argumentCount' => '2,3'], 'SEC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigSecant::class, 'sec'], 'argumentCount' => '1'], 'SECH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigSecant::class, 'sech'], 'argumentCount' => '1'], 'SECOND' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelTimeParts::class, 'second'], 'argumentCount' => '1'], 'SEQUENCE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigMatrixFunctions::class, 'sequence'], 'argumentCount' => '1-4'], 'SERIESSUM' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigSeriesSum::class, 'evaluate'], 'argumentCount' => '4'], 'SHEET' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '0,1'], 'SHEETS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '0,1'], 'SIGN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigSign::class, 'evaluate'], 'argumentCount' => '1'], 'SIN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigSine::class, 'sin'], 'argumentCount' => '1'], 'SINH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigSine::class, 'sinh'], 'argumentCount' => '1'], 'SKEW' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDeviations::class, 'skew'], 'argumentCount' => '1+'], 'SKEW.P' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '1+'], 'SLN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialDepreciation::class, 'SLN'], 'argumentCount' => '3'], 'SLOPE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalTrends::class, 'SLOPE'], 'argumentCount' => '2'], 'SMALL' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalSize::class, 'small'], 'argumentCount' => '2'], 'SORT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefSort::class, 'sort'], 'argumentCount' => '1-4'], 'SORTBY' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefSort::class, 'sortBy'], 'argumentCount' => '2+'], 'SQRT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigSqrt::class, 'sqrt'], 'argumentCount' => '1'], 'SQRTPI' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigSqrt::class, 'pi'], 'argumentCount' => '1'], 'STANDARDIZE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalStandardize::class, 'execute'], 'argumentCount' => '3'], 'STDEV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalStandardDeviations::class, 'STDEV'], 'argumentCount' => '1+'], 'STDEV.S' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalStandardDeviations::class, 'STDEV'], 'argumentCount' => '1+'], 'STDEV.P' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalStandardDeviations::class, 'STDEVP'], 'argumentCount' => '1+'], 'STDEVA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalStandardDeviations::class, 'STDEVA'], 'argumentCount' => '1+'], 'STDEVP' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalStandardDeviations::class, 'STDEVP'], 'argumentCount' => '1+'], 'STDEVPA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalStandardDeviations::class, 'STDEVPA'], 'argumentCount' => '1+'], 'STEYX' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalTrends::class, 'STEYX'], 'argumentCount' => '2'], 'SUBSTITUTE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataReplace::class, 'substitute'], 'argumentCount' => '3,4'], 'SUBTOTAL' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigSubtotal::class, 'evaluate'], 'argumentCount' => '2+', 'passCellReference' => true], 'SUM' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigSum::class, 'sumErroringStrings'], 'argumentCount' => '1+'], 'SUMIF' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalConditional::class, 'SUMIF'], 'argumentCount' => '2,3'], 'SUMIFS' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalConditional::class, 'SUMIFS'], 'argumentCount' => '3+'], 'SUMPRODUCT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigSum::class, 'product'], 'argumentCount' => '1+'], 'SUMSQ' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigSumSquares::class, 'sumSquare'], 'argumentCount' => '1+'], 'SUMX2MY2' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigSumSquares::class, 'sumXSquaredMinusYSquared'], 'argumentCount' => '2'], 'SUMX2PY2' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigSumSquares::class, 'sumXSquaredPlusYSquared'], 'argumentCount' => '2'], 'SUMXMY2' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigSumSquares::class, 'sumXMinusYSquared'], 'argumentCount' => '2'], 'SWITCH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOGICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLogicalConditional::class, 'statementSwitch'], 'argumentCount' => '3+'], 'SYD' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialDepreciation::class, 'SYD'], 'argumentCount' => '4'], 'T' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataText::class, 'test'], 'argumentCount' => '1'], 'TAN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigTangent::class, 'tan'], 'argumentCount' => '1'], 'TANH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrigTangent::class, 'tanh'], 'argumentCount' => '1'], 'TBILLEQ' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialTreasuryBill::class, 'bondEquivalentYield'], 'argumentCount' => '3'], 'TBILLPRICE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialTreasuryBill::class, 'price'], 'argumentCount' => '3'], 'TBILLYIELD' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialTreasuryBill::class, 'yield'], 'argumentCount' => '3'], 'TDIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsStudentT::class, 'distribution'], 'argumentCount' => '3'], 'T.DIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '3'], 'T.DIST.2T' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2'], 'T.DIST.RT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2'], 'TEXT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataFormat::class, 'TEXTFORMAT'], 'argumentCount' => '2'], 'TEXTJOIN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataConcatenate::class, 'TEXTJOIN'], 'argumentCount' => '3+'], 'THAIDAYOFWEEK' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'THAIDIGIT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'THAIMONTHOFYEAR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'THAINUMSOUND' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'THAINUMSTRING' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'THAISTRINGLENGTH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'THAIYEAR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'TIME' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelTime::class, 'fromHMS'], 'argumentCount' => '3'], 'TIMEVALUE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelTimeValue::class, 'fromString'], 'argumentCount' => '1'], 'TINV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsStudentT::class, 'inverse'], 'argumentCount' => '2'], 'T.INV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsStudentT::class, 'inverse'], 'argumentCount' => '2'], 'T.INV.2T' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2'], 'TODAY' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelCurrent::class, 'today'], 'argumentCount' => '0'], 'TRANSPOSE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefMatrix::class, 'transpose'], 'argumentCount' => '1'], 'TREND' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalTrends::class, 'TREND'], 'argumentCount' => '1-4'], 'TRIM' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataTrim::class, 'spaces'], 'argumentCount' => '1'], 'TRIMMEAN' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalAveragesMean::class, 'trim'], 'argumentCount' => '2'], 'TRUE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOGICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLogicalBoolean::class, 'TRUE'], 'argumentCount' => '0'], 'TRUNC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_MATH_AND_TRIG, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationMathTrigTrunc::class, 'evaluate'], 'argumentCount' => '1,2'], 'TTEST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '4'], 'T.TEST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '4'], 'TYPE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_INFORMATION, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationInformationValue::class, 'type'], 'argumentCount' => '1'], 'UNICHAR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataCharacterConvert::class, 'character'], 'argumentCount' => '1'], 'UNICODE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataCharacterConvert::class, 'code'], 'argumentCount' => '1'], 'UNIQUE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefUnique::class, 'unique'], 'argumentCount' => '1+'], 'UPPER' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataCaseConvert::class, 'upper'], 'argumentCount' => '1'], 'USDOLLAR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialDollar::class, 'format'], 'argumentCount' => '2'], 'VALUE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationTextDataFormat::class, 'VALUE'], 'argumentCount' => '1'], 'VALUETOTEXT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_TEXT_AND_DATA, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '?'], 'VAR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalVariances::class, 'VAR'], 'argumentCount' => '1+'], 'VAR.P' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalVariances::class, 'VARP'], 'argumentCount' => '1+'], 'VAR.S' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalVariances::class, 'VAR'], 'argumentCount' => '1+'], 'VARA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalVariances::class, 'VARA'], 'argumentCount' => '1+'], 'VARP' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalVariances::class, 'VARP'], 'argumentCount' => '1+'], 'VARPA' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalVariances::class, 'VARPA'], 'argumentCount' => '1+'], 'VDB' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '5-7'], 'VLOOKUP' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLookupRefVLookup::class, 'lookup'], 'argumentCount' => '3,4'], 'WEBSERVICE' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_WEB, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationWebService::class, 'webService'], 'argumentCount' => '1'], 'WEEKDAY' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelWeek::class, 'day'], 'argumentCount' => '1,2'], 'WEEKNUM' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelWeek::class, 'number'], 'argumentCount' => '1,2'], 'WEIBULL' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsWeibull::class, 'distribution'], 'argumentCount' => '4'], 'WEIBULL.DIST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsWeibull::class, 'distribution'], 'argumentCount' => '4'], 'WORKDAY' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelWorkDay::class, 'date'], 'argumentCount' => '2-3'], 'WORKDAY.INTL' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2-4'], 'XIRR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowVariableNonPeriodic::class, 'rate'], 'argumentCount' => '2,3'], 'XLOOKUP' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '3-6'], 'XNPV' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialCashFlowVariableNonPeriodic::class, 'presentValue'], 'argumentCount' => '3'], 'XMATCH' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOOKUP_AND_REFERENCE, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '2,3'], 'XOR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_LOGICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationLogicalOperations::class, 'logicalXor'], 'argumentCount' => '1+'], 'YEAR' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelDateParts::class, 'year'], 'argumentCount' => '1'], 'YEARFRAC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_DATE_AND_TIME, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationDateTimeExcelYearFrac::class, 'fraction'], 'argumentCount' => '2,3'], 'YIELD' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFunctions::class, 'DUMMY'], 'argumentCount' => '6,7'], 'YIELDDISC' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialSecuritiesYields::class, 'yieldDiscounted'], 'argumentCount' => '4,5'], 'YIELDMAT' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_FINANCIAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationFinancialSecuritiesYields::class, 'yieldAtMaturity'], 'argumentCount' => '5,6'], 'ZTEST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsStandardNormal::class, 'zTest'], 'argumentCount' => '2-3'], 'Z.TEST' => ['category' => PhpOfficePhpSpreadsheetCalculationCategory::CATEGORY_STATISTICAL, 'functionCall' => [PhpOfficePhpSpreadsheetCalculationStatisticalDistributionsStandardNormal::class, 'zTest'], 'argumentCount' => '2-3']]

$returnArrayAsType

private static mixed $returnArrayAsType = self::RETURN_ARRAY_AS_VALUE

$spreadsheet

Instance of the spreadsheet this Calculation Engine is using.

private Spreadsheet $spreadsheet

$validLocaleLanguages

List of available locale settings Note that this is read for the locale subdirectory only when requested.

private static array<string|int, string> $validLocaleLanguages = ['en']

Methods

__clone()

__clone implementation. Cloning should not be allowed in a Singleton!

public final __clone() : mixed
Return values
mixed

_calculateFormulaValue()

Parse a cell formula and calculate its value.

public _calculateFormulaValue(string $formula[, string $cellID = null ][, Cell $cell = null ]) : mixed
Parameters
$formula : string

The formula to parse and calculate

$cellID : string = null

The ID (e.g. A3) of the cell that we are calculating

$cell : Cell = null

Cell to calculate

Return values
mixed

_translateFormulaToEnglish()

public _translateFormulaToEnglish(mixed $formula) : mixed
Parameters
$formula : mixed
Return values
mixed

_translateFormulaToLocale()

public _translateFormulaToLocale(mixed $formula) : mixed
Parameters
$formula : mixed
Return values
mixed

calculate()

Calculate cell value (using formula from a cell ID) Retained for backward compatibility.

public calculate([Cell $cell = null ]) : mixed
Parameters
$cell : Cell = null

Cell to calculate

Return values
mixed

calculateCellValue()

Calculate the value of a cell formula.

public calculateCellValue([Cell $cell = null ][, bool $resetLog = true ]) : mixed
Parameters
$cell : Cell = null

Cell to calculate

$resetLog : bool = true

Flag indicating whether the debug log should be reset or not

Return values
mixed

calculateFormula()

Calculate the value of a formula.

public calculateFormula(string $formula[, string $cellID = null ][, Cell $cell = null ]) : mixed
Parameters
$formula : string

Formula to parse

$cellID : string = null

Address of the cell to calculate

$cell : Cell = null

Cell to calculate

Return values
mixed

clearCalculationCache()

Clear calculation cache.

public clearCalculationCache() : void
Return values
void

clearCalculationCacheForWorksheet()

Clear calculation cache for a specified worksheet.

public clearCalculationCacheForWorksheet(string $worksheetName) : void
Parameters
$worksheetName : string
Return values
void

disableBranchPruning()

public disableBranchPruning() : void
Return values
void

disableCalculationCache()

Disable calculation cache.

public disableCalculationCache() : void
Return values
void

enableBranchPruning()

public enableBranchPruning() : void
Return values
void

enableCalculationCache()

Enable calculation cache.

public enableCalculationCache() : void
Return values
void

extractCellRange()

Extract range values.

public extractCellRange([string &$range = 'A1' ][, Worksheet $worksheet = null ][, bool $resetLog = true ]) : mixed
Parameters
$range : string = 'A1'

String based range representation

$worksheet : Worksheet = null

Worksheet

$resetLog : bool = true

Flag indicating whether calculation log should be reset or not

Return values
mixed

Array of values in range if range contains more than one element. Otherwise, a single value is returned.

extractNamedRange()

Extract range values.

public extractNamedRange([string &$range = 'A1' ][, null|Worksheet $worksheet = null ][, bool $resetLog = true ]) : mixed
Parameters
$range : string = 'A1'

String based range representation

$worksheet : null|Worksheet = null

Worksheet

$resetLog : bool = true

Flag indicating whether calculation log should be reset or not

Return values
mixed

Array of values in range if range contains more than one element. Otherwise, a single value is returned.

flushInstance()

Flush the calculation cache for any existing instance of this class but only if a Calculation instance exists.

public flushInstance() : void
Return values
void

getArrayReturnType()

Return the Array Return Type (Array or Value of first element in the array).

public static getArrayReturnType() : string
Return values
string

$returnType Array return type

getCalculationCacheEnabled()

Is calculation caching enabled?

public getCalculationCacheEnabled() : bool
Return values
bool

getDebugLog()

Get the Logger for this calculation engine instance.

public getDebugLog() : Logger
Return values
Logger

getFALSE()

Return the locale-specific translation of FALSE.

public static getFALSE() : string
Return values
string

locale-specific translation of FALSE

getFunctions()

Get a list of all implemented functions as an array of function objects.

public getFunctions() : array<string|int, mixed>
Return values
array<string|int, mixed>

getImplementedFunctionNames()

Get a list of implemented Excel function names.

public getImplementedFunctionNames() : array<string|int, mixed>
Return values
array<string|int, mixed>

getInstance()

Get an instance of this class.

public static getInstance([Spreadsheet|null $spreadsheet = null ]) : self
Parameters
$spreadsheet : Spreadsheet|null = null

Injected spreadsheet for working with a PhpSpreadsheet Spreadsheet object, or NULL to create a standalone calculation engine

Return values
self

getLocale()

Get the currently defined locale code.

public getLocale() : string
Return values
string

getMatrixDimensions()

Read the dimensions of a matrix, and re-index it with straight numeric keys starting from row 0, column 0.

public static getMatrixDimensions(array<string|int, mixed> &$matrix) : array<string|int, int>
Parameters
$matrix : array<string|int, mixed>

matrix operand

Return values
array<string|int, int>

An array comprising the number of rows, and number of columns

getTRUE()

Return the locale-specific translation of TRUE.

public static getTRUE() : string
Return values
string

locale-specific translation of TRUE

getValueFromCache()

public getValueFromCache(string $cellReference, mixed &$cellValue) : bool
Parameters
$cellReference : string
$cellValue : mixed
Return values
bool

isImplemented()

Is a specific function implemented?

public isImplemented(string $function) : bool
Parameters
$function : string

Function Name

Return values
bool

localeFunc()

public static localeFunc(mixed $function) : mixed
Parameters
$function : mixed
Return values
mixed

parseFormula()

Validate and parse a formula string.

public parseFormula(string $formula) : array<string|int, mixed>|bool
Parameters
$formula : string

Formula to parse

Return values
array<string|int, mixed>|bool

renameCalculationCacheForWorksheet()

Rename calculation cache for a specified worksheet.

public renameCalculationCacheForWorksheet(string $fromWorksheetName, string $toWorksheetName) : void
Parameters
$fromWorksheetName : string
$toWorksheetName : string
Return values
void

saveValueToCache()

public saveValueToCache(string $cellReference, mixed $cellValue) : void
Parameters
$cellReference : string
$cellValue : mixed
Return values
void

setArrayReturnType()

Set the Array Return Type (Array or Value of first element in the array).

public static setArrayReturnType(string $returnType) : bool
Parameters
$returnType : string

Array return type

Return values
bool

Success or failure

setBranchPruningEnabled()

Enable/disable calculation cache.

public setBranchPruningEnabled(mixed $enabled) : void
Parameters
$enabled : mixed
Return values
void

setCalculationCacheEnabled()

Enable/disable calculation cache.

public setCalculationCacheEnabled(bool $calculationCacheEnabled) : void
Parameters
$calculationCacheEnabled : bool
Return values
void

setLocale()

Set the locale code.

public setLocale(string $locale) : bool
Parameters
$locale : string

The locale to use for formula translation, eg: 'en_us'

Return values
bool

translateSeparator()

public static translateSeparator(string $fromSeparator, string $toSeparator, string $formula, int &$inBracesLevel[, string $openBrace = self::FORMULA_OPEN_FUNCTION_BRACE ][, string $closeBrace = self::FORMULA_CLOSE_FUNCTION_BRACE ]) : string
Parameters
$fromSeparator : string
$toSeparator : string
$formula : string
$inBracesLevel : int
$openBrace : string = self::FORMULA_OPEN_FUNCTION_BRACE
$closeBrace : string = self::FORMULA_CLOSE_FUNCTION_BRACE
Return values
string

unwrapResult()

Remove quotes used as a wrapper to identify string values.

public static unwrapResult(mixed $value) : mixed
Parameters
$value : mixed
Return values
mixed

wrapResult()

Wrap string values in quotes.

public static wrapResult(mixed $value) : mixed
Parameters
$value : mixed
Return values
mixed

raiseFormulaError()

Trigger an error, but nicely, if need be.

protected raiseFormulaError(string $errorMessage) : false
Parameters
$errorMessage : string
Return values
false

addCellReference()

Add cell reference if needed while making sure that it is the last argument.

private addCellReference(array<string|int, mixed> $args, bool $passCellReference, array<string|int, mixed>|string $functionCall[, Cell|null $cell = null ]) : array<string|int, mixed>
Parameters
$args : array<string|int, mixed>
$passCellReference : bool
$functionCall : array<string|int, mixed>|string
$cell : Cell|null = null
Return values
array<string|int, mixed>

addDefaultArgumentValues()

private addDefaultArgumentValues(array<string|int, mixed> $functionCall, array<string|int, mixed> $args, array<string|int, mixed> $emptyArguments) : array<string|int, mixed>
Parameters
$functionCall : array<string|int, mixed>
$args : array<string|int, mixed>
$emptyArguments : array<string|int, mixed>
Return values
array<string|int, mixed>

checkMatrixOperands()

Ensure that paired matrix operands are both matrices and of the same size.

private static checkMatrixOperands(mixed &$operand1, mixed &$operand2[, int $resize = 1 ]) : array<string|int, mixed>
Parameters
$operand1 : mixed

First matrix operand

$operand2 : mixed

Second matrix operand

$resize : int = 1

Flag indicating whether the matrices should be resized to match and (if so), whether the smaller dimension should grow or the larger should shrink. 0 = no resize 1 = shrink to fit 2 = extend to fit

Return values
array<string|int, mixed>

convertMatrixReferences()

private convertMatrixReferences(string $formula) : false|string
Parameters
$formula : string
Return values
false|string

False indicates an error

dataTestReference()

private static dataTestReference(mixed &$operandData) : mixed
Parameters
$operandData : mixed
Return values
mixed

executeArrayComparison()

private executeArrayComparison(mixed $operand1, mixed $operand2, string $operation, Stack &$stack, bool $recursingArrays) : array<string|int, mixed>
Parameters
$operand1 : mixed
$operand2 : mixed
$operation : string
$stack : Stack
$recursingArrays : bool
Return values
array<string|int, mixed>

executeBinaryComparisonOperation()

private executeBinaryComparisonOperation(mixed $operand1, mixed $operand2, string $operation, Stack &$stack[, bool $recursingArrays = false ]) : mixed
Parameters
$operand1 : mixed
$operand2 : mixed
$operation : string
$stack : Stack
$recursingArrays : bool = false
Return values
mixed

executeNumericBinaryOperation()

private executeNumericBinaryOperation(mixed $operand1, mixed $operand2, mixed $operation, string $matrixFunction, mixed &$stack) : bool|mixed
Parameters
$operand1 : mixed
$operand2 : mixed
$operation : mixed
$matrixFunction : string
$stack : mixed
Return values
bool|mixed

getArgumentDefaultValue()

private getArgumentDefaultValue(ReflectionParameter $methodArgument) : null|mixed
Parameters
$methodArgument : ReflectionParameter
Return values
null|mixed

getLocaleFile()

private getLocaleFile(string $localeDir, string $locale, string $language, string $file) : string
Parameters
$localeDir : string
$locale : string
$language : string
$file : string
Return values
string

getTokensAsString()

private getTokensAsString(mixed $tokens) : mixed
Parameters
$tokens : mixed
Return values
mixed

internalParseFormula()

private internalParseFormula(string $formula[, Cell|null $cell = null ]) : array<int, mixed>|false
Parameters
$formula : string
$cell : Cell|null = null
Return values
array<int, mixed>|false

loadLocales()

private static loadLocales() : void
Return values
void

processTokenStack()

private processTokenStack(mixed $tokens[, null|string $cellID = null ][, Cell|null $cell = null ]) : array<int, mixed>|false
Parameters
$tokens : mixed
$cellID : null|string = null
$cell : Cell|null = null
Return values
array<int, mixed>|false

resizeMatricesExtend()

Ensure that paired matrix operands are both matrices of the same size.

private static resizeMatricesExtend(mixed &$matrix1, mixed &$matrix2, int $matrix1Rows, int $matrix1Columns, int $matrix2Rows, int $matrix2Columns) : void
Parameters
$matrix1 : mixed

First matrix operand

$matrix2 : mixed

Second matrix operand

$matrix1Rows : int

Row size of first matrix operand

$matrix1Columns : int

Column size of first matrix operand

$matrix2Rows : int

Row size of second matrix operand

$matrix2Columns : int

Column size of second matrix operand

Return values
void

resizeMatricesShrink()

Ensure that paired matrix operands are both matrices of the same size.

private static resizeMatricesShrink(mixed &$matrix1, mixed &$matrix2, int $matrix1Rows, int $matrix1Columns, int $matrix2Rows, int $matrix2Columns) : void
Parameters
$matrix1 : mixed

First matrix operand

$matrix2 : mixed

Second matrix operand

$matrix1Rows : int

Row size of first matrix operand

$matrix1Columns : int

Column size of first matrix operand

$matrix2Rows : int

Row size of second matrix operand

$matrix2Columns : int

Column size of second matrix operand

Return values
void

showTypeDetails()

Format type and details of an operand for display in the log (based on operand type).

private showTypeDetails(mixed $value) : null|string
Parameters
$value : mixed

First matrix operand

Return values
null|string

showValue()

Format details of an operand for display in the log (based on operand type).

private showValue(mixed $value) : mixed
Parameters
$value : mixed

First matrix operand

Return values
mixed

translateFormula()

private static translateFormula(array<string|int, mixed> $from, array<string|int, mixed> $to, string $formula, string $fromSeparator, string $toSeparator) : string
Parameters
$from : array<string|int, mixed>
$to : array<string|int, mixed>
$formula : string
$fromSeparator : string
$toSeparator : string
Return values
string

translateFormulaBlock()

private static translateFormulaBlock(array<string|int, mixed> $from, array<string|int, mixed> $to, string $formula, int &$inFunctionBracesLevel, int &$inMatrixBracesLevel, string $fromSeparator, string $toSeparator) : string
Parameters
$from : array<string|int, mixed>
$to : array<string|int, mixed>
$formula : string
$inFunctionBracesLevel : int
$inMatrixBracesLevel : int
$fromSeparator : string
$toSeparator : string
Return values
string

validateBinaryOperand()

private validateBinaryOperand(mixed &$operand, mixed &$stack) : mixed
Parameters
$operand : mixed
$stack : mixed
Return values
mixed

Search results