Package PHPExcel_Calculation Element Index

PHPExcel_Calculation

# Element index for package PHPExcel_Calculation

[ a ] [ b ] [ c ] [ d ] [ e ] [ f ] [ g ] [ h ] [ i ] [ k ] [ l ] [ m ] [ n ] [ o ] [ p ] [ q ] [ r ] [ s ] [ t ] [ u ] [ v ] [ w ] [ x ] [ y ] [ z ] [ _ ]

## _

$_errorCodes
  in file Functions.php, variable PHPExcel_Calculation_Functions::$_errorCodes
  List of error codes
$_localeBoolean
  in file Calculation.php, variable PHPExcel_Calculation::$_localeBoolean
_calculateFormulaValue
  in file Calculation.php, method PHPExcel_Calculation::_calculateFormulaValue()
  Parse a cell formula and calculate its value
_erfVal
  in file Engineering.php, method PHPExcel_Calculation_Engineering::_erfVal()
_getDateValue
  in file DateTime.php, method PHPExcel_Calculation_DateTime::_getDateValue()
  _getDateValue
_getMatrixDimensions
  in file Calculation.php, method PHPExcel_Calculation::_getMatrixDimensions()
  Read the dimensions of a matrix, and re-index it with straight numeric keys starting from row 0, column 0
_ifCondition
  in file Functions.php, method PHPExcel_Calculation_Functions::_ifCondition()
_isLeapYear
  in file DateTime.php, method PHPExcel_Calculation_DateTime::_isLeapYear()
_localeFunc
  in file Calculation.php, method PHPExcel_Calculation::_localeFunc()
_parseComplex
  in file Engineering.php, method PHPExcel_Calculation_Engineering::_parseComplex()
_raiseFormulaError
  in file Calculation.php, method PHPExcel_Calculation::_raiseFormulaError()
_translateFormulaToEnglish
  in file Calculation.php, method PHPExcel_Calculation::_translateFormulaToEnglish()
_translateFormulaToLocale
  in file Calculation.php, method PHPExcel_Calculation::_translateFormulaToLocale()
_translateSeparator
  in file Calculation.php, method PHPExcel_Calculation::_translateSeparator()
_unwrapResult
  in file Calculation.php, method PHPExcel_Calculation::_unwrapResult()
  Remove quotes used as a wrapper to identify string values
_wrapResult
  in file Calculation.php, method PHPExcel_Calculation::_wrapResult()
  Wrap string values in quotes
__clone
  in file Calculation.php, method PHPExcel_Calculation::__clone()
  __clone implementation. Cloning should not be allowed in a Singleton!
__construct
  in file Function.php, method PHPExcel_Calculation_Function::__construct()
  Create a new PHPExcel_Calculation_Function
__construct
  in file Calculation.php, method PHPExcel_Token_Stack::__construct()
__construct
  in file ExceptionHandler.php, method PHPExcel_Calculation_ExceptionHandler::__construct()
  Register errorhandler
__construct
  in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::__construct()
  Create a new PHPExcel_Calculation_FormulaToken
__construct
  in file FormulaParser.php, method PHPExcel_Calculation_FormulaParser::__construct()
  Create a new PHPExcel_Calculation_FormulaParser
__destruct
  in file Calculation.php, method PHPExcel_Calculation::__destruct()
__destruct
  in file ExceptionHandler.php, method PHPExcel_Calculation_ExceptionHandler::__destruct()
  Unregister errorhandler

top

## a

ACCRINT
  in file Financial.php, method PHPExcel_Calculation_Financial::ACCRINT()
  ACCRINT
ACCRINTM
  in file Financial.php, method PHPExcel_Calculation_Financial::ACCRINTM()
  ACCRINTM
acosh
  in file Functions.php, function acosh()
AMORDEGRC
  in file Financial.php, method PHPExcel_Calculation_Financial::AMORDEGRC()
AMORLINC
  in file Financial.php, method PHPExcel_Calculation_Financial::AMORLINC()
ASCIICODE
  in file TextData.php, method PHPExcel_Calculation_TextData::ASCIICODE()
  ASCIICODE
asinh
  in file Functions.php, function asinh()
ATAN2
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::ATAN2()
  ATAN2
atanh
  in file Functions.php, function atanh()
AVEDEV
  in file Statistical.php, method PHPExcel_Calculation_Statistical::AVEDEV()
  AVEDEV
AVERAGE
  in file Statistical.php, method PHPExcel_Calculation_Statistical::AVERAGE()
  AVERAGE
AVERAGEA
  in file Statistical.php, method PHPExcel_Calculation_Statistical::AVERAGEA()
  AVERAGEA
AVERAGEIF
  in file Statistical.php, method PHPExcel_Calculation_Statistical::AVERAGEIF()
  AVERAGEIF

top

## b

BESSELI
  in file Engineering.php, method PHPExcel_Calculation_Engineering::BESSELI()
  BESSELI
BESSELJ
  in file Engineering.php, method PHPExcel_Calculation_Engineering::BESSELJ()
  BESSELJ
BESSELK
  in file Engineering.php, method PHPExcel_Calculation_Engineering::BESSELK()
  BESSELK
BESSELY
  in file Engineering.php, method PHPExcel_Calculation_Engineering::BESSELY()
  BESSELY
BETADIST
  in file Statistical.php, method PHPExcel_Calculation_Statistical::BETADIST()
  BETADIST
BETAINV
  in file Statistical.php, method PHPExcel_Calculation_Statistical::BETAINV()
  BETAINV
BINOMDIST
  in file Statistical.php, method PHPExcel_Calculation_Statistical::BINOMDIST()
  BINOMDIST
BINTODEC
  in file Engineering.php, method PHPExcel_Calculation_Engineering::BINTODEC()
  BINTODEC
BINTOHEX
  in file Engineering.php, method PHPExcel_Calculation_Engineering::BINTOHEX()
  BINTOHEX
BINTOOCT
  in file Engineering.php, method PHPExcel_Calculation_Engineering::BINTOOCT()
  BINTOOCT
BRACE_CLOSE
  in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::BRACE_CLOSE
BRACE_OPEN
  in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::BRACE_OPEN
BRACKET_CLOSE
  in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::BRACKET_CLOSE
BRACKET_OPEN
  in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::BRACKET_OPEN

top

## c

$compatibilityMode
  in file Functions.php, variable PHPExcel_Calculation_Functions::$compatibilityMode
  Compatibility mode to use for error checking and responses
$cyclicFormulaCount
  in file Calculation.php, variable PHPExcel_Calculation::$cyclicFormulaCount
calculate
  in file Calculation.php, method PHPExcel_Calculation::calculate()
  Calculate cell value (using formula from a cell ID) Retained for backward compatibility
calculateCellValue
  in file Calculation.php, method PHPExcel_Calculation::calculateCellValue()
  Calculate the value of a cell formula
calculateFormula
  in file Calculation.php, method PHPExcel_Calculation::calculateFormula()
  Calculate the value of a formula
