Docs For Class PHPExcel

static $returnArrayAsType = self::RETURN_ARRAY_AS_VALUE

[line 79]

Tags:

access:

private

Type:

mixed

[ Top ]

static $_instance =

[line 87]

Instance of this class

Tags:

access:

private

Type:

PHPExcel_Calculation

[ Top ]

$debugLog = array()

[line 138]

Tags:

access:

public

Type:

mixed

[ Top ]

$debugLogStack = array()

[line 137]

Tags:

access:

private

Type:

mixed

[ Top ]

$formulaError = null

[line 135]

Tags:

access:

public

Type:

mixed

[ Top ]

$suppressFormulaErrors = false

[line 134]

Tags:

access:

public

Type:

mixed

[ Top ]

$writeDebugLog = false

[line 136]

Tags:

access:

public

Type:

mixed

[ Top ]

$_binaryOperators = array('+', '-', '*', '/', '^', '&', '>', '<', '=', '>=', '<=', '<>', '|', ':')

[line 132]

List of binary operators (those that expect two operands)

Tags:

access:

private

Type:

array

[ Top ]

$_calculationCache = array ()

[line 96]

Calculation cache

Tags:

access:

private

Type:

array

[ Top ]

$_calculationCacheEnabled = true

[line 105]

Calculation cache enabled

Tags:

access:

private

Type:

boolean

[ Top ]

$_calculationCacheExpirationTime = 2.5

[line 114]

Calculation cache expiration time

Tags:

access:

private

Type:

float

[ Top ]

$_controlFunctions = array(
            'MKMATRIX'   => array('argumentCount'   =>   '*',
                            'functionCall'      =>   'self::_mkMatrix'
                           ))

[line 1582]

Tags:

access:

private

Type:

mixed

[ Top ]

$_ExcelConstants = array('TRUE'      => True,
                            'FALSE'   => False,
                            'NULL'      => Null
                           )

[line 142]

Tags:

access:

private

Type:

mixed

[ Top ]

$_operators = array('+', '-', '*', '/', '^', '&', '%', '~', '>', '<', '=', '>=', '<=', '<>', '|', ':')

[line 123]

List of operators that can be used within formulae

Tags:

access:

private

Type:

array

[ Top ]

