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() 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:23:12 +0200 by phpDocumentor 1.4.4