CALCULATION_REGEXP_CELLREF
  in file Calculation.php, class constant PHPExcel_Calculation::CALCULATION_REGEXP_CELLREF
CALCULATION_REGEXP_CELLREF
  in file Calculation.php, constant CALCULATION_REGEXP_CELLREF
CALCULATION_REGEXP_ERROR
  in file Calculation.php, class constant PHPExcel_Calculation::CALCULATION_REGEXP_ERROR
CALCULATION_REGEXP_FUNCTION
  in file Calculation.php, class constant PHPExcel_Calculation::CALCULATION_REGEXP_FUNCTION
CALCULATION_REGEXP_NAMEDRANGE
  in file Calculation.php, class constant PHPExcel_Calculation::CALCULATION_REGEXP_NAMEDRANGE
CALCULATION_REGEXP_NAMEDRANGE
  in file Calculation.php, constant CALCULATION_REGEXP_NAMEDRANGE
CALCULATION_REGEXP_NUMBER
  in file Calculation.php, class constant PHPExcel_Calculation::CALCULATION_REGEXP_NUMBER
  Regular Expressions
CALCULATION_REGEXP_OPENBRACE
  in file Calculation.php, class constant PHPExcel_Calculation::CALCULATION_REGEXP_OPENBRACE
CALCULATION_REGEXP_STRING
  in file Calculation.php, class constant PHPExcel_Calculation::CALCULATION_REGEXP_STRING
CATEGORY_CUBE
  in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_CUBE
CATEGORY_DATABASE
  in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_DATABASE
CATEGORY_DATE_AND_TIME
  in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME
CATEGORY_ENGINEERING
  in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_ENGINEERING
CATEGORY_FINANCIAL
  in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_FINANCIAL
CATEGORY_INFORMATION
  in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_INFORMATION
CATEGORY_LOGICAL
  in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_LOGICAL
CATEGORY_LOOKUP_AND_REFERENCE
  in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE
CATEGORY_MATH_AND_TRIG
  in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG
CATEGORY_STATISTICAL
  in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_STATISTICAL
CATEGORY_TEXT_AND_DATA
  in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA
CEILING
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::CEILING()
  CEILING
CELL_ADDRESS
  in file LookupRef.php, method PHPExcel_Calculation_LookupRef::CELL_ADDRESS()
  CELL_ADDRESS
CHARACTER
  in file TextData.php, method PHPExcel_Calculation_TextData::CHARACTER()
  CHARACTER
CHIDIST
  in file Statistical.php, method PHPExcel_Calculation_Statistical::CHIDIST()
  CHIDIST
CHIINV
  in file Statistical.php, method PHPExcel_Calculation_Statistical::CHIINV()
  CHIINV
CHOOSE
  in file LookupRef.php, method PHPExcel_Calculation_LookupRef::CHOOSE()
clearCalculationCache
  in file Calculation.php, method PHPExcel_Calculation::clearCalculationCache()
  Clear calculation cache
COLUMN
  in file LookupRef.php, method PHPExcel_Calculation_LookupRef::COLUMN()
  COLUMN
COLUMNS
  in file LookupRef.php, method PHPExcel_Calculation_LookupRef::COLUMNS()
  COLUMNS
COMBIN
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::COMBIN()
  COMBIN
COMMA
  in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::COMMA
COMPATIBILITY_EXCEL
  in file Functions.php, class constant PHPExcel_Calculation_Functions::COMPATIBILITY_EXCEL
  constants
COMPATIBILITY_GNUMERIC
  in file Functions.php, class constant PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC
COMPATIBILITY_OPENOFFICE
  in file Functions.php, class constant PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE
COMPLEX
  in file Engineering.php, method PHPExcel_Calculation_Engineering::COMPLEX()
  COMPLEX
CONCATENATE
  in file TextData.php, method PHPExcel_Calculation_TextData::CONCATENATE()
  CONCATENATE
CONFIDENCE
  in file Statistical.php, method PHPExcel_Calculation_Statistical::CONFIDENCE()
  CONFIDENCE
CONVERTUOM
  in file Engineering.php, method PHPExcel_Calculation_Engineering::CONVERTUOM()
  CONVERTUOM
CORREL
  in file Statistical.php, method PHPExcel_Calculation_Statistical::CORREL()
  CORREL
COUNT
  in file Statistical.php, method PHPExcel_Calculation_Statistical::COUNT()
  COUNT
count
  in file Calculation.php, method PHPExcel_Token_Stack::count()
COUNTA
  in file Statistical.php, method PHPExcel_Calculation_Statistical::COUNTA()
  COUNTA
COUNTBLANK
  in file Statistical.php, method PHPExcel_Calculation_Statistical::COUNTBLANK()
  COUNTBLANK
COUNTIF
  in file Statistical.php, method PHPExcel_Calculation_Statistical::COUNTIF()
  COUNTIF
COUPDAYBS
  in file Financial.php, method PHPExcel_Calculation_Financial::COUPDAYBS()
COUPDAYS
  in file Financial.php, method PHPExcel_Calculation_Financial::COUPDAYS()
COUPDAYSNC
  in file Financial.php, method PHPExcel_Calculation_Financial::COUPDAYSNC()
COUPNCD
  in file Financial.php, method PHPExcel_Calculation_Financial::COUPNCD()
COUPNUM
  in file Financial.php, method PHPExcel_Calculation_Financial::COUPNUM()
COUPPCD
  in file Financial.php, method PHPExcel_Calculation_Financial::COUPPCD()
COVAR
  in file Statistical.php, method PHPExcel_Calculation_Statistical::COVAR()
  COVAR
CRITBINOM
  in file Statistical.php, method PHPExcel_Calculation_Statistical::CRITBINOM()
  CRITBINOM
CUMIPMT
  in file Financial.php, method PHPExcel_Calculation_Financial::CUMIPMT()
  CUMIPMT
CUMPRINC
  in file Financial.php, method PHPExcel_Calculation_Financial::CUMPRINC()
  CUMPRINC
Calculation.php
  procedural page Calculation.php

top

## d

$debugLog
  in file Calculation.php, variable PHPExcel_Calculation::$debugLog
  The debug log generated by the calculation engine
DATE
  in file DateTime.php, method PHPExcel_Calculation_DateTime::DATE()
  DATE
DATEDIF
  in file DateTime.php, method PHPExcel_Calculation_DateTime::DATEDIF()
  DATEDIF
DATENOW
  in file DateTime.php, method PHPExcel_Calculation_DateTime::DATENOW()
  DATENOW
DATETIMENOW
  in file DateTime.php, method PHPExcel_Calculation_DateTime::DATETIMENOW()
  DATETIMENOW
DATEVALUE
  in file DateTime.php, method PHPExcel_Calculation_DateTime::DATEVALUE()
  DATEVALUE
DAVERAGE
  in file Database.php, method PHPExcel_Calculation_Database::DAVERAGE()
  DAVERAGE
DAYOFMONTH
  in file DateTime.php, method PHPExcel_Calculation_DateTime::DAYOFMONTH()
  DAYOFMONTH