$_PHPExcelFunctions = array(   // PHPExcel functions
            'ABS'               => array('category'         =>   PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
                                     'functionCall'      =>   'abs',
                                     'argumentCount'   =>   '1'
                                    ),'ACCRINT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::ACCRINT','argumentCount'=>'4-7'),'ACCRINTM'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::ACCRINTM','argumentCount'=>'3-5'),'ACOS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'acos','argumentCount'=>'1'),'ACOSH'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'acosh','argumentCount'=>'1'),'ADDRESS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::CELL_ADDRESS','argumentCount'=>'2-5'),'AMORDEGRC'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::AMORDEGRC','argumentCount'=>'6,7'),'AMORLINC'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::AMORLINC','argumentCount'=>'6,7'),'AND'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOGICAL,'functionCall'=>'PHPExcel_Calculation_Functions::LOGICAL_AND','argumentCount'=>'1+'),'AREAS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'1'),'ASC'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'1'),'ASIN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'asin','argumentCount'=>'1'),'ASINH'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'asinh','argumentCount'=>'1'),'ATAN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'atan','argumentCount'=>'1'),'ATAN2'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::REVERSE_ATAN2','argumentCount'=>'2'),'ATANH'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'atanh','argumentCount'=>'1'),'AVEDEV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::AVEDEV','argumentCount'=>'1+'),'AVERAGE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::AVERAGE','argumentCount'=>'1+'),'AVERAGEA'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::AVERAGEA','argumentCount'=>'1+'),'AVERAGEIF'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'2,3'),'AVERAGEIFS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'3+'),'BAHTTEXT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'1'),'BESSELI'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::BESSELI','argumentCount'=>'2'),'BESSELJ'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::BESSELJ','argumentCount'=>'2'),'BESSELK'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::BESSELK','argumentCount'=>'2'),'BESSELY'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::BESSELY','argumentCount'=>'2'),'BETADIST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::BETADIST','argumentCount'=>'3-5'),'BETAINV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::BETAINV','argumentCount'=>'3-5'),'BIN2DEC'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::BINTODEC','argumentCount'=>'1'),'BIN2HEX'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::BINTOHEX','argumentCount'=>'1,2'),'BIN2OCT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::BINTOOCT','argumentCount'=>'1,2'),'BINOMDIST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::BINOMDIST','argumentCount'=>'4'),'CEILING'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::CEILING','argumentCount'=>'2'),'CELL'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'1,2'),'CHAR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::CHARACTER','argumentCount'=>'1'),'CHIDIST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::CHIDIST','argumentCount'=>'2'),'CHIINV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::CHIINV','argumentCount'=>'2'),'CHITEST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'2'),'CHOOSE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::CHOOSE','argumentCount'=>'2+'),'CLEAN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::TRIMNONPRINTABLE','argumentCount'=>'1'),'CODE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::ASCIICODE','argumentCount'=>'1'),'COLUMN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::COLUMN','argumentCount'=>'-1','passByReference'=>array(true)),'COLUMNS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::COLUMNS','argumentCount'=>'1'),'COMBIN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::COMBIN','argumentCount'=>'2'),'COMPLEX'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::COMPLEX','argumentCount'=>'2,3'),'CONCATENATE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::CONCATENATE','argumentCount'=>'1+'),'CONFIDENCE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::CONFIDENCE','argumentCount'=>'3'),'CONVERT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::CONVERTUOM','argumentCount'=>'3'),'CORREL'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::CORREL','argumentCount'=>'2'),'COS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'cos','argumentCount'=>'1'),'COSH'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'cosh','argumentCount'=>'1'),'COUNT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::COUNT','argumentCount'=>'1+'),'COUNTA'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::COUNTA','argumentCount'=>'1+'),'COUNTBLANK'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::COUNTBLANK','argumentCount'=>'1'),'COUNTIF'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::COUNTIF','argumentCount'=>'2'),'COUNTIFS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'2'),'COUPDAYBS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'3,4'),'COUPDAYS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'3,4'),'COUPDAYSNC'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'3,4'),'COUPNCD'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'3,4'),'COUPNUM'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::COUPNUM','argumentCount'=>'3,4'),'COUPPCD'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'3,4'),'COVAR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::COVAR','argumentCount'=>'2'),'CRITBINOM'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::CRITBINOM','argumentCount'=>'3'),'CUBEKPIMEMBER'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_CUBE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'CUBEMEMBER'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_CUBE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'CUBEMEMBERPROPERTY'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_CUBE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'CUBERANKEDMEMBER'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_CUBE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'CUBESET'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_CUBE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'CUBESETCOUNT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_CUBE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'CUBEVALUE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_CUBE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'CUMIPMT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::CUMIPMT','argumentCount'=>'6'),'CUMPRINC'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::CUMPRINC','argumentCount'=>'6'),'DATE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::DATE','argumentCount'=>'3'),'DATEDIF'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::DATEDIF','argumentCount'=>'2,3'),'DATEVALUE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::DATEVALUE','argumentCount'=>'1'),'DAVERAGE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATABASE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'DAY'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::DAYOFMONTH','argumentCount'=>'1'),'DAYS360'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::DAYS360','argumentCount'=>'2,3'),'DB'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DB','argumentCount'=>'4,5'),'DCOUNT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATABASE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'DCOUNTA'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATABASE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'DDB'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DDB','argumentCount'=>'4,5'),'DEC2BIN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::DECTOBIN','argumentCount'=>'1,2'),'DEC2HEX'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::DECTOHEX','argumentCount'=>'1,2'),'DEC2OCT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::DECTOOCT','argumentCount'=>'1,2'),'DEGREES'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'rad2deg','argumentCount'=>'1'),'DELTA'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::DELTA','argumentCount'=>'1,2'),'DEVSQ'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::DEVSQ','argumentCount'=>'1+'),'DGET'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATABASE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'DISC'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DISC','argumentCount'=>'4,5'),'DMAX'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATABASE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'DMIN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATABASE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'DOLLAR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::DOLLAR','argumentCount'=>'1,2'),'DOLLARDE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DOLLARDE','argumentCount'=>'2'),'DOLLARFR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DOLLARFR','argumentCount'=>'2'),'DPRODUCT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATABASE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'DSTDEV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATABASE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'DSTDEVP'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATABASE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'DSUM'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATABASE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'DURATION'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'5,6'),'DVAR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATABASE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'DVARP'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATABASE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'EDATE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::EDATE','argumentCount'=>'2'),'EFFECT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::EFFECT','argumentCount'=>'2'),'EOMONTH'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::EOMONTH','argumentCount'=>'2'),'ERF'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::ERF','argumentCount'=>'1,2'),'ERFC'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::ERFC','argumentCount'=>'1'),'ERROR.TYPE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::ERROR_TYPE','argumentCount'=>'1'),'EVEN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::EVEN','argumentCount'=>'1'),'EXACT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'2'),'EXP'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'exp','argumentCount'=>'1'),'EXPONDIST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::EXPONDIST','argumentCount'=>'3'),'FACT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::FACT','argumentCount'=>'1'),'FACTDOUBLE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::FACTDOUBLE','argumentCount'=>'1'),'FALSE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOGICAL,'functionCall'=>'PHPExcel_Calculation_Functions::LOGICAL_FALSE','argumentCount'=>'0'),'FDIST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'3'),'FIND'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::SEARCHSENSITIVE','argumentCount'=>'2,3'),'FINDB'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::SEARCHSENSITIVE','argumentCount'=>'2,3'),'FINV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'3'),'FISHER'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::FISHER','argumentCount'=>'1'),'FISHERINV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::FISHERINV','argumentCount'=>'1'),'FIXED'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::FIXEDFORMAT','argumentCount'=>'1-3'),'FLOOR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::FLOOR','argumentCount'=>'2'),'FORECAST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::FORECAST','argumentCount'=>'3'),'FREQUENCY'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'2'),'FTEST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'2'),'FV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::FV','argumentCount'=>'3-5'),'FVSCHEDULE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::FVSCHEDULE','argumentCount'=>'2'),'GAMMADIST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::GAMMADIST','argumentCount'=>'4'),'GAMMAINV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::GAMMAINV','argumentCount'=>'3'),'GAMMALN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::GAMMALN','argumentCount'=>'1'),'GCD'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::GCD','argumentCount'=>'1+'),'GEOMEAN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::GEOMEAN','argumentCount'=>'1+'),'GESTEP'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::GESTEP','argumentCount'=>'1,2'),'GETPIVOTDATA'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'2+'),'GROWTH'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::GROWTH','argumentCount'=>'1-4'),'HARMEAN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::HARMEAN','argumentCount'=>'1+'),'HEX2BIN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::HEXTOBIN','argumentCount'=>'1,2'),'HEX2DEC'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::HEXTODEC','argumentCount'=>'1'),'HEX2OCT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::HEXTOOCT','argumentCount'=>'1,2'),'HLOOKUP'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'3,4'),'HOUR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::HOUROFDAY','argumentCount'=>'1'),'HYPERLINK'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'1,2'),'HYPGEOMDIST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::HYPGEOMDIST','argumentCount'=>'4'),'IF'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOGICAL,'functionCall'=>'PHPExcel_Calculation_Functions::STATEMENT_IF','argumentCount'=>'1-3'),'IFERROR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOGICAL,'functionCall'=>'PHPExcel_Calculation_Functions::STATEMENT_IFERROR','argumentCount'=>'2'),'IMABS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMABS','argumentCount'=>'1'),'IMAGINARY'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMAGINARY','argumentCount'=>'1'),'IMARGUMENT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMARGUMENT','argumentCount'=>'1'),'IMCONJUGATE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMCONJUGATE','argumentCount'=>'1'),'IMCOS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMCOS','argumentCount'=>'1'),'IMDIV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMDIV','argumentCount'=>'2'),'IMEXP'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMEXP','argumentCount'=>'1'),'IMLN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMLN','argumentCount'=>'1'),'IMLOG10'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMLOG10','argumentCount'=>'1'),'IMLOG2'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMLOG2','argumentCount'=>'1'),'IMPOWER'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMPOWER','argumentCount'=>'2'),'IMPRODUCT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMPRODUCT','argumentCount'=>'1+'),'IMREAL'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMREAL','argumentCount'=>'1'),'IMSIN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMSIN','argumentCount'=>'1'),'IMSQRT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMSQRT','argumentCount'=>'1'),'IMSUB'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMSUB','argumentCount'=>'2'),'IMSUM'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::IMSUM','argumentCount'=>'1+'),'INDEX'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::INDEX','argumentCount'=>'1-4'),'INDIRECT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::INDIRECT','argumentCount'=>'1,2','passCellReference'=>true),'INFO'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'1'),'INT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::INTVALUE','argumentCount'=>'1'),'INTERCEPT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::INTERCEPT','argumentCount'=>'2'),'INTRATE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::INTRATE','argumentCount'=>'4,5'),'IPMT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::IPMT','argumentCount'=>'4-6'),'IRR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::IRR','argumentCount'=>'1,2'),'ISBLANK'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::IS_BLANK','argumentCount'=>'1'),'ISERR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::IS_ERR','argumentCount'=>'1'),'ISERROR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::IS_ERROR','argumentCount'=>'1'),'ISEVEN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::IS_EVEN','argumentCount'=>'1'),'ISLOGICAL'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::IS_LOGICAL','argumentCount'=>'1'),'ISNA'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::IS_NA','argumentCount'=>'1'),'ISNONTEXT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::IS_NONTEXT','argumentCount'=>'1'),'ISNUMBER'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::IS_NUMBER','argumentCount'=>'1'),'ISODD'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::IS_ODD','argumentCount'=>'1'),'ISPMT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::ISPMT','argumentCount'=>'4'),'ISREF'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'1'),'ISTEXT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::IS_TEXT','argumentCount'=>'1'),'JIS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'1'),'KURT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::KURT','argumentCount'=>'1+'),'LARGE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::LARGE','argumentCount'=>'2'),'LCM'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::LCM','argumentCount'=>'1+'),'LEFT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::LEFT','argumentCount'=>'1,2'),'LEFTB'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::LEFT','argumentCount'=>'1,2'),'LEN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::STRINGLENGTH','argumentCount'=>'1'),'LENB'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::STRINGLENGTH','argumentCount'=>'1'),'LINEST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::LINEST','argumentCount'=>'1-4'),'LN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'log','argumentCount'=>'1'),'LOG'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::LOG_BASE','argumentCount'=>'1,2'),'LOG10'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'log10','argumentCount'=>'1'),'LOGEST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::LOGEST','argumentCount'=>'1-4'),'LOGINV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::LOGINV','argumentCount'=>'3'),'LOGNORMDIST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::LOGNORMDIST','argumentCount'=>'3'),'LOOKUP'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::LOOKUP','argumentCount'=>'2,3'),'LOWER'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::LOWERCASE','argumentCount'=>'1'),'MATCH'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::MATCH','argumentCount'=>'2,3'),'MAX'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::MAX','argumentCount'=>'1+'),'MAXA'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::MAXA','argumentCount'=>'1+'),'MAXIF'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'2+'),'MDETERM'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::MDETERM','argumentCount'=>'1'),'MDURATION'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'5,6'),'MEDIAN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::MEDIAN','argumentCount'=>'1+'),'MEDIANIF'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'2+'),'MID'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::MID','argumentCount'=>'3'),'MIDB'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::MID','argumentCount'=>'3'),'MIN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::MIN','argumentCount'=>'1+'),'MINA'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::MINA','argumentCount'=>'1+'),'MINIF'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'2+'),'MINUTE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::MINUTEOFHOUR','argumentCount'=>'1'),'MINVERSE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::MINVERSE','argumentCount'=>'1'),'MIRR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::MIRR','argumentCount'=>'3'),'MMULT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::MMULT','argumentCount'=>'2'),'MOD'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::MOD','argumentCount'=>'2'),'MODE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::MODE','argumentCount'=>'1+'),'MONTH'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::MONTHOFYEAR','argumentCount'=>'1'),'MROUND'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::MROUND','argumentCount'=>'2'),'MULTINOMIAL'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::MULTINOMIAL','argumentCount'=>'1+'),'N'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'1'),'NA'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::NA','argumentCount'=>'0'),'NEGBINOMDIST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::NEGBINOMDIST','argumentCount'=>'3'),'NETWORKDAYS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::NETWORKDAYS','argumentCount'=>'2+'),'NOMINAL'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::NOMINAL','argumentCount'=>'2'),'NORMDIST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::NORMDIST','argumentCount'=>'4'),'NORMINV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::NORMINV','argumentCount'=>'3'),'NORMSDIST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::NORMSDIST','argumentCount'=>'1'),'NORMSINV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::NORMSINV','argumentCount'=>'1'),'NOT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOGICAL,'functionCall'=>'PHPExcel_Calculation_Functions::LOGICAL_NOT','argumentCount'=>'1'),'NOW'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::DATETIMENOW','argumentCount'=>'0'),'NPER'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::NPER','argumentCount'=>'3-5'),'NPV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::NPV','argumentCount'=>'2+'),'OCT2BIN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::OCTTOBIN','argumentCount'=>'1,2'),'OCT2DEC'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::OCTTODEC','argumentCount'=>'1'),'OCT2HEX'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,'functionCall'=>'PHPExcel_Calculation_Functions::OCTTOHEX','argumentCount'=>'1,2'),'ODD'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::ODD','argumentCount'=>'1'),'ODDFPRICE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'8,9'),'ODDFYIELD'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'8,9'),'ODDLPRICE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'7,8'),'ODDLYIELD'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'7,8'),'OFFSET'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::OFFSET','argumentCount'=>'3,5','passCellReference'=>true,'passByReference'=>array(true)),'OR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOGICAL,'functionCall'=>'PHPExcel_Calculation_Functions::LOGICAL_OR','argumentCount'=>'1+'),'PEARSON'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::CORREL','argumentCount'=>'2'),'PERCENTILE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::PERCENTILE','argumentCount'=>'2'),'PERCENTRANK'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::PERCENTRANK','argumentCount'=>'2,3'),'PERMUT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::PERMUT','argumentCount'=>'2'),'PHONETIC'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'1'),'PI'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'pi','argumentCount'=>'0'),'PMT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::PMT','argumentCount'=>'3-5'),'POISSON'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::POISSON','argumentCount'=>'3'),'POWER'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::POWER','argumentCount'=>'2'),'PPMT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::PPMT','argumentCount'=>'4-6'),'PRICE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'6,7'),'PRICEDISC'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::PRICEDISC','argumentCount'=>'4,5'),'PRICEMAT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::PRICEMAT','argumentCount'=>'5,6'),'PROB'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'3,4'),'PRODUCT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::PRODUCT','argumentCount'=>'1+'),'PROPER'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::PROPERCASE','argumentCount'=>'1'),'PV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::PV','argumentCount'=>'3-5'),'QUARTILE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::QUARTILE','argumentCount'=>'2'),'QUOTIENT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::QUOTIENT','argumentCount'=>'2'),'RADIANS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'deg2rad','argumentCount'=>'1'),'RAND'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::RAND','argumentCount'=>'0'),'RANDBETWEEN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::RAND','argumentCount'=>'2'),'RANK'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::RANK','argumentCount'=>'2,3'),'RATE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::RATE','argumentCount'=>'3-6'),'RECEIVED'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::RECEIVED','argumentCount'=>'4-5'),'REPLACE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::REPLACE','argumentCount'=>'4'),'REPLACEB'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::REPLACE','argumentCount'=>'4'),'REPT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'str_repeat','argumentCount'=>'2'),'RIGHT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::RIGHT','argumentCount'=>'1,2'),'RIGHTB'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::RIGHT','argumentCount'=>'1,2'),'ROMAN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::ROMAN','argumentCount'=>'1,2'),'ROUND'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'round','argumentCount'=>'2'),'ROUNDDOWN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::ROUNDDOWN','argumentCount'=>'2'),'ROUNDUP'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::ROUNDUP','argumentCount'=>'2'),'ROW'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::ROW','argumentCount'=>'-1','passByReference'=>array(true)),'ROWS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::ROWS','argumentCount'=>'1'),'RSQ'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::RSQ','argumentCount'=>'2'),'RTD'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'1+'),'SEARCH'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::SEARCHINSENSITIVE','argumentCount'=>'2,3'),'SEARCHB'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::SEARCHINSENSITIVE','argumentCount'=>'2,3'),'SECOND'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::SECONDOFMINUTE','argumentCount'=>'1'),'SERIESSUM'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::SERIESSUM','argumentCount'=>'4'),'SIGN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::SIGN','argumentCount'=>'1'),'SIN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'sin','argumentCount'=>'1'),'SINH'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'sinh','argumentCount'=>'1'),'SKEW'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::SKEW','argumentCount'=>'1+'),'SLN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::SLN','argumentCount'=>'3'),'SLOPE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::SLOPE','argumentCount'=>'2'),'SMALL'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::SMALL','argumentCount'=>'2'),'SQRT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'sqrt','argumentCount'=>'1'),'SQRTPI'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::SQRTPI','argumentCount'=>'1'),'STANDARDIZE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::STANDARDIZE','argumentCount'=>'3'),'STDEV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::STDEV','argumentCount'=>'1+'),'STDEVA'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::STDEVA','argumentCount'=>'1+'),'STDEVP'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::STDEVP','argumentCount'=>'1+'),'STDEVPA'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::STDEVPA','argumentCount'=>'1+'),'STEYX'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::STEYX','argumentCount'=>'2'),'SUBSTITUTE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::SUBSTITUTE','argumentCount'=>'3,4'),'SUBTOTAL'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::SUBTOTAL','argumentCount'=>'2+'),'SUM'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::SUM','argumentCount'=>'1+'),'SUMIF'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::SUMIF','argumentCount'=>'2,3'),'SUMIFS'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'?'),'SUMPRODUCT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::SUMPRODUCT','argumentCount'=>'1+'),'SUMSQ'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::SUMSQ','argumentCount'=>'1+'),'SUMX2MY2'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::SUMX2MY2','argumentCount'=>'2'),'SUMX2PY2'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::SUMX2PY2','argumentCount'=>'2'),'SUMXMY2'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::SUMXMY2','argumentCount'=>'2'),'SYD'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::SYD','argumentCount'=>'4'),'T'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::RETURNSTRING','argumentCount'=>'1'),'TAN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'tan','argumentCount'=>'1'),'TANH'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'tanh','argumentCount'=>'1'),'TBILLEQ'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::TBILLEQ','argumentCount'=>'3'),'TBILLPRICE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::TBILLPRICE','argumentCount'=>'3'),'TBILLYIELD'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::TBILLYIELD','argumentCount'=>'3'),'TDIST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::TDIST','argumentCount'=>'3'),'TEXT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::TEXTFORMAT','argumentCount'=>'2'),'TIME'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::TIME','argumentCount'=>'3'),'TIMEVALUE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::TIMEVALUE','argumentCount'=>'1'),'TINV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::TINV','argumentCount'=>'2'),'TODAY'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::DATENOW','argumentCount'=>'0'),'TRANSPOSE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::TRANSPOSE','argumentCount'=>'1'),'TREND'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::TREND','argumentCount'=>'1-4'),'TRIM'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::TRIMSPACES','argumentCount'=>'1'),'TRIMMEAN'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::TRIMMEAN','argumentCount'=>'2'),'TRUE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOGICAL,'functionCall'=>'PHPExcel_Calculation_Functions::LOGICAL_TRUE','argumentCount'=>'0'),'TRUNC'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,'functionCall'=>'PHPExcel_Calculation_Functions::TRUNC','argumentCount'=>'1,2'),'TTEST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'4'),'TYPE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'1'),'UPPER'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::UPPERCASE','argumentCount'=>'1'),'USDOLLAR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'2'),'VALUE'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'1'),'VAR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::VARFunc','argumentCount'=>'1+'),'VARA'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::VARA','argumentCount'=>'1+'),'VARP'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::VARP','argumentCount'=>'1+'),'VARPA'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::VARPA','argumentCount'=>'1+'),'VDB'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'5-7'),'VERSION'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_INFORMATION,'functionCall'=>'PHPExcel_Calculation_Functions::VERSION','argumentCount'=>'0'),'VLOOKUP'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,'functionCall'=>'PHPExcel_Calculation_Functions::VLOOKUP','argumentCount'=>'3,4'),'WEEKDAY'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::DAYOFWEEK','argumentCount'=>'1,2'),'WEEKNUM'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::WEEKOFYEAR','argumentCount'=>'1,2'),'WEIBULL'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::WEIBULL','argumentCount'=>'4'),'WORKDAY'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::WORKDAY','argumentCount'=>'2+'),'XIRR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::XIRR','argumentCount'=>'2,3'),'XNPV'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::XNPV','argumentCount'=>'3'),'YEAR'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::YEAR','argumentCount'=>'1'),'YEARFRAC'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,'functionCall'=>'PHPExcel_Calculation_Functions::YEARFRAC','argumentCount'=>'2,3'),'YIELD'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::DUMMY','argumentCount'=>'6,7'),'YIELDDISC'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::YIELDDISC','argumentCount'=>'4,5'),'YIELDMAT'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,'functionCall'=>'PHPExcel_Calculation_Functions::YIELDMAT','argumentCount'=>'5,6'),'ZTEST'=>array('category'=>PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,'functionCall'=>'PHPExcel_Calculation_Functions::ZTEST','argumentCount'=>'2-3'))

