PHPExcel_Calculation
[ class tree: PHPExcel_Calculation ] [ index: PHPExcel_Calculation ] [ all elements ]

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()
    Identify if a year is a leap year or not
_localeFunc
in file Calculation.php, method PHPExcel_Calculation::_localeFunc()
_parseComplex
in file Engineering.php, method PHPExcel_Calculation_Engineering::_parseComplex()
    _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 Stack.php, method PHPExcel_Calculation_Token_Stack::__construct()
__construct
in file ExceptionHandler.php, method PHPExcel_Calculation_ExceptionHandler::__construct()
    Register errorhandler
__construct
in file Function.php, method PHPExcel_Calculation_Function::__construct()
    Create a new PHPExcel_Calculation_Function
__construct
in file FormulaParser.php, method PHPExcel_Calculation_FormulaParser::__construct()
    Create a new PHPExcel_Calculation_FormulaParser
__construct
in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::__construct()
    Create a new PHPExcel_Calculation_FormulaToken
__destruct
in file ExceptionHandler.php, method PHPExcel_Calculation_ExceptionHandler::__destruct()
    Unregister errorhandler
__destruct
in file Calculation.php, method PHPExcel_Calculation::__destruct()
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()
    AMORDEGRC
AMORLINC
in file Financial.php, method PHPExcel_Calculation_Financial::AMORLINC()
    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, constant CALCULATION_REGEXP_NAMEDRANGE
CALCULATION_REGEXP_NAMEDRANGE
in file Calculation.php, class constant PHPExcel_Calculation::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()
    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 Stack.php, method PHPExcel_Calculation_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()
    COUPDAYBS
COUPDAYS
in file Financial.php, method PHPExcel_Calculation_Financial::COUPDAYS()
    COUPDAYS
COUPDAYSNC
in file Financial.php, method PHPExcel_Calculation_Financial::COUPDAYSNC()
    COUPDAYSNC
COUPNCD
in file Financial.php, method PHPExcel_Calculation_Financial::COUPNCD()
    COUPNCD
COUPNUM
in file Financial.php, method PHPExcel_Calculation_Financial::COUPNUM()
    COUPNUM
COUPPCD
in file Financial.php, method PHPExcel_Calculation_Financial::COUPPCD()
    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 Returns a list of the different conversion groups for UOM conversions
getConversionGroupUnitDetails
in file Engineering.php, method PHPExcel_Calculation_Engineering::getConversionGroupUnitDetails()
    getConversionGroupUnitDetails
getConversionGroupUnits
in file Engineering.php, method PHPExcel_Calculation_Engineering::getConversionGroupUnits()
    getConversionGroupUnits Returns an array of units of measure, for a specified conversion group, or for all groups
getConversionMultipliers
in file Engineering.php, method PHPExcel_Calculation_Engineering::getConversionMultipliers()
    getConversionMultipliers Returns an array of the Multiplier prefixes that can be used with Units of Measure in CONVERTUOM()
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 Stack.php, method PHPExcel_Calculation_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_Calculation_Token_Stack
in file Stack.php, class PHPExcel_Calculation_Token_Stack
    PHPExcel
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 Stack.php, method PHPExcel_Calculation_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 Stack.php, method PHPExcel_Calculation_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
Stack.php
procedural page Stack.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 Fri, 12 Oct 2012 00:15:04 +0200 by phpDocumentor 1.4.4