DAYOFWEEK
  in file DateTime.php, method PHPExcel_Calculation_DateTime::DAYOFWEEK()
  DAYOFWEEK
DAYS360
  in file DateTime.php, method PHPExcel_Calculation_DateTime::DAYS360()
  DAYS360
DB
  in file Financial.php, method PHPExcel_Calculation_Financial::DB()
  DB
DCOUNT
  in file Database.php, method PHPExcel_Calculation_Database::DCOUNT()
  DCOUNT
DCOUNTA
  in file Database.php, method PHPExcel_Calculation_Database::DCOUNTA()
  DCOUNTA
DDB
  in file Financial.php, method PHPExcel_Calculation_Financial::DDB()
  DDB
DECTOBIN
  in file Engineering.php, method PHPExcel_Calculation_Engineering::DECTOBIN()
  DECTOBIN
DECTOHEX
  in file Engineering.php, method PHPExcel_Calculation_Engineering::DECTOHEX()
  DECTOHEX
DECTOOCT
  in file Engineering.php, method PHPExcel_Calculation_Engineering::DECTOOCT()
  DECTOOCT
DELTA
  in file Engineering.php, method PHPExcel_Calculation_Engineering::DELTA()
  DELTA
DEVSQ
  in file Statistical.php, method PHPExcel_Calculation_Statistical::DEVSQ()
  DEVSQ
DGET
  in file Database.php, method PHPExcel_Calculation_Database::DGET()
  DGET
disableCalculationCache
  in file Calculation.php, method PHPExcel_Calculation::disableCalculationCache()
  Disable calculation cache
DISC
  in file Financial.php, method PHPExcel_Calculation_Financial::DISC()
  DISC
DIV0
  in file Functions.php, method PHPExcel_Calculation_Functions::DIV0()
  DIV0
DMAX
  in file Database.php, method PHPExcel_Calculation_Database::DMAX()
  DMAX
DMIN
  in file Database.php, method PHPExcel_Calculation_Database::DMIN()
  DMIN
DOLLAR
  in file TextData.php, method PHPExcel_Calculation_TextData::DOLLAR()
  DOLLAR
DOLLARDE
  in file Financial.php, method PHPExcel_Calculation_Financial::DOLLARDE()
  DOLLARDE
DOLLARFR
  in file Financial.php, method PHPExcel_Calculation_Financial::DOLLARFR()
  DOLLARFR
DPRODUCT
  in file Database.php, method PHPExcel_Calculation_Database::DPRODUCT()
  DPRODUCT
DSTDEV
  in file Database.php, method PHPExcel_Calculation_Database::DSTDEV()
  DSTDEV
DSTDEVP
  in file Database.php, method PHPExcel_Calculation_Database::DSTDEVP()
  DSTDEVP
DSUM
  in file Database.php, method PHPExcel_Calculation_Database::DSUM()
  DSUM
DUMMY
  in file Functions.php, method PHPExcel_Calculation_Functions::DUMMY()
  DUMMY
DVAR
  in file Database.php, method PHPExcel_Calculation_Database::DVAR()
  DVAR
DVARP
  in file Database.php, method PHPExcel_Calculation_Database::DVARP()
  DVARP
Database.php
  procedural page Database.php
DateTime.php
  procedural page DateTime.php

top

## e

$echoDebugLog
  in file Calculation.php, variable PHPExcel_Calculation::$echoDebugLog
  Flag to determine whether a debug log should be echoed by the calculation engine
EDATE
  in file DateTime.php, method PHPExcel_Calculation_DateTime::EDATE()
  EDATE
EFFECT
  in file Financial.php, method PHPExcel_Calculation_Financial::EFFECT()
  EFFECT
enableCalculationCache
  in file Calculation.php, method PHPExcel_Calculation::enableCalculationCache()
  Enable calculation cache
EOMONTH
  in file DateTime.php, method PHPExcel_Calculation_DateTime::EOMONTH()
  EOMONTH
EPS
  in file Statistical.php, constant EPS
  EPS
ERF
  in file Engineering.php, method PHPExcel_Calculation_Engineering::ERF()
  ERF
ERFC
  in file Engineering.php, method PHPExcel_Calculation_Engineering::ERFC()
  ERFC
errorHandlerCallback
  in file Exception.php, method PHPExcel_Calculation_Exception::errorHandlerCallback()
  Error handler callback
ERROR_START
  in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::ERROR_START
ERROR_TYPE
  in file Functions.php, method PHPExcel_Calculation_Functions::ERROR_TYPE()
  ERROR_TYPE
EULER
  in file Engineering.php, constant EULER
  EULER
EVEN
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::EVEN()
  EVEN
EXPONDIST
  in file Statistical.php, method PHPExcel_Calculation_Statistical::EXPONDIST()
  EXPONDIST
extractCellRange
  in file Calculation.php, method PHPExcel_Calculation::extractCellRange()
  Extract range values
extractNamedRange
  in file Calculation.php, method PHPExcel_Calculation::extractNamedRange()
  Extract range values
Engineering.php
  procedural page Engineering.php
Exception.php
  procedural page Exception.php
ExceptionHandler.php
  procedural page ExceptionHandler.php

top

## f

$formulaError
  in file Calculation.php, variable PHPExcel_Calculation::$formulaError
  Error message for any error that was raised/thrown by the calculation engine
FACT
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::FACT()
  FACT
FACTDOUBLE
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::FACTDOUBLE()
  FACTDOUBLE
FALSE
  in file Logical.php, method PHPExcel_Calculation_Logical::FALSE()
  FALSE
FINANCIAL_MAX_ITERATIONS
  in file Financial.php, constant FINANCIAL_MAX_ITERATIONS
  FINANCIAL_MAX_ITERATIONS
FINANCIAL_PRECISION
  in file Financial.php, constant FINANCIAL_PRECISION
  FINANCIAL_PRECISION
FISHER
  in file Statistical.php, method PHPExcel_Calculation_Statistical::FISHER()
  FISHER
FISHERINV
  in file Statistical.php, method PHPExcel_Calculation_Statistical::FISHERINV()
  FISHERINV
FIXEDFORMAT
  in file TextData.php, method PHPExcel_Calculation_TextData::FIXEDFORMAT()
  FIXEDFORMAT
flattenArray
  in file Functions.php, method PHPExcel_Calculation_Functions::flattenArray()
  Convert a multi-dimensional array to a simple 1-dimensional array
flattenArrayIndexed
  in file Functions.php, method PHPExcel_Calculation_Functions::flattenArrayIndexed()
  Convert a multi-dimensional array to a simple 1-dimensional array, but retain an element of indexing
flattenSingleValue
  in file Functions.php, method PHPExcel_Calculation_Functions::flattenSingleValue()
  Convert an array to a single scalar value by extracting the first element
FLOOR
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::FLOOR()
  FLOOR
flushInstance
  in file Calculation.php, method PHPExcel_Calculation::flushInstance()
  Flush the calculation cache for any existing instance of this class but only if a PHPExcel_Calculation instance exists