[line 148]

Tags:

access:

private

Type:

mixed

[ Top ]

static method getArrayReturnType [line 1641]

static string getArrayReturnType(
)

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

Tags:

return:	Array return type
access:	public

[ Top ]

static method getInstance [line 1597]

static PHPExcel_Calculation getInstance(
)

Get an instance of this class

Tags:

access:

public

[ Top ]

static method setArrayReturnType [line 1624]

static boolean setArrayReturnType(
string
$returnType)

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

Tags:

return:	Success or failure
access:	public

Parameters:

string

$returnType

Array return type

[ Top ]

static method _checkMatrixOperands [line 1963]

static void _checkMatrixOperands(
mixed
&$operand1, mixed
&$operand2, [integer
$resize = 1])

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

Tags:

access:

private

Parameters:

mixed	&$operand1	First matrix operand
mixed	&$operand2	Second matrix operand
integer	$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. = no resize = shrink to fit = extend to fit

[ Top ]

static method _convertMatrixReferences [line 2165]

static void _convertMatrixReferences(

$formula)

Tags:

access:

private

Parameters:

$formula

[ Top ]

static method _getMatrixDimensions [line 1998]

static array _getMatrixDimensions(
mixed
&$matrix)

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

Tags:

return:	An array comprising the number of rows, and number of columns
access:	public

