| [ Index ] |
PHP Cross Reference of moodle-2.8 |
[Source view] [Print] [Project Stats]
PHPExcel Copyright (c) 2006 - 2014 PHPExcel
| Copyright: | Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel) |
| License: | http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL |
| Version: | ##VERSION##, ##DATE## |
| File Size: | 3933 lines (175 kb) |
| Included or required: | 0 times |
| Referenced: | 0 times |
| Includes or requires: | 0 files |
PHPExcel_Calculation:: (57 methods):
__construct()
__destruct()
_loadLocales()
getInstance()
unsetInstance()
flushInstance()
getDebugLog()
__clone()
getTRUE()
getFALSE()
setArrayReturnType()
getArrayReturnType()
getCalculationCacheEnabled()
setCalculationCacheEnabled()
enableCalculationCache()
disableCalculationCache()
clearCalculationCache()
clearCalculationCacheForWorksheet()
renameCalculationCacheForWorksheet()
getLocale()
setLocale()
_translateSeparator()
_translateFormula()
_translateFormulaToLocale()
_translateFormulaToEnglish()
_localeFunc()
_wrapResult()
_unwrapResult()
calculate()
calculateCellValue()
parseFormula()
calculateFormula()
getValueFromCache()
saveValueToCache()
_calculateFormulaValue()
_checkMatrixOperands()
_getMatrixDimensions()
_resizeMatricesShrink()
_resizeMatricesExtend()
_showValue()
_showTypeDetails()
_convertMatrixReferences()
_mkMatrix()
_parseFormula()
_dataTestReference()
_processTokenStack()
_validateBinaryOperand()
_executeBinaryComparisonOperation()
strcmpLowercaseFirst()
_executeNumericBinaryOperation()
_raiseFormulaError()
extractCellRange()
extractNamedRange()
isImplemented()
listFunctions()
listAllFunctionNames()
listFunctionNames()
Class: PHPExcel_Calculation - X-Ref
PHPExcel_Calculation (Multiton)| __construct(PHPExcel $workbook = NULL) X-Ref |
| No description |
| __destruct() X-Ref |
| No description |
| _loadLocales() X-Ref |
| No description |
| getInstance(PHPExcel $workbook = NULL) X-Ref |
| Get an instance of this class param: PHPExcel $workbook Injected workbook for working with a PHPExcel object, return: PHPExcel_Calculation |
| unsetInstance(PHPExcel $workbook = NULL) X-Ref |
| Unset an instance of this class param: PHPExcel $workbook Injected workbook identifying the instance to unset |
| flushInstance() X-Ref |
| Flush the calculation cache for any existing instance of this class but only if a PHPExcel_Calculation instance exists return: null |
| getDebugLog() X-Ref |
| Get the debuglog for this claculation engine instance return: PHPExcel_CalcEngine_Logger |
| __clone() X-Ref |
| __clone implementation. Cloning should not be allowed in a Singleton! |
| getTRUE() X-Ref |
| Return the locale-specific translation of TRUE return: string locale-specific translation of TRUE |
| getFALSE() X-Ref |
| Return the locale-specific translation of FALSE return: string locale-specific translation of FALSE |
| setArrayReturnType($returnType) X-Ref |
| Set the Array Return Type (Array or Value of first element in the array) param: string $returnType Array return type return: boolean Success or failure |
| getArrayReturnType() X-Ref |
| Return the Array Return Type (Array or Value of first element in the array) return: string $returnType Array return type |
| getCalculationCacheEnabled() X-Ref |
| Is calculation caching enabled? return: boolean |
| setCalculationCacheEnabled($pValue = TRUE) X-Ref |
| Enable/disable calculation cache param: boolean $pValue |
| enableCalculationCache() X-Ref |
| Enable calculation cache |
| disableCalculationCache() X-Ref |
| Disable calculation cache |
| clearCalculationCache() X-Ref |
| Clear calculation cache |
| clearCalculationCacheForWorksheet($worksheetName) X-Ref |
| Clear calculation cache for a specified worksheet param: string $worksheetName |
| renameCalculationCacheForWorksheet($fromWorksheetName, $toWorksheetName) X-Ref |
| Rename calculation cache for a specified worksheet param: string $fromWorksheetName param: string $toWorksheetName |
| getLocale() X-Ref |
| Get the currently defined locale code return: string |
| setLocale($locale = 'en_us') X-Ref |
| Set the locale code param: string $locale The locale to use for formula translation return: boolean |
| _translateSeparator($fromSeparator,$toSeparator,$formula,&$inBraces) X-Ref |
| No description |
| _translateFormula($from,$to,$formula,$fromSeparator,$toSeparator) X-Ref |
| No description |
| _translateFormulaToLocale($formula) X-Ref |
| No description |
| _translateFormulaToEnglish($formula) X-Ref |
| No description |
| _localeFunc($function) X-Ref |
| No description |
| _wrapResult($value) X-Ref |
| Wrap string values in quotes param: mixed $value return: mixed |
| _unwrapResult($value) X-Ref |
| Remove quotes used as a wrapper to identify string values param: mixed $value return: mixed |
| calculate(PHPExcel_Cell $pCell = NULL) X-Ref |
| Calculate cell value (using formula from a cell ID) Retained for backward compatibility param: PHPExcel_Cell $pCell Cell to calculate return: mixed |
| calculateCellValue(PHPExcel_Cell $pCell = NULL, $resetLog = TRUE) X-Ref |
| Calculate the value of a cell formula param: PHPExcel_Cell $pCell Cell to calculate param: Boolean $resetLog Flag indicating whether the debug log should be reset or not return: mixed |
| parseFormula($formula) X-Ref |
| Validate and parse a formula string param: string $formula Formula to parse return: array |
| calculateFormula($formula, $cellID=NULL, PHPExcel_Cell $pCell = NULL) X-Ref |
| Calculate the value of a formula param: string $formula Formula to parse param: string $cellID Address of the cell to calculate param: PHPExcel_Cell $pCell Cell to calculate return: mixed |
| getValueFromCache($worksheetName, $cellID, &$cellValue) X-Ref |
| No description |
| saveValueToCache($worksheetName, $cellID, $cellValue) X-Ref |
| No description |
| _calculateFormulaValue($formula, $cellID=null, PHPExcel_Cell $pCell = null) X-Ref |
| Parse a cell formula and calculate its value param: string $formula The formula to parse and calculate param: string $cellID The ID (e.g. A3) of the cell that we are calculating param: PHPExcel_Cell $pCell Cell to calculate return: mixed |
| _checkMatrixOperands(&$operand1,&$operand2,$resize = 1) X-Ref |
| Ensure that paired matrix operands are both matrices and of the same size param: mixed &$operand1 First matrix operand param: mixed &$operand2 Second matrix operand param: integer $resize Flag indicating whether the matrices should be resized to match |
| _getMatrixDimensions(&$matrix) X-Ref |
| Read the dimensions of a matrix, and re-index it with straight numeric keys starting from row 0, column 0 param: mixed &$matrix matrix operand return: array An array comprising the number of rows, and number of columns |
| _resizeMatricesShrink(&$matrix1,&$matrix2,$matrix1Rows,$matrix1Columns,$matrix2Rows,$matrix2Columns) X-Ref |
| Ensure that paired matrix operands are both matrices of the same size param: mixed &$matrix1 First matrix operand param: mixed &$matrix2 Second matrix operand param: integer $matrix1Rows Row size of first matrix operand param: integer $matrix1Columns Column size of first matrix operand param: integer $matrix2Rows Row size of second matrix operand param: integer $matrix2Columns Column size of second matrix operand |
| _resizeMatricesExtend(&$matrix1,&$matrix2,$matrix1Rows,$matrix1Columns,$matrix2Rows,$matrix2Columns) X-Ref |
| Ensure that paired matrix operands are both matrices of the same size param: mixed &$matrix1 First matrix operand param: mixed &$matrix2 Second matrix operand param: integer $matrix1Rows Row size of first matrix operand param: integer $matrix1Columns Column size of first matrix operand param: integer $matrix2Rows Row size of second matrix operand param: integer $matrix2Columns Column size of second matrix operand |
| _showValue($value) X-Ref |
| Format details of an operand for display in the log (based on operand type) param: mixed $value First matrix operand return: mixed |
| _showTypeDetails($value) X-Ref |
| Format type and details of an operand for display in the log (based on operand type) param: mixed $value First matrix operand return: mixed |
| _convertMatrixReferences($formula) X-Ref |
| No description |
| _mkMatrix() X-Ref |
| No description |
| _parseFormula($formula, PHPExcel_Cell $pCell = NULL) X-Ref |
| No description |
| _dataTestReference(&$operandData) X-Ref |
| No description |
| _processTokenStack($tokens, $cellID = NULL, PHPExcel_Cell $pCell = NULL) X-Ref |
| No description |
| _validateBinaryOperand($cellID, &$operand, &$stack) X-Ref |
| No description |
| _executeBinaryComparisonOperation($cellID, $operand1, $operand2, $operation, &$stack, $recursingArrays=FALSE) X-Ref |
| No description |
| strcmpLowercaseFirst($str1, $str2) X-Ref |
| Compare two strings in the same way as strcmp() except that lowercase come before uppercase letters param: string $str1 param: string $str2 return: integer |
| _executeNumericBinaryOperation($cellID,$operand1,$operand2,$operation,$matrixFunction,&$stack) X-Ref |
| No description |
| _raiseFormulaError($errorMessage) X-Ref |
| No description |
| extractCellRange(&$pRange = 'A1', PHPExcel_Worksheet $pSheet = NULL, $resetLog = TRUE) X-Ref |
| Extract range values param: string &$pRange String based range representation param: PHPExcel_Worksheet $pSheet Worksheet param: boolean $resetLog Flag indicating whether calculation log should be reset or not return: mixed Array of values in range if range contains more than one element. Otherwise, a single value is returned. |
| extractNamedRange(&$pRange = 'A1', PHPExcel_Worksheet $pSheet = NULL, $resetLog = TRUE) X-Ref |
| Extract range values param: string &$pRange String based range representation param: PHPExcel_Worksheet $pSheet Worksheet param: boolean $resetLog Flag indicating whether calculation log should be reset or not return: mixed Array of values in range if range contains more than one element. Otherwise, a single value is returned. |
| isImplemented($pFunction = '') X-Ref |
| Is a specific function implemented? param: string $pFunction Function Name return: boolean |
| listFunctions() X-Ref |
| Get a list of all implemented functions as an array of function objects return: array of PHPExcel_Calculation_Function |
| listAllFunctionNames() X-Ref |
| Get a list of all Excel function names return: array |
| listFunctionNames() X-Ref |
| Get a list of implemented Excel function names return: array |
| Generated: Fri Nov 28 20:29:05 2014 | Cross-referenced by PHPXref 0.7.1 |