FORECAST
  in file Statistical.php, method PHPExcel_Calculation_Statistical::FORECAST()
  FORECAST
FV
  in file Financial.php, method PHPExcel_Calculation_Financial::FV()
  FV
FVSCHEDULE
  in file Financial.php, method PHPExcel_Calculation_Financial::FVSCHEDULE()
  FVSCHEDULE
Financial.php
  procedural page Financial.php
FormulaParser.php
  procedural page FormulaParser.php
FormulaToken.php
  procedural page FormulaToken.php
Function.php
  procedural page Function.php
Functions.php
  procedural page Functions.php

top

## g

GAMMADIST
  in file Statistical.php, method PHPExcel_Calculation_Statistical::GAMMADIST()
  GAMMADIST
GAMMAINV
  in file Statistical.php, method PHPExcel_Calculation_Statistical::GAMMAINV()
  GAMMAINV
GAMMALN
  in file Statistical.php, method PHPExcel_Calculation_Statistical::GAMMALN()
  GAMMALN
GCD
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::GCD()
  GCD
GEOMEAN
  in file Statistical.php, method PHPExcel_Calculation_Statistical::GEOMEAN()
  GEOMEAN
GESTEP
  in file Engineering.php, method PHPExcel_Calculation_Engineering::GESTEP()
  GESTEP
getArrayReturnType
  in file Calculation.php, method PHPExcel_Calculation::getArrayReturnType()
  Return the Array Return Type (Array or Value of first element in the array)
getCalculationCacheEnabled
  in file Calculation.php, method PHPExcel_Calculation::getCalculationCacheEnabled()
  Is calculation caching enabled?
getCalculationCacheExpirationTime
  in file Calculation.php, method PHPExcel_Calculation::getCalculationCacheExpirationTime()
  Get calculation cache expiration time
getCategory
  in file Function.php, method PHPExcel_Calculation_Function::getCategory()
  Get Category (represented by CATEGORY_*)
getCompatibilityMode
  in file Functions.php, method PHPExcel_Calculation_Functions::getCompatibilityMode()
  Return the current Compatibility Mode
getConversionGroups
  in file Engineering.php, method PHPExcel_Calculation_Engineering::getConversionGroups()
  getConversionGroups
getConversionGroupUnitDetails
  in file Engineering.php, method PHPExcel_Calculation_Engineering::getConversionGroupUnitDetails()
  getConversionGroupUnitDetails
getConversionGroupUnits
  in file Engineering.php, method PHPExcel_Calculation_Engineering::getConversionGroupUnits()
  getConversionGroupUnits
getConversionMultipliers
  in file Engineering.php, method PHPExcel_Calculation_Engineering::getConversionMultipliers()
  getConversionGroups
getExcelName
  in file Function.php, method PHPExcel_Calculation_Function::getExcelName()
  Get Excel name
getFALSE
  in file Calculation.php, method PHPExcel_Calculation::getFALSE()
  Return the locale-specific translation of FALSE
getFormula
  in file FormulaParser.php, method PHPExcel_Calculation_FormulaParser::getFormula()
  Get Formula
getInstance
  in file Calculation.php, method PHPExcel_Calculation::getInstance()
  Get an instance of this class
getLocale
  in file Calculation.php, method PHPExcel_Calculation::getLocale()
  Get the currently defined locale code
getPHPExcelName
  in file Function.php, method PHPExcel_Calculation_Function::getPHPExcelName()
  Get PHPExcel name
getReturnDateType
  in file Functions.php, method PHPExcel_Calculation_Functions::getReturnDateType()
  Return the current Return Date Format for functions that return a date/time (Excel, PHP Serialized Numeric or PHP Object)
getToken
  in file FormulaParser.php, method PHPExcel_Calculation_FormulaParser::getToken()
  Get Token
getTokenCount
  in file FormulaParser.php, method PHPExcel_Calculation_FormulaParser::getTokenCount()
  Get Token count
getTokens
  in file FormulaParser.php, method PHPExcel_Calculation_FormulaParser::getTokens()
  Get Tokens
getTokenSubType
  in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::getTokenSubType()
  Get Token SubType (represented by TOKEN_SUBTYPE_*)
getTokenType
  in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::getTokenType()
  Get Token Type (represented by TOKEN_TYPE_*)
getTRUE
  in file Calculation.php, method PHPExcel_Calculation::getTRUE()
  Return the locale-specific translation of TRUE
getValue
  in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::getValue()
  Get Value
GROWTH
  in file Statistical.php, method PHPExcel_Calculation_Statistical::GROWTH()
  GROWTH

top

## h

HARMEAN
  in file Statistical.php, method PHPExcel_Calculation_Statistical::HARMEAN()
  HARMEAN
HEXTOBIN
  in file Engineering.php, method PHPExcel_Calculation_Engineering::HEXTOBIN()
  HEXTOBIN
HEXTODEC
  in file Engineering.php, method PHPExcel_Calculation_Engineering::HEXTODEC()
  HEXTODEC
HEXTOOCT
  in file Engineering.php, method PHPExcel_Calculation_Engineering::HEXTOOCT()
  HEXTOOCT
HOUROFDAY
  in file DateTime.php, method PHPExcel_Calculation_DateTime::HOUROFDAY()
  HOUROFDAY
HYPERLINK
  in file LookupRef.php, method PHPExcel_Calculation_LookupRef::HYPERLINK()
  HYPERLINK
HYPGEOMDIST
  in file Statistical.php, method PHPExcel_Calculation_Statistical::HYPGEOMDIST()
  HYPGEOMDIST

top

## i

IFERROR
  in file Logical.php, method PHPExcel_Calculation_Logical::IFERROR()
  IFERROR
IMABS
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMABS()
  IMABS
IMAGINARY
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMAGINARY()
  IMAGINARY
IMARGUMENT
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMARGUMENT()
  IMARGUMENT
IMCONJUGATE
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMCONJUGATE()
  IMCONJUGATE
IMCOS
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMCOS()
  IMCOS
IMDIV
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMDIV()
  IMDIV
IMEXP
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMEXP()
  IMEXP
IMLN
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMLN()
  IMLN
IMLOG2
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMLOG2()
  IMLOG2
IMLOG10
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMLOG10()
  IMLOG10
IMPOWER
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMPOWER()
  IMPOWER
IMPRODUCT
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMPRODUCT()
  IMPRODUCT
IMREAL
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMREAL()
  IMREAL
IMSIN
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMSIN()
  IMSIN
IMSQRT
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMSQRT()
  IMSQRT
IMSUB
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMSUB()
  IMSUB
IMSUM
  in file Engineering.php, method PHPExcel_Calculation_Engineering::IMSUM()
  IMSUM
INDEX
  in file LookupRef.php, method PHPExcel_Calculation_LookupRef::INDEX()
  INDEX
INDIRECT
  in file LookupRef.php, method PHPExcel_Calculation_LookupRef::INDIRECT()
  INDIRECT