Parameters:

mixed

&$matrix

matrix operand

[ Top ]

static method _mkMatrix [line 2215]

static void _mkMatrix(
)

Tags:

access:

private

[ Top ]

static method _resizeMatricesExtend [line 2061]

static void _resizeMatricesExtend(
mixed
&$matrix1, mixed
&$matrix2)

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

Tags:

access:

private

Parameters:

mixed	&$matrix1	First matrix operand
mixed	&$matrix2	Second matrix operand

[ Top ]

static method _resizeMatricesShrink [line 2019]

static void _resizeMatricesShrink(
mixed
&$matrix1, mixed
&$matrix2)

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

Tags:

access:

private

Parameters:

mixed	&$matrix1	First matrix operand
mixed	&$matrix2	Second matrix operand

[ Top ]

static method _showTypeDetails [line 2134]

static mixed _showTypeDetails(
mixed
$value)

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

Tags:

access:

private

Parameters:

mixed

$value

First matrix operand

[ Top ]

static method _showValue [line 2107]

static mixed _showValue(
mixed
$value)

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

Tags:

access:

private

Parameters:

mixed

$value

First matrix operand

[ Top ]

static method _unwrapResult [line 1745]

static mixed _unwrapResult(
mixed
$value)

Remove quotes used as a wrapper to identify string values

