CALCULATION_REGEXP_NUMBER
CALCULATION_REGEXP_NUMBER = '[-+]?\\d*\\.?\\d+(e[-+]?\\d+)?'
Regular Expressions
PHPExcel_Calculation (Multiton)
$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
$formulaError : string
Error message for any error that was raised/thrown by the calculation engine
$cyclicFormulaCount : int
Number of iterations for cyclic formulae
$_localeBoolean : string[]
Locale-specific translations for Excel constants (True, False and Null)
$_instance : \PHPExcel_Calculation
Instance of this class
$_workbook : \PHPExcel
Instance of the workbook this Calculation Engine is using
$_workbookSets : \PHPExcel_Calculation[]
List of instances of the calculation engine that we've instantiated for individual workbooks
$_calculationCache : array
Calculation cache
$_calculationCacheEnabled : bool
Calculation cache enabled
$_operators : array
List of operators that can be used within formulae The true/false value indicates whether it is a binary operator or a unary operator
$_binaryOperators : array
List of binary operators (those that expect two operands)
$debugLog : \PHPExcel_CalcEngine_Logger
The debug log generated by the calculation engine
$_cyclicReferenceStack : array
An array of the nested cell references accessed by the calculation engine, used for the debug log
$_cyclicFormulaCount : 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
$_savedPrecision : int
Precision used for calculations
$_localeLanguage : string
The current locale setting
$_validLocaleLanguages : string[]
List of available locale settings Note that this is read for the locale subdirectory only when requested
$_localeArgumentSeparator : string
Locale-specific argument separator for function arguments
$_ExcelConstants : string[]
Excel constant string translations to their PHP equivalents Constant conversion from text name/value to actual (datatyped) value
calculateCellValue(\PHPExcel_Cell $pCell = NULL, bool $resetLog = TRUE) : mixed
Calculate the value of a cell formula
| \PHPExcel_Cell | $pCell | Cell to calculate |
| bool | $resetLog | Flag indicating whether the debug log should be reset or not |
calculateFormula(string $formula, string $cellID = NULL, \PHPExcel_Cell $pCell = NULL) : mixed
Calculate the value of a formula
| string | $formula | Formula to parse |
| string | $cellID | Address of the cell to calculate |
| \PHPExcel_Cell | $pCell | Cell to calculate |
_calculateFormulaValue(string $formula, string $cellID = null, \PHPExcel_Cell $pCell = null) : mixed
Parse a cell formula and calculate its value
| string | $formula | The formula to parse and calculate |
| string | $cellID | The ID (e.g. A3) of the cell that we are calculating |
| \PHPExcel_Cell | $pCell | Cell to calculate |
extractCellRange(string $pRange = 'A1', \PHPExcel_Worksheet $pSheet = NULL, bool $resetLog = TRUE) : mixed
Extract range values
| string | $pRange | String based range representation |
| \PHPExcel_Worksheet | $pSheet | Worksheet |
| bool | $resetLog | Flag indicating whether calculation log should be reset or not |
Array of values in range if range contains more than one element. Otherwise, a single value is returned.
extractNamedRange(string $pRange = 'A1', \PHPExcel_Worksheet $pSheet = NULL, bool $resetLog = TRUE) : mixed
Extract range values
| string | $pRange | String based range representation |
| \PHPExcel_Worksheet | $pSheet | Worksheet |
| bool | $resetLog | Flag indicating whether calculation log should be reset or not |
Array of values in range if range contains more than one element. Otherwise, a single value is returned.
_checkMatrixOperands(mixed $operand1, mixed $operand2, int $resize = 1) : mixed
Ensure that paired matrix operands are both matrices and of the same size
| mixed | $operand1 | First matrix operand |
| mixed | $operand2 | Second matrix operand |
| int | $resize | 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 |
_resizeMatricesShrink(mixed $matrix1, mixed $matrix2, int $matrix1Rows, int $matrix1Columns, int $matrix2Rows, int $matrix2Columns) : mixed
Ensure that paired matrix operands are both matrices of the same size
| mixed | $matrix1 | First matrix operand |
| mixed | $matrix2 | Second matrix operand |
| int | $matrix1Rows | Row size of first matrix operand |
| int | $matrix1Columns | Column size of first matrix operand |
| int | $matrix2Rows | Row size of second matrix operand |
| int | $matrix2Columns | Column size of second matrix operand |
_resizeMatricesExtend(mixed $matrix1, mixed $matrix2, int $matrix1Rows, int $matrix1Columns, int $matrix2Rows, int $matrix2Columns) : mixed
Ensure that paired matrix operands are both matrices of the same size
| mixed | $matrix1 | First matrix operand |
| mixed | $matrix2 | Second matrix operand |
| int | $matrix1Rows | Row size of first matrix operand |
| int | $matrix1Columns | Column size of first matrix operand |
| int | $matrix2Rows | Row size of second matrix operand |
| int | $matrix2Columns | Column size of second matrix operand |
_executeBinaryComparisonOperation(mixed $cellID, mixed $operand1, mixed $operand2, mixed $operation, mixed $stack, mixed $recursingArrays = FALSE) : mixed
| mixed | $cellID | |
| mixed | $operand1 | |
| mixed | $operand2 | |
| mixed | $operation | |
| mixed | $stack | |
| mixed | $recursingArrays |
_executeNumericBinaryOperation(mixed $cellID, mixed $operand1, mixed $operand2, mixed $operation, mixed $matrixFunction, mixed $stack) : mixed
| mixed | $cellID | |
| mixed | $operand1 | |
| mixed | $operand2 | |
| mixed | $operation | |
| mixed | $matrixFunction | |
| mixed | $stack |