INT
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::INT()
  INT
INTERCEPT
  in file Statistical.php, method PHPExcel_Calculation_Statistical::INTERCEPT()
  INTERCEPT
INTRATE
  in file Financial.php, method PHPExcel_Calculation_Financial::INTRATE()
  INTRATE
IPMT
  in file Financial.php, method PHPExcel_Calculation_Financial::IPMT()
  IPMT
IRR
  in file Financial.php, method PHPExcel_Calculation_Financial::IRR()
isCellValue
  in file Functions.php, method PHPExcel_Calculation_Functions::isCellValue()
isImplemented
  in file Calculation.php, method PHPExcel_Calculation::isImplemented()
  Is a specific function implemented?
isMatrixValue
  in file Functions.php, method PHPExcel_Calculation_Functions::isMatrixValue()
ISPMT
  in file Financial.php, method PHPExcel_Calculation_Financial::ISPMT()
  ISPMT
isValue
  in file Functions.php, method PHPExcel_Calculation_Functions::isValue()
IS_BLANK
  in file Functions.php, method PHPExcel_Calculation_Functions::IS_BLANK()
  IS_BLANK
IS_ERR
  in file Functions.php, method PHPExcel_Calculation_Functions::IS_ERR()
  IS_ERR
IS_ERROR
  in file Functions.php, method PHPExcel_Calculation_Functions::IS_ERROR()
  IS_ERROR
IS_EVEN
  in file Functions.php, method PHPExcel_Calculation_Functions::IS_EVEN()
  IS_EVEN
IS_LOGICAL
  in file Functions.php, method PHPExcel_Calculation_Functions::IS_LOGICAL()
  IS_LOGICAL
IS_NA
  in file Functions.php, method PHPExcel_Calculation_Functions::IS_NA()
  IS_NA
IS_NONTEXT
  in file Functions.php, method PHPExcel_Calculation_Functions::IS_NONTEXT()
  IS_NONTEXT
IS_NUMBER
  in file Functions.php, method PHPExcel_Calculation_Functions::IS_NUMBER()
  IS_NUMBER
IS_ODD
  in file Functions.php, method PHPExcel_Calculation_Functions::IS_ODD()
  IS_ODD
IS_TEXT
  in file Functions.php, method PHPExcel_Calculation_Functions::IS_TEXT()
  IS_TEXT

top

## k

KURT
  in file Statistical.php, method PHPExcel_Calculation_Statistical::KURT()
  KURT

top

## l

LARGE
  in file Statistical.php, method PHPExcel_Calculation_Statistical::LARGE()
  LARGE
last
  in file Calculation.php, method PHPExcel_Token_Stack::last()
LCM
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::LCM()
  LCM
LEFT
  in file TextData.php, method PHPExcel_Calculation_TextData::LEFT()
  LEFT
LINEST
  in file Statistical.php, method PHPExcel_Calculation_Statistical::LINEST()
  LINEST
listAllFunctionNames
  in file Calculation.php, method PHPExcel_Calculation::listAllFunctionNames()
  Get a list of all Excel function names
listFunctionNames
  in file Calculation.php, method PHPExcel_Calculation::listFunctionNames()
  Get a list of implemented Excel function names
listFunctions
  in file Calculation.php, method PHPExcel_Calculation::listFunctions()
  Get a list of all implemented functions as an array of function objects
LOGEST
  in file Statistical.php, method PHPExcel_Calculation_Statistical::LOGEST()
  LOGEST
LOGICAL_AND
  in file Logical.php, method PHPExcel_Calculation_Logical::LOGICAL_AND()
  LOGICAL_AND
LOGICAL_OR
  in file Logical.php, method PHPExcel_Calculation_Logical::LOGICAL_OR()
  LOGICAL_OR
LOGINV
  in file Statistical.php, method PHPExcel_Calculation_Statistical::LOGINV()
  LOGINV
LOGNORMDIST
  in file Statistical.php, method PHPExcel_Calculation_Statistical::LOGNORMDIST()
  LOGNORMDIST
LOG_BASE
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::LOG_BASE()
  LOG_BASE
LOG_GAMMA_X_MAX_VALUE
  in file Statistical.php, constant LOG_GAMMA_X_MAX_VALUE
  LOG_GAMMA_X_MAX_VALUE
LOOKUP
  in file LookupRef.php, method PHPExcel_Calculation_LookupRef::LOOKUP()
  LOOKUP The LOOKUP function searches for value either from a one-row or one-column range or from an array.
LOWERCASE
  in file TextData.php, method PHPExcel_Calculation_TextData::LOWERCASE()
  LOWERCASE
Logical.php
  procedural page Logical.php
LookupRef.php
  procedural page LookupRef.php

top

## m

MATCH
  in file LookupRef.php, method PHPExcel_Calculation_LookupRef::MATCH()
  MATCH
MAX
  in file Statistical.php, method PHPExcel_Calculation_Statistical::MAX()
  MAX
MAXA
  in file Statistical.php, method PHPExcel_Calculation_Statistical::MAXA()
  MAXA
MAXIF
  in file Statistical.php, method PHPExcel_Calculation_Statistical::MAXIF()
  MAXIF
MAX_ITERATIONS
  in file Functions.php, constant MAX_ITERATIONS
  MAX_ITERATIONS
MAX_VALUE
  in file Functions.php, constant MAX_VALUE
  MAX_VALUE
mb_str_replace
  in file Functions.php, function mb_str_replace()
MDETERM
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::MDETERM()
  MDETERM
MEDIAN
  in file Statistical.php, method PHPExcel_Calculation_Statistical::MEDIAN()
  MEDIAN
MID
  in file TextData.php, method PHPExcel_Calculation_TextData::MID()
  MID
MIN
  in file Statistical.php, method PHPExcel_Calculation_Statistical::MIN()
  MIN
MINA
  in file Statistical.php, method PHPExcel_Calculation_Statistical::MINA()
  MINA
MINIF
  in file Statistical.php, method PHPExcel_Calculation_Statistical::MINIF()
  MINIF
MINUTEOFHOUR
  in file DateTime.php, method PHPExcel_Calculation_DateTime::MINUTEOFHOUR()
  MINUTEOFHOUR
MINVERSE
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::MINVERSE()
  MINVERSE
MIRR
  in file Financial.php, method PHPExcel_Calculation_Financial::MIRR()
MMULT
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::MMULT()
  MMULT
MOD
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::MOD()
  MOD
MODE
  in file Statistical.php, method PHPExcel_Calculation_Statistical::MODE()
  MODE
money_format
  in file Functions.php, function money_format()
MONTHOFYEAR
  in file DateTime.php, method PHPExcel_Calculation_DateTime::MONTHOFYEAR()
  MONTHOFYEAR
MROUND
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::MROUND()
  MROUND
MULTINOMIAL
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::MULTINOMIAL()
  MULTINOMIAL
M_2DIVPI
  in file Functions.php, constant M_2DIVPI
  2 / PI