Tags:

access:

public

Parameters:

mixed

$value

[ Top ]

static method _wrapResult [line 1721]

static mixed _wrapResult(
mixed
$value)

Wrap string values in quotes

Tags:

access:

public

Parameters:

mixed

$value

[ Top ]

method calculate [line 1769]

mixed calculate(
[
$pCell = null])

Calculate cell value (using formula from a cell ID)

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

Tags:

throws:	Exception
access:	public

Parameters:

PHPExcel_Cell

$pCell

Cell to calculate

[ Top ]

method calculateCellValue [line 1783]

mixed calculateCellValue(
[
$pCell = null], [Boolean
$resetLog = true])

Calculate the value of a cell formula

Tags:

throws:	Exception
access:	public

Parameters:

PHPExcel_Cell	$pCell	Cell to calculate
Boolean	$resetLog	Flag indicating whether the debug log should be reset or not

[ Top ]

method calculateFormula [line 1861]

mixed calculateFormula(
string
$formula, [
$cellID = null], [
$pCell = null])

Calculate the value of a formula

Tags:

throws:	Exception
access:	public

Parameters:

string	$formula	Formula to parse
	$cellID
PHPExcel_Cell	$pCell

[ Top ]

method clearCalculationCache [line 1688]

void clearCalculationCache(
)

Clear calculation cache

Tags:

access:

public

[ Top ]

method disableCalculationCache [line 1680]

void disableCalculationCache(
)

Disable calculation cache

Tags:

access:

public

[ Top ]

method enableCalculationCache [line 1672]

void enableCalculationCache(
)

Enable calculation cache

Tags:

access:

public

[ Top ]

method extractCellRange [line 3080]

mixed extractCellRange(
[string
&$pRange = 'A1'], [
$pSheet = null], [
$resetLog = true])

Extract range values

Tags:

return:	Array of values in range if range contains more than one element. Otherwise, a single value is returned.
throws:	Exception
access:	public

Parameters:

string	&$pRange	String based range representation
PHPExcel_Worksheet	$pSheet	Worksheet
	$resetLog

[ Top ]

method extractNamedRange [line 3135]

mixed extractNamedRange(
[string
&$pRange = 'A1'], [
$pSheet = null], [
$resetLog = true])

Extract range values

Tags:

return:	Array of values in range if range contains more than one element. Otherwise, a single value is returned.
throws:	Exception
access:	public

Parameters:

string	&$pRange	String based range representation
PHPExcel_Worksheet	$pSheet	Worksheet
	$resetLog

[ Top ]

method getCalculationCacheEnabled [line 1652]

boolean getCalculationCacheEnabled(
)