MathTrig.php
  procedural page MathTrig.php

top

## n

N
  in file Functions.php, method PHPExcel_Calculation_Functions::N()
  N
NA
  in file Functions.php, method PHPExcel_Calculation_Functions::NA()
  NA
NAME
  in file Functions.php, method PHPExcel_Calculation_Functions::NAME()
  NAME
NaN
  in file Functions.php, method PHPExcel_Calculation_Functions::NaN()
  NaN
NEGBINOMDIST
  in file Statistical.php, method PHPExcel_Calculation_Statistical::NEGBINOMDIST()
  NEGBINOMDIST
NETWORKDAYS
  in file DateTime.php, method PHPExcel_Calculation_DateTime::NETWORKDAYS()
  NETWORKDAYS
NOMINAL
  in file Financial.php, method PHPExcel_Calculation_Financial::NOMINAL()
  NOMINAL
NORMDIST
  in file Statistical.php, method PHPExcel_Calculation_Statistical::NORMDIST()
  NORMDIST
NORMINV
  in file Statistical.php, method PHPExcel_Calculation_Statistical::NORMINV()
  NORMINV
NORMSDIST
  in file Statistical.php, method PHPExcel_Calculation_Statistical::NORMSDIST()
  NORMSDIST
NORMSINV
  in file Statistical.php, method PHPExcel_Calculation_Statistical::NORMSINV()
  NORMSINV
NOT
  in file Logical.php, method PHPExcel_Calculation_Logical::NOT()
  NOT
NPER
  in file Financial.php, method PHPExcel_Calculation_Financial::NPER()
  NPER
NPV
  in file Financial.php, method PHPExcel_Calculation_Financial::NPV()
  NPV
NULL
  in file Functions.php, method PHPExcel_Calculation_Functions::NULL()
  NULL

top

## o

OCTTOBIN
  in file Engineering.php, method PHPExcel_Calculation_Engineering::OCTTOBIN()
  OCTTOBIN
OCTTODEC
  in file Engineering.php, method PHPExcel_Calculation_Engineering::OCTTODEC()
  OCTTODEC
OCTTOHEX
  in file Engineering.php, method PHPExcel_Calculation_Engineering::OCTTOHEX()
  OCTTOHEX
ODD
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::ODD()
  ODD
OFFSET
  in file LookupRef.php, method PHPExcel_Calculation_LookupRef::OFFSET()
  OFFSET
OPERATORS_INFIX
  in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::OPERATORS_INFIX
OPERATORS_POSTFIX
  in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::OPERATORS_POSTFIX
OPERATORS_SN
  in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::OPERATORS_SN

top

## p

PAREN_CLOSE
  in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::PAREN_CLOSE
PAREN_OPEN
  in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::PAREN_OPEN
parseFormula
  in file Calculation.php, method PHPExcel_Calculation::parseFormula()
  Validate and parse a formula string
PERCENTILE
  in file Statistical.php, method PHPExcel_Calculation_Statistical::PERCENTILE()
  PERCENTILE
PERCENTRANK
  in file Statistical.php, method PHPExcel_Calculation_Statistical::PERCENTRANK()
  PERCENTRANK
PERMUT
  in file Statistical.php, method PHPExcel_Calculation_Statistical::PERMUT()
  PERMUT
PHPExcel_Calculation
  in file Calculation.php, class PHPExcel_Calculation
  PHPExcel_Calculation (Singleton)
PHPExcel_Calculation_Database
  in file Database.php, class PHPExcel_Calculation_Database
  PHPExcel_Calculation_Database
PHPExcel_Calculation_DateTime
  in file DateTime.php, class PHPExcel_Calculation_DateTime
  PHPExcel_Calculation_DateTime
PHPExcel_Calculation_Engineering
  in file Engineering.php, class PHPExcel_Calculation_Engineering
  PHPExcel_Calculation_Engineering
PHPExcel_Calculation_Exception
  in file Exception.php, class PHPExcel_Calculation_Exception
  PHPExcel_Calculation_Exception
PHPExcel_Calculation_ExceptionHandler
  in file ExceptionHandler.php, class PHPExcel_Calculation_ExceptionHandler
  PHPExcel_Calculation_ExceptionHandler
PHPExcel_Calculation_Financial
  in file Financial.php, class PHPExcel_Calculation_Financial
  PHPExcel_Calculation_Financial
PHPExcel_Calculation_FormulaParser
  in file FormulaParser.php, class PHPExcel_Calculation_FormulaParser
  PHPExcel_Calculation_FormulaParser
PHPExcel_Calculation_FormulaToken
  in file FormulaToken.php, class PHPExcel_Calculation_FormulaToken
  PHPExcel_Calculation_FormulaToken
PHPExcel_Calculation_Function
  in file Function.php, class PHPExcel_Calculation_Function
  PHPExcel_Calculation_Function
PHPExcel_Calculation_Functions
  in file Functions.php, class PHPExcel_Calculation_Functions
  PHPExcel_Calculation_Functions
PHPExcel_Calculation_Logical
  in file Logical.php, class PHPExcel_Calculation_Logical
  PHPExcel_Calculation_Logical
PHPExcel_Calculation_LookupRef
  in file LookupRef.php, class PHPExcel_Calculation_LookupRef
  PHPExcel_Calculation_LookupRef
PHPExcel_Calculation_MathTrig
  in file MathTrig.php, class PHPExcel_Calculation_MathTrig
  PHPExcel_Calculation_MathTrig
PHPExcel_Calculation_Statistical
  in file Statistical.php, class PHPExcel_Calculation_Statistical
  PHPExcel_Calculation_Statistical
PHPExcel_Calculation_TextData
  in file TextData.php, class PHPExcel_Calculation_TextData
  PHPExcel_Calculation_TextData
PHPExcel_Token_Stack
  in file Calculation.php, class PHPExcel_Token_Stack
PMT
  in file Financial.php, method PHPExcel_Calculation_Financial::PMT()
  PMT
POISSON
  in file Statistical.php, method PHPExcel_Calculation_Statistical::POISSON()
  POISSON
pop
  in file Calculation.php, method PHPExcel_Token_Stack::pop()
POWER
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::POWER()
  POWER
PPMT
  in file Financial.php, method PHPExcel_Calculation_Financial::PPMT()
  PPMT
PRECISION
  in file Functions.php, constant PRECISION
  PRECISION
PRICE
  in file Financial.php, method PHPExcel_Calculation_Financial::PRICE()
PRICEDISC
  in file Financial.php, method PHPExcel_Calculation_Financial::PRICEDISC()
  PRICEDISC
PRICEMAT
  in file Financial.php, method PHPExcel_Calculation_Financial::PRICEMAT()
  PRICEMAT
PRODUCT
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::PRODUCT()
  PRODUCT
PROPERCASE
  in file TextData.php, method PHPExcel_Calculation_TextData::PROPERCASE()
  PROPERCASE
push
  in file Calculation.php, method PHPExcel_Token_Stack::push()