Is calculation caching enabled?

Tags:

access:

public

[ Top ]

method getCalculationCacheExpirationTime [line 1698]

float getCalculationCacheExpirationTime(
)

Get calculation cache expiration time

Tags:

access:

public

[ Top ]

method isImplemented [line 3206]

boolean isImplemented(
[string
$pFunction = ''])

Is a specific function implemented?

Tags:

access:

public

Parameters:

string

$pFunction

Function Name

[ Top ]

method listFunctionNames [line 3244]

array listFunctionNames(
)

Get a list of implemented Excel function names

Tags:

access:

public

[ Top ]

method listFunctions [line 3221]

array listFunctions(
)

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

Tags:

return:	of PHPExcel_Calculation_Function
access:	public

[ Top ]

method parseFormula [line 1840]

array parseFormula(
string
$formula)

Validate and parse a formula string

Tags:

throws:	Exception
access:	public

Parameters:

string

$formula

Formula to parse

[ Top ]

method setCalculationCacheEnabled [line 1663]

void setCalculationCacheEnabled(
[boolean
$pValue = true])

Enable/disable calculation cache

Tags:

access:

public

Parameters:

boolean

$pValue

[ Top ]

method setCalculationCacheExpirationTime [line 1708]

void setCalculationCacheExpirationTime(
[float
$pValue = 2.5])

Set calculation cache expiration time

Tags:

access:

public

Parameters:

float

$pValue

[ Top ]

method _calculateFormulaValue [line 1888]

mixed _calculateFormulaValue(
string
$formula, [string
$cellID = null], [
$pCell = null])

Parse a cell formula and calculate its value

Tags:

throws:	Exception
access:	public

Parameters:

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

[ Top ]

method _executeBinaryComparisonOperation [line 2919]

void _executeBinaryComparisonOperation(

$cellID, 
$operand1, 
$operand2, 
$operation, 
&$stack, [
$recursingArrays = false])

Tags:

access:

private

Parameters:

	$cellID
	$operand1
	$operand2
	$operation
	&$stack
	$recursingArrays

[ Top ]

method _executeNumericBinaryOperation [line 2993]

void _executeNumericBinaryOperation(

$cellID, 
$operand1, 
$operand2, 
$operation, 
$matrixFunction, 
&$stack)

Tags:

access:

private

Parameters:

	$cellID
	$operand1
	$operand2
	$operation
	$matrixFunction
	&$stack

[ Top ]

method _parseFormula [line 2221]

void _parseFormula(

$formula)

Tags:

access:

private

Parameters:

$formula

[ Top ]

method _processTokenStack [line 2532]

void _processTokenStack(

$tokens, [
$cellID = null], [
$pCell = null])

Tags:

access:

private

Parameters:

	$tokens
	$cellID
PHPExcel_Cell	$pCell

[ Top ]

method _raiseFormulaError [line 3064]

void _raiseFormulaError(

$errorMessage)

Tags:

access:

private

Parameters:

$errorMessage

[ Top ]

method _validateBinaryOperand [line 2892]

void _validateBinaryOperand(

$cellID, 
&$operand, 
&$stack)

Tags:

access:

private

Parameters:

	$cellID
	&$operand
	&$stack

[ Top ]

method _writeDebug [line 3055]

void _writeDebug(

$message)

Tags:

access:

private

Parameters:

$message

[ Top ]

method __clone [line 1612]

void __clone(
)

__clone implementation.

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

Tags:

throws:	Exception
access:	public

[ Top ]

Class: PHPExcel_Calculation

Class Overview

Author(s):

Copyright:

Variables

Constants

Methods

Class Details

Tags:

Class Variables

static $returnArrayAsType = self::RETURN_ARRAY_AS_VALUE

Tags:

static $_instance =

Tags:

$debugLog = array()

Tags:

$debugLogStack = array()

Tags:

$formulaError = null

Tags:

$suppressFormulaErrors = false

Tags:

$writeDebugLog = false

Tags:

$_binaryOperators = array('+', '-', '*', '/', '^', '&', '>', '<', '=', '>=', '<=', '<>', '|', ':')

Tags:

$_calculationCache = array ()

Tags:

$_calculationCacheEnabled = true

Tags:

$_calculationCacheExpirationTime = 2.5

Tags:

$_controlFunctions = array( 'MKMATRIX' => array('argumentCount' => '*', 'functionCall' => 'self::_mkMatrix' ))

Tags:

$_ExcelConstants = array('TRUE' => True, 'FALSE' => False, 'NULL' => Null )

Tags:

$_operators = array('+', '-', '*', '/', '^', '&', '%', '~', '>', '<', '=', '>=', '<=', '<>', '|', ':')

Tags:

Tags:

Class Methods

static method getArrayReturnType [line 1641]

Tags:

static method getInstance [line 1597]

Tags:

static method setArrayReturnType [line 1624]

Tags:

Parameters:

static method _checkMatrixOperands [line 1963]

Tags:

Parameters:

static method _convertMatrixReferences [line 2165]

Tags:

Parameters:

static method _getMatrixDimensions [line 1998]

Tags:

Parameters:

static method _mkMatrix [line 2215]

Tags:

static method _resizeMatricesExtend [line 2061]

Tags:

Parameters:

static method _resizeMatricesShrink [line 2019]

Tags:

Parameters:

static method _showTypeDetails [line 2134]

Tags:

Parameters:

static method _showValue [line 2107]

Tags:

Parameters:

static method _unwrapResult [line 1745]

Tags:

Parameters:

static method _wrapResult [line 1721]

Tags:

Parameters:

method calculate [line 1769]

Tags:

Parameters:

method calculateCellValue [line 1783]

$_controlFunctions = array(
'MKMATRIX' => array('argumentCount' => '*',
'functionCall' => 'self::_mkMatrix'
))

$_ExcelConstants = array('TRUE' => True,
'FALSE' => False,
'NULL' => Null
)

CALCULATION_REGEXP_CELLREF = '(((\w)|(\'[^\']\')|(\"[^\"]*\"))!)?\$?([a-z]+)\$?(\d+)'

CALCULATION_REGEXP_FUNCTION = '@?([A-Z][A-Z0-9\.])[\s]\('

CALCULATION_REGEXP_NAMEDRANGE = '(((\w)|(\'.\')|(\".\"))!)?([_A-Z][_A-Z0-9])'