PV
  in file Financial.php, method PHPExcel_Calculation_Financial::PV()
  PV

top

## q

QUARTILE
  in file Statistical.php, method PHPExcel_Calculation_Statistical::QUARTILE()
  QUARTILE
QUOTE_DOUBLE
  in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::QUOTE_DOUBLE
QUOTE_SINGLE
  in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::QUOTE_SINGLE
QUOTIENT
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::QUOTIENT()
  QUOTIENT

top

## r

$ReturnDateType
  in file Functions.php, variable PHPExcel_Calculation_Functions::$ReturnDateType
  Data Type to use when returning date values
RAND
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::RAND()
  RAND
RANK
  in file Statistical.php, method PHPExcel_Calculation_Statistical::RANK()
  RANK
RATE
  in file Financial.php, method PHPExcel_Calculation_Financial::RATE()
  RATE
RECEIVED
  in file Financial.php, method PHPExcel_Calculation_Financial::RECEIVED()
  RECEIVED
REF
  in file Functions.php, method PHPExcel_Calculation_Functions::REF()
  REF
REPLACE
  in file TextData.php, method PHPExcel_Calculation_TextData::REPLACE()
  REPLACE
RETURNDATE_EXCEL
  in file Functions.php, class constant PHPExcel_Calculation_Functions::RETURNDATE_EXCEL
RETURNDATE_PHP_NUMERIC
  in file Functions.php, class constant PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC
RETURNDATE_PHP_OBJECT
  in file Functions.php, class constant PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT
RETURNSTRING
  in file TextData.php, method PHPExcel_Calculation_TextData::RETURNSTRING()
  RETURNSTRING
RETURN_ARRAY_AS_ARRAY
  in file Calculation.php, class constant PHPExcel_Calculation::RETURN_ARRAY_AS_ARRAY
RETURN_ARRAY_AS_ERROR
  in file Calculation.php, class constant PHPExcel_Calculation::RETURN_ARRAY_AS_ERROR
  constants
RETURN_ARRAY_AS_VALUE
  in file Calculation.php, class constant PHPExcel_Calculation::RETURN_ARRAY_AS_VALUE
RIGHT
  in file TextData.php, method PHPExcel_Calculation_TextData::RIGHT()
  RIGHT
ROMAN
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::ROMAN()
ROUNDDOWN
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::ROUNDDOWN()
  ROUNDDOWN
ROUNDUP
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::ROUNDUP()
  ROUNDUP
ROW
  in file LookupRef.php, method PHPExcel_Calculation_LookupRef::ROW()
  ROW
ROWS
  in file LookupRef.php, method PHPExcel_Calculation_LookupRef::ROWS()
  ROWS
RSQ
  in file Statistical.php, method PHPExcel_Calculation_Statistical::RSQ()
  RSQ

top

## s

$suppressFormulaErrors
  in file Calculation.php, variable PHPExcel_Calculation::$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
Statistical.php
  procedural page Statistical.php
SEARCHINSENSITIVE
  in file TextData.php, method PHPExcel_Calculation_TextData::SEARCHINSENSITIVE()
  SEARCHINSENSITIVE
SEARCHSENSITIVE
  in file TextData.php, method PHPExcel_Calculation_TextData::SEARCHSENSITIVE()
  SEARCHSENSITIVE
SECONDOFMINUTE
  in file DateTime.php, method PHPExcel_Calculation_DateTime::SECONDOFMINUTE()
  SECONDOFMINUTE
SEMICOLON
  in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::SEMICOLON
SERIESSUM
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::SERIESSUM()
  SERIESSUM
setArrayReturnType
  in file Calculation.php, method PHPExcel_Calculation::setArrayReturnType()
  Set the Array Return Type (Array or Value of first element in the array)
setCalculationCacheEnabled
  in file Calculation.php, method PHPExcel_Calculation::setCalculationCacheEnabled()
  Enable/disable calculation cache
setCalculationCacheExpirationTime
  in file Calculation.php, method PHPExcel_Calculation::setCalculationCacheExpirationTime()
  Set calculation cache expiration time
setCategory
  in file Function.php, method PHPExcel_Calculation_Function::setCategory()
  Set Category (represented by CATEGORY_*)
setCompatibilityMode
  in file Functions.php, method PHPExcel_Calculation_Functions::setCompatibilityMode()
  Set the Compatibility Mode
setExcelName
  in file Function.php, method PHPExcel_Calculation_Function::setExcelName()
  Set Excel name
setLocale
  in file Calculation.php, method PHPExcel_Calculation::setLocale()
  Set the locale code
setPHPExcelName
  in file Function.php, method PHPExcel_Calculation_Function::setPHPExcelName()
  Set PHPExcel name
setReturnDateType
  in file Functions.php, method PHPExcel_Calculation_Functions::setReturnDateType()
  Set the Return Date Format used by functions that return a date/time (Excel, PHP Serialized Numeric or PHP Object)
setTokenSubType
  in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::setTokenSubType()
  Set Token SubType
setTokenType
  in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::setTokenType()
  Set Token Type
setValue
  in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::setValue()
  Set Value
SIGN
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::SIGN()
  SIGN
SKEW
  in file Statistical.php, method PHPExcel_Calculation_Statistical::SKEW()
  SKEW
SLN
  in file Financial.php, method PHPExcel_Calculation_Financial::SLN()
  SLN
SLOPE
  in file Statistical.php, method PHPExcel_Calculation_Statistical::SLOPE()
  SLOPE
SMALL
  in file Statistical.php, method PHPExcel_Calculation_Statistical::SMALL()
  SMALL
SQRT2PI
  in file Statistical.php, constant SQRT2PI
  SQRT2PI
SQRTPI
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::SQRTPI()
  SQRTPI
STANDARDIZE
  in file Statistical.php, method PHPExcel_Calculation_Statistical::STANDARDIZE()
  STANDARDIZE
STATEMENT_IF
  in file Logical.php, method PHPExcel_Calculation_Logical::STATEMENT_IF()
  STATEMENT_IF
STDEV
  in file Statistical.php, method PHPExcel_Calculation_Statistical::STDEV()
  STDEV
STDEVA
  in file Statistical.php, method PHPExcel_Calculation_Statistical::STDEVA()
  STDEVA
STDEVP
  in file Statistical.php, method PHPExcel_Calculation_Statistical::STDEVP()
  STDEVP
STDEVPA
  in file Statistical.php, method PHPExcel_Calculation_Statistical::STDEVPA()
  STDEVPA
STEYX
  in file Statistical.php, method PHPExcel_Calculation_Statistical::STEYX()
  STEYX
STRINGLENGTH
  in file TextData.php, method PHPExcel_Calculation_TextData::STRINGLENGTH()
  STRINGLENGTH
SUBSTITUTE
  in file TextData.php, method PHPExcel_Calculation_TextData::SUBSTITUTE()
  SUBSTITUTE
SUBTOTAL
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::SUBTOTAL()
  SUBTOTAL
SUM
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::SUM()
  SUM
SUMIF
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::SUMIF()
  SUMIF
SUMPRODUCT
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::SUMPRODUCT()
  SUMPRODUCT
SUMSQ
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::SUMSQ()
  SUMSQ
SUMX2MY2
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::SUMX2MY2()
  SUMX2MY2
SUMX2PY2
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::SUMX2PY2()
  SUMX2PY2
SUMXMY2
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::SUMXMY2()
  SUMXMY2
SYD
  in file Financial.php, method PHPExcel_Calculation_Financial::SYD()
  SYD

top

## t

TextData.php
  procedural page TextData.php
TBILLEQ
  in file Financial.php, method PHPExcel_Calculation_Financial::TBILLEQ()
  TBILLEQ
TBILLPRICE
  in file Financial.php, method PHPExcel_Calculation_Financial::TBILLPRICE()
  TBILLPRICE
TBILLYIELD
  in file Financial.php, method PHPExcel_Calculation_Financial::TBILLYIELD()
  TBILLYIELD
TDIST
  in file Statistical.php, method PHPExcel_Calculation_Statistical::TDIST()
  TDIST
TEXTFORMAT
  in file TextData.php, method PHPExcel_Calculation_TextData::TEXTFORMAT()
  TEXTFORMAT
TIME
  in file DateTime.php, method PHPExcel_Calculation_DateTime::TIME()
  TIME
TIMEVALUE
  in file DateTime.php, method PHPExcel_Calculation_DateTime::TIMEVALUE()
  TIMEVALUE
TINV
  in file Statistical.php, method PHPExcel_Calculation_Statistical::TINV()
  TINV
TOKEN_SUBTYPE_CONCATENATION
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_CONCATENATION
TOKEN_SUBTYPE_ERROR
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_ERROR
TOKEN_SUBTYPE_INTERSECTION
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_INTERSECTION
TOKEN_SUBTYPE_LOGICAL
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_LOGICAL
TOKEN_SUBTYPE_MATH
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_MATH
TOKEN_SUBTYPE_NOTHING
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_NOTHING
TOKEN_SUBTYPE_NUMBER
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_NUMBER
TOKEN_SUBTYPE_RANGE
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_RANGE
TOKEN_SUBTYPE_START
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_START
TOKEN_SUBTYPE_STOP
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_STOP
TOKEN_SUBTYPE_TEXT
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_TEXT
TOKEN_SUBTYPE_UNION
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_UNION
TOKEN_TYPE_ARGUMENT
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_ARGUMENT
TOKEN_TYPE_FUNCTION
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_FUNCTION
TOKEN_TYPE_NOOP
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_NOOP
TOKEN_TYPE_OPERAND
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_OPERAND
TOKEN_TYPE_OPERATORINFIX
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_OPERATORINFIX
TOKEN_TYPE_OPERATORPOSTFIX
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_OPERATORPOSTFIX
TOKEN_TYPE_OPERATORPREFIX
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_OPERATORPREFIX
TOKEN_TYPE_SUBEXPRESSION
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_SUBEXPRESSION
TOKEN_TYPE_UNKNOWN
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_UNKNOWN
TOKEN_TYPE_WHITESPACE
  in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_WHITESPACE
TRANSPOSE
  in file LookupRef.php, method PHPExcel_Calculation_LookupRef::TRANSPOSE()
  TRANSPOSE
TREND
  in file Statistical.php, method PHPExcel_Calculation_Statistical::TREND()
  TREND
TRIMMEAN
  in file Statistical.php, method PHPExcel_Calculation_Statistical::TRIMMEAN()
  TRIMMEAN
TRIMNONPRINTABLE
  in file TextData.php, method PHPExcel_Calculation_TextData::TRIMNONPRINTABLE()
  TRIMNONPRINTABLE
TRIMSPACES
  in file TextData.php, method PHPExcel_Calculation_TextData::TRIMSPACES()
  TRIMSPACES
TRUE
  in file Logical.php, method PHPExcel_Calculation_Logical::TRUE()
  TRUE
TRUNC
  in file MathTrig.php, method PHPExcel_Calculation_MathTrig::TRUNC()
  TRUNC
TYPE
  in file Functions.php, method PHPExcel_Calculation_Functions::TYPE()
  TYPE

top

## u

UPPERCASE
  in file TextData.php, method PHPExcel_Calculation_TextData::UPPERCASE()
  UPPERCASE

top

## v

VALUE
  in file Functions.php, method PHPExcel_Calculation_Functions::VALUE()
  VALUE
VARA
  in file Statistical.php, method PHPExcel_Calculation_Statistical::VARA()
  VARA
VARFunc
  in file Statistical.php, method PHPExcel_Calculation_Statistical::VARFunc()
  VARFunc
VARP
  in file Statistical.php, method PHPExcel_Calculation_Statistical::VARP()
  VARP
VARPA
  in file Statistical.php, method PHPExcel_Calculation_Statistical::VARPA()
  VARPA
VERSION
  in file Functions.php, method PHPExcel_Calculation_Functions::VERSION()
  VERSION
VLOOKUP
  in file LookupRef.php, method PHPExcel_Calculation_LookupRef::VLOOKUP()
  VLOOKUP The VLOOKUP function searches for value in the left-most column of lookup_array and returns the value in the same row based on the index_number.

top

## w

$writeDebugLog
  in file Calculation.php, variable PHPExcel_Calculation::$writeDebugLog
  Flag to determine whether a debug log should be generated by the calculation engine If true, then a debug log will be generated If false, then a debug log will not be generated
WEEKOFYEAR
  in file DateTime.php, method PHPExcel_Calculation_DateTime::WEEKOFYEAR()
  WEEKOFYEAR
WEIBULL
  in file Statistical.php, method PHPExcel_Calculation_Statistical::WEIBULL()
  WEIBULL
WHITESPACE
  in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::WHITESPACE
WORKDAY
  in file DateTime.php, method PHPExcel_Calculation_DateTime::WORKDAY()
  WORKDAY

top

## x

XIRR
  in file Financial.php, method PHPExcel_Calculation_Financial::XIRR()
XMININ
  in file Statistical.php, constant XMININ
  XMININ
XNPV
  in file Financial.php, method PHPExcel_Calculation_Financial::XNPV()
  XNPV

top

## y

YEAR
  in file DateTime.php, method PHPExcel_Calculation_DateTime::YEAR()
  YEAR
YEARFRAC
  in file DateTime.php, method PHPExcel_Calculation_DateTime::YEARFRAC()
  YEARFRAC
YIELDDISC
  in file Financial.php, method PHPExcel_Calculation_Financial::YIELDDISC()
  YIELDDISC
YIELDMAT
  in file Financial.php, method PHPExcel_Calculation_Financial::YIELDMAT()
  YIELDMAT

top

## z

ZTEST
  in file Statistical.php, method PHPExcel_Calculation_Statistical::ZTEST()
  ZTEST

top

Documentation generated on Sun, 27 Feb 2011 16:26:38 -0800 by phpDocumentor 1.4.3