1367 lines
132 KiB
HTML
1367 lines
132 KiB
HTML
<html>
|
|
<head>
|
|
<title>Package PHPExcel_Calculation Element Index</title>
|
|
<link rel="stylesheet" type="text/css" href="media/style.css">
|
|
</head>
|
|
<body>
|
|
|
|
<table border="0" cellspacing="0" cellpadding="0" height="48" width="100%">
|
|
<tr>
|
|
<td class="header_top">PHPExcel_Calculation</td>
|
|
</tr>
|
|
<tr><td class="header_line"><img src="media/empty.png" width="1" height="1" border="0" alt="" /></td></tr>
|
|
<tr>
|
|
<td class="header_menu">
|
|
|
|
|
|
[ <a href="classtrees_PHPExcel_Calculation.html" class="menu">class tree: PHPExcel_Calculation</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html" class="menu">index: PHPExcel_Calculation</a> ]
|
|
[ <a href="elementindex.html" class="menu">all elements</a> ]
|
|
</td>
|
|
</tr>
|
|
<tr><td class="header_line"><img src="media/empty.png" width="1" height="1" border="0" alt="" /></td></tr>
|
|
</table>
|
|
|
|
<table width="100%" border="0" cellpadding="0" cellspacing="0">
|
|
<tr valign="top">
|
|
<td width="200" class="menu">
|
|
<div id="todolist">
|
|
<p><a href="todolist.html">Todo List</a></p>
|
|
</div>
|
|
<b>Packages:</b><br />
|
|
<a href="li_PHPExcel.html">PHPExcel</a><br />
|
|
<a href="li_PHPExcel_CachedObjectStorage.html">PHPExcel_CachedObjectStorage</a><br />
|
|
<a href="li_PHPExcel_Calculation.html">PHPExcel_Calculation</a><br />
|
|
<a href="li_PHPExcel_Cell.html">PHPExcel_Cell</a><br />
|
|
<a href="li_PHPExcel_Chart.html">PHPExcel_Chart</a><br />
|
|
<a href="li_PHPExcel_Chart_Renderer.html">PHPExcel_Chart_Renderer</a><br />
|
|
<a href="li_PHPExcel_Reader.html">PHPExcel_Reader</a><br />
|
|
<a href="li_PHPExcel_Reader_Excel5.html">PHPExcel_Reader_Excel5</a><br />
|
|
<a href="li_PHPExcel_Reader_Excel2007.html">PHPExcel_Reader_Excel2007</a><br />
|
|
<a href="li_PHPExcel_RichText.html">PHPExcel_RichText</a><br />
|
|
<a href="li_PHPExcel_Settings.html">PHPExcel_Settings</a><br />
|
|
<a href="li_PHPExcel_Shared.html">PHPExcel_Shared</a><br />
|
|
<a href="li_PHPExcel_Shared_Escher.html">PHPExcel_Shared_Escher</a><br />
|
|
<a href="li_JAMA.html">JAMA</a><br />
|
|
<a href="li_Math_Stats.html">Math_Stats</a><br />
|
|
<a href="li_PHPExcel_Shared_OLE.html">PHPExcel_Shared_OLE</a><br />
|
|
<a href="li_PHPExcel_Shared_Trend.html">PHPExcel_Shared_Trend</a><br />
|
|
<a href="li_PHPExcel_Shared_ZipArchive.html">PHPExcel_Shared_ZipArchive</a><br />
|
|
<a href="li_PHPExcel_Style.html">PHPExcel_Style</a><br />
|
|
<a href="li_PHPExcel_Worksheet.html">PHPExcel_Worksheet</a><br />
|
|
<a href="li_PHPExcel_Worksheet_Drawing.html">PHPExcel_Worksheet_Drawing</a><br />
|
|
<a href="li_PHPExcel_Writer.html">PHPExcel_Writer</a><br />
|
|
<a href="li_PHPExcel_Writer_Excel5.html">PHPExcel_Writer_Excel5</a><br />
|
|
<a href="li_PHPExcel_Writer_Excel2007.html">PHPExcel_Writer_Excel2007</a><br />
|
|
<br /><br />
|
|
<b>Files:</b><br />
|
|
<div class="package">
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation.php.html"> Calculation.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---Database.php.html"> Database.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---DateTime.php.html"> DateTime.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---Engineering.php.html"> Engineering.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---Exception.php.html"> Exception.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---ExceptionHandler.php.html"> ExceptionHandler.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---Financial.php.html"> Financial.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---FormulaParser.php.html"> FormulaParser.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---FormulaToken.php.html"> FormulaToken.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---Function.php.html"> Function.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---Functions.php.html"> Functions.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---Logical.php.html"> Logical.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---LookupRef.php.html"> LookupRef.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---MathTrig.php.html"> MathTrig.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---Token---Stack.php.html"> Stack.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---Statistical.php.html"> Statistical.php
|
|
</a><br>
|
|
<a href="PHPExcel_Calculation/_PHPExcel---Calculation---TextData.php.html"> TextData.php
|
|
</a><br>
|
|
</div><br />
|
|
|
|
|
|
<b>Classes:</b><br />
|
|
<div class="package">
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation.html">PHPExcel_Calculation</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_Database.html">PHPExcel_Calculation_Database</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html">PHPExcel_Calculation_DateTime</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html">PHPExcel_Calculation_Engineering</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_Exception.html">PHPExcel_Calculation_Exception</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_ExceptionHandler.html">PHPExcel_Calculation_ExceptionHandler</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html">PHPExcel_Calculation_Financial</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html">PHPExcel_Calculation_FormulaParser</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html">PHPExcel_Calculation_FormulaToken</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html">PHPExcel_Calculation_Function</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html">PHPExcel_Calculation_Functions</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_Logical.html">PHPExcel_Calculation_Logical</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html">PHPExcel_Calculation_LookupRef</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html">PHPExcel_Calculation_MathTrig</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html">PHPExcel_Calculation_Statistical</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html">PHPExcel_Calculation_TextData</a><br />
|
|
<a href="PHPExcel_Calculation/PHPExcel_Calculation_Token_Stack.html">PHPExcel_Calculation_Token_Stack</a><br />
|
|
</div>
|
|
</td>
|
|
<td>
|
|
<table cellpadding="10" cellspacing="0" width="100%" border="0"><tr><td valign="top">
|
|
|
|
<a name="top"></a>
|
|
<h1>Element index for package PHPExcel_Calculation</h1>
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#a">a</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#b">b</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#c">c</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#d">d</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#e">e</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#f">f</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#g">g</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#h">h</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#i">i</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#k">k</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#l">l</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#m">m</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#n">n</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#o">o</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#p">p</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#q">q</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#r">r</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#s">s</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#t">t</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#u">u</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#v">v</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#w">w</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#x">x</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#y">y</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#z">z</a> ]
|
|
[ <a href="elementindex_PHPExcel_Calculation.html#_">_</a> ]
|
|
|
|
<hr />
|
|
<a name="_"></a>
|
|
<div>
|
|
<h2>_</h2>
|
|
<dl>
|
|
<dt><b>$_errorCodes</b></dt>
|
|
<dd>in file Functions.php, variable <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#var$_errorCodes">PHPExcel_Calculation_Functions::$_errorCodes</a><br> List of error codes</dd>
|
|
<dt><b>$_localeBoolean</b></dt>
|
|
<dd>in file Calculation.php, variable <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#var$_localeBoolean">PHPExcel_Calculation::$_localeBoolean</a></dd>
|
|
<dt><b>_calculateFormulaValue</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#method_calculateFormulaValue">PHPExcel_Calculation::_calculateFormulaValue()</a><br> Parse a cell formula and calculate its value</dd>
|
|
<dt><b>_erfVal</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#method_erfVal">PHPExcel_Calculation_Engineering::_erfVal()</a></dd>
|
|
<dt><b>_getDateValue</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#method_getDateValue">PHPExcel_Calculation_DateTime::_getDateValue()</a><br> _getDateValue</dd>
|
|
<dt><b>_getMatrixDimensions</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#method_getMatrixDimensions">PHPExcel_Calculation::_getMatrixDimensions()</a><br> Read the dimensions of a matrix, and re-index it with straight numeric keys starting from row 0, column 0</dd>
|
|
<dt><b>_ifCondition</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#method_ifCondition">PHPExcel_Calculation_Functions::_ifCondition()</a></dd>
|
|
<dt><b>_isLeapYear</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#method_isLeapYear">PHPExcel_Calculation_DateTime::_isLeapYear()</a><br> Identify if a year is a leap year or not</dd>
|
|
<dt><b>_localeFunc</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#method_localeFunc">PHPExcel_Calculation::_localeFunc()</a></dd>
|
|
<dt><b>_parseComplex</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#method_parseComplex">PHPExcel_Calculation_Engineering::_parseComplex()</a><br> _parseComplex</dd>
|
|
<dt><b>_raiseFormulaError</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#method_raiseFormulaError">PHPExcel_Calculation::_raiseFormulaError()</a></dd>
|
|
<dt><b>_translateFormulaToEnglish</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#method_translateFormulaToEnglish">PHPExcel_Calculation::_translateFormulaToEnglish()</a></dd>
|
|
<dt><b>_translateFormulaToLocale</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#method_translateFormulaToLocale">PHPExcel_Calculation::_translateFormulaToLocale()</a></dd>
|
|
<dt><b>_translateSeparator</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#method_translateSeparator">PHPExcel_Calculation::_translateSeparator()</a></dd>
|
|
<dt><b>_unwrapResult</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#method_unwrapResult">PHPExcel_Calculation::_unwrapResult()</a><br> Remove quotes used as a wrapper to identify string values</dd>
|
|
<dt><b>_wrapResult</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#method_wrapResult">PHPExcel_Calculation::_wrapResult()</a><br> Wrap string values in quotes</dd>
|
|
<dt><b>__clone</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#method__clone">PHPExcel_Calculation::__clone()</a><br> __clone implementation. Cloning should not be allowed in a Singleton!</dd>
|
|
<dt><b>__construct</b></dt>
|
|
<dd>in file Stack.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Token_Stack.html#method__construct">PHPExcel_Calculation_Token_Stack::__construct()</a></dd>
|
|
<dt><b>__construct</b></dt>
|
|
<dd>in file ExceptionHandler.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_ExceptionHandler.html#method__construct">PHPExcel_Calculation_ExceptionHandler::__construct()</a><br> Register errorhandler</dd>
|
|
<dt><b>__construct</b></dt>
|
|
<dd>in file Function.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#method__construct">PHPExcel_Calculation_Function::__construct()</a><br> Create a new PHPExcel_Calculation_Function</dd>
|
|
<dt><b>__construct</b></dt>
|
|
<dd>in file FormulaParser.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#method__construct">PHPExcel_Calculation_FormulaParser::__construct()</a><br> Create a new PHPExcel_Calculation_FormulaParser</dd>
|
|
<dt><b>__construct</b></dt>
|
|
<dd>in file FormulaToken.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#method__construct">PHPExcel_Calculation_FormulaToken::__construct()</a><br> Create a new PHPExcel_Calculation_FormulaToken</dd>
|
|
<dt><b>__destruct</b></dt>
|
|
<dd>in file ExceptionHandler.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_ExceptionHandler.html#method__destruct">PHPExcel_Calculation_ExceptionHandler::__destruct()</a><br> Unregister errorhandler</dd>
|
|
<dt><b>__destruct</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#method__destruct">PHPExcel_Calculation::__destruct()</a></dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="a"></a>
|
|
<div>
|
|
<h2>a</h2>
|
|
<dl>
|
|
<dt><b>ACCRINT</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodACCRINT">PHPExcel_Calculation_Financial::ACCRINT()</a><br> ACCRINT</dd>
|
|
<dt><b>ACCRINTM</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodACCRINTM">PHPExcel_Calculation_Financial::ACCRINTM()</a><br> ACCRINTM</dd>
|
|
<dt><b>acosh</b></dt>
|
|
<dd>in file Functions.php, function <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Functions.php.html#functionacosh">acosh()</a></dd>
|
|
<dt><b>AMORDEGRC</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodAMORDEGRC">PHPExcel_Calculation_Financial::AMORDEGRC()</a><br> AMORDEGRC</dd>
|
|
<dt><b>AMORLINC</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodAMORLINC">PHPExcel_Calculation_Financial::AMORLINC()</a><br> AMORLINC</dd>
|
|
<dt><b>ASCIICODE</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodASCIICODE">PHPExcel_Calculation_TextData::ASCIICODE()</a><br> ASCIICODE</dd>
|
|
<dt><b>asinh</b></dt>
|
|
<dd>in file Functions.php, function <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Functions.php.html#functionasinh">asinh()</a></dd>
|
|
<dt><b>ATAN2</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodATAN2">PHPExcel_Calculation_MathTrig::ATAN2()</a><br> ATAN2</dd>
|
|
<dt><b>atanh</b></dt>
|
|
<dd>in file Functions.php, function <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Functions.php.html#functionatanh">atanh()</a></dd>
|
|
<dt><b>AVEDEV</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodAVEDEV">PHPExcel_Calculation_Statistical::AVEDEV()</a><br> AVEDEV</dd>
|
|
<dt><b>AVERAGE</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodAVERAGE">PHPExcel_Calculation_Statistical::AVERAGE()</a><br> AVERAGE</dd>
|
|
<dt><b>AVERAGEA</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodAVERAGEA">PHPExcel_Calculation_Statistical::AVERAGEA()</a><br> AVERAGEA</dd>
|
|
<dt><b>AVERAGEIF</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodAVERAGEIF">PHPExcel_Calculation_Statistical::AVERAGEIF()</a><br> AVERAGEIF</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="b"></a>
|
|
<div>
|
|
<h2>b</h2>
|
|
<dl>
|
|
<dt><b>BESSELI</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodBESSELI">PHPExcel_Calculation_Engineering::BESSELI()</a><br> BESSELI</dd>
|
|
<dt><b>BESSELJ</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodBESSELJ">PHPExcel_Calculation_Engineering::BESSELJ()</a><br> BESSELJ</dd>
|
|
<dt><b>BESSELK</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodBESSELK">PHPExcel_Calculation_Engineering::BESSELK()</a><br> BESSELK</dd>
|
|
<dt><b>BESSELY</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodBESSELY">PHPExcel_Calculation_Engineering::BESSELY()</a><br> BESSELY</dd>
|
|
<dt><b>BETADIST</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodBETADIST">PHPExcel_Calculation_Statistical::BETADIST()</a><br> BETADIST</dd>
|
|
<dt><b>BETAINV</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodBETAINV">PHPExcel_Calculation_Statistical::BETAINV()</a><br> BETAINV</dd>
|
|
<dt><b>BINOMDIST</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodBINOMDIST">PHPExcel_Calculation_Statistical::BINOMDIST()</a><br> BINOMDIST</dd>
|
|
<dt><b>BINTODEC</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodBINTODEC">PHPExcel_Calculation_Engineering::BINTODEC()</a><br> BINTODEC</dd>
|
|
<dt><b>BINTOHEX</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodBINTOHEX">PHPExcel_Calculation_Engineering::BINTOHEX()</a><br> BINTOHEX</dd>
|
|
<dt><b>BINTOOCT</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodBINTOOCT">PHPExcel_Calculation_Engineering::BINTOOCT()</a><br> BINTOOCT</dd>
|
|
<dt><b>BRACE_CLOSE</b></dt>
|
|
<dd>in file FormulaParser.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#constBRACE_CLOSE">PHPExcel_Calculation_FormulaParser::BRACE_CLOSE</a></dd>
|
|
<dt><b>BRACE_OPEN</b></dt>
|
|
<dd>in file FormulaParser.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#constBRACE_OPEN">PHPExcel_Calculation_FormulaParser::BRACE_OPEN</a></dd>
|
|
<dt><b>BRACKET_CLOSE</b></dt>
|
|
<dd>in file FormulaParser.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#constBRACKET_CLOSE">PHPExcel_Calculation_FormulaParser::BRACKET_CLOSE</a></dd>
|
|
<dt><b>BRACKET_OPEN</b></dt>
|
|
<dd>in file FormulaParser.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#constBRACKET_OPEN">PHPExcel_Calculation_FormulaParser::BRACKET_OPEN</a></dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="c"></a>
|
|
<div>
|
|
<h2>c</h2>
|
|
<dl>
|
|
<dt><b>$compatibilityMode</b></dt>
|
|
<dd>in file Functions.php, variable <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#var$compatibilityMode">PHPExcel_Calculation_Functions::$compatibilityMode</a><br> Compatibility mode to use for error checking and responses</dd>
|
|
<dt><b>$cyclicFormulaCount</b></dt>
|
|
<dd>in file Calculation.php, variable <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#var$cyclicFormulaCount">PHPExcel_Calculation::$cyclicFormulaCount</a></dd>
|
|
<dt><b>calculate</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodcalculate">PHPExcel_Calculation::calculate()</a><br> Calculate cell value (using formula from a cell ID) Retained for backward compatibility</dd>
|
|
<dt><b>calculateCellValue</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodcalculateCellValue">PHPExcel_Calculation::calculateCellValue()</a><br> Calculate the value of a cell formula</dd>
|
|
<dt><b>calculateFormula</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodcalculateFormula">PHPExcel_Calculation::calculateFormula()</a><br> Calculate the value of a formula</dd>
|
|
<dt><b>CALCULATION_REGEXP_CELLREF</b></dt>
|
|
<dd>in file Calculation.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#constCALCULATION_REGEXP_CELLREF">PHPExcel_Calculation::CALCULATION_REGEXP_CELLREF</a></dd>
|
|
<dt><b>CALCULATION_REGEXP_CELLREF</b></dt>
|
|
<dd>in file Calculation.php, constant <a href="PHPExcel_Calculation/_PHPExcel---Calculation.php.html#defineCALCULATION_REGEXP_CELLREF">CALCULATION_REGEXP_CELLREF</a></dd>
|
|
<dt><b>CALCULATION_REGEXP_ERROR</b></dt>
|
|
<dd>in file Calculation.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#constCALCULATION_REGEXP_ERROR">PHPExcel_Calculation::CALCULATION_REGEXP_ERROR</a></dd>
|
|
<dt><b>CALCULATION_REGEXP_FUNCTION</b></dt>
|
|
<dd>in file Calculation.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#constCALCULATION_REGEXP_FUNCTION">PHPExcel_Calculation::CALCULATION_REGEXP_FUNCTION</a></dd>
|
|
<dt><b>CALCULATION_REGEXP_NAMEDRANGE</b></dt>
|
|
<dd>in file Calculation.php, constant <a href="PHPExcel_Calculation/_PHPExcel---Calculation.php.html#defineCALCULATION_REGEXP_NAMEDRANGE">CALCULATION_REGEXP_NAMEDRANGE</a></dd>
|
|
<dt><b>CALCULATION_REGEXP_NAMEDRANGE</b></dt>
|
|
<dd>in file Calculation.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#constCALCULATION_REGEXP_NAMEDRANGE">PHPExcel_Calculation::CALCULATION_REGEXP_NAMEDRANGE</a></dd>
|
|
<dt><b>CALCULATION_REGEXP_NUMBER</b></dt>
|
|
<dd>in file Calculation.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#constCALCULATION_REGEXP_NUMBER">PHPExcel_Calculation::CALCULATION_REGEXP_NUMBER</a><br> Regular Expressions</dd>
|
|
<dt><b>CALCULATION_REGEXP_OPENBRACE</b></dt>
|
|
<dd>in file Calculation.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#constCALCULATION_REGEXP_OPENBRACE">PHPExcel_Calculation::CALCULATION_REGEXP_OPENBRACE</a></dd>
|
|
<dt><b>CALCULATION_REGEXP_STRING</b></dt>
|
|
<dd>in file Calculation.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#constCALCULATION_REGEXP_STRING">PHPExcel_Calculation::CALCULATION_REGEXP_STRING</a></dd>
|
|
<dt><b>CATEGORY_CUBE</b></dt>
|
|
<dd>in file Function.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#constCATEGORY_CUBE">PHPExcel_Calculation_Function::CATEGORY_CUBE</a></dd>
|
|
<dt><b>CATEGORY_DATABASE</b></dt>
|
|
<dd>in file Function.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#constCATEGORY_DATABASE">PHPExcel_Calculation_Function::CATEGORY_DATABASE</a></dd>
|
|
<dt><b>CATEGORY_DATE_AND_TIME</b></dt>
|
|
<dd>in file Function.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#constCATEGORY_DATE_AND_TIME">PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME</a></dd>
|
|
<dt><b>CATEGORY_ENGINEERING</b></dt>
|
|
<dd>in file Function.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#constCATEGORY_ENGINEERING">PHPExcel_Calculation_Function::CATEGORY_ENGINEERING</a></dd>
|
|
<dt><b>CATEGORY_FINANCIAL</b></dt>
|
|
<dd>in file Function.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#constCATEGORY_FINANCIAL">PHPExcel_Calculation_Function::CATEGORY_FINANCIAL</a></dd>
|
|
<dt><b>CATEGORY_INFORMATION</b></dt>
|
|
<dd>in file Function.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#constCATEGORY_INFORMATION">PHPExcel_Calculation_Function::CATEGORY_INFORMATION</a></dd>
|
|
<dt><b>CATEGORY_LOGICAL</b></dt>
|
|
<dd>in file Function.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#constCATEGORY_LOGICAL">PHPExcel_Calculation_Function::CATEGORY_LOGICAL</a></dd>
|
|
<dt><b>CATEGORY_LOOKUP_AND_REFERENCE</b></dt>
|
|
<dd>in file Function.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#constCATEGORY_LOOKUP_AND_REFERENCE">PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE</a></dd>
|
|
<dt><b>CATEGORY_MATH_AND_TRIG</b></dt>
|
|
<dd>in file Function.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#constCATEGORY_MATH_AND_TRIG">PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG</a></dd>
|
|
<dt><b>CATEGORY_STATISTICAL</b></dt>
|
|
<dd>in file Function.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#constCATEGORY_STATISTICAL">PHPExcel_Calculation_Function::CATEGORY_STATISTICAL</a></dd>
|
|
<dt><b>CATEGORY_TEXT_AND_DATA</b></dt>
|
|
<dd>in file Function.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#constCATEGORY_TEXT_AND_DATA">PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA</a></dd>
|
|
<dt><b>CEILING</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodCEILING">PHPExcel_Calculation_MathTrig::CEILING()</a><br> CEILING</dd>
|
|
<dt><b>CELL_ADDRESS</b></dt>
|
|
<dd>in file LookupRef.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html#methodCELL_ADDRESS">PHPExcel_Calculation_LookupRef::CELL_ADDRESS()</a><br> CELL_ADDRESS</dd>
|
|
<dt><b>CHARACTER</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodCHARACTER">PHPExcel_Calculation_TextData::CHARACTER()</a><br> CHARACTER</dd>
|
|
<dt><b>CHIDIST</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodCHIDIST">PHPExcel_Calculation_Statistical::CHIDIST()</a><br> CHIDIST</dd>
|
|
<dt><b>CHIINV</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodCHIINV">PHPExcel_Calculation_Statistical::CHIINV()</a><br> CHIINV</dd>
|
|
<dt><b>CHOOSE</b></dt>
|
|
<dd>in file LookupRef.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html#methodCHOOSE">PHPExcel_Calculation_LookupRef::CHOOSE()</a><br> CHOOSE</dd>
|
|
<dt><b>clearCalculationCache</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodclearCalculationCache">PHPExcel_Calculation::clearCalculationCache()</a><br> Clear calculation cache</dd>
|
|
<dt><b>COLUMN</b></dt>
|
|
<dd>in file LookupRef.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html#methodCOLUMN">PHPExcel_Calculation_LookupRef::COLUMN()</a><br> COLUMN</dd>
|
|
<dt><b>COLUMNS</b></dt>
|
|
<dd>in file LookupRef.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html#methodCOLUMNS">PHPExcel_Calculation_LookupRef::COLUMNS()</a><br> COLUMNS</dd>
|
|
<dt><b>COMBIN</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodCOMBIN">PHPExcel_Calculation_MathTrig::COMBIN()</a><br> COMBIN</dd>
|
|
<dt><b>COMMA</b></dt>
|
|
<dd>in file FormulaParser.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#constCOMMA">PHPExcel_Calculation_FormulaParser::COMMA</a></dd>
|
|
<dt><b>COMPATIBILITY_EXCEL</b></dt>
|
|
<dd>in file Functions.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#constCOMPATIBILITY_EXCEL">PHPExcel_Calculation_Functions::COMPATIBILITY_EXCEL</a><br> constants</dd>
|
|
<dt><b>COMPATIBILITY_GNUMERIC</b></dt>
|
|
<dd>in file Functions.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#constCOMPATIBILITY_GNUMERIC">PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC</a></dd>
|
|
<dt><b>COMPATIBILITY_OPENOFFICE</b></dt>
|
|
<dd>in file Functions.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#constCOMPATIBILITY_OPENOFFICE">PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE</a></dd>
|
|
<dt><b>COMPLEX</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodCOMPLEX">PHPExcel_Calculation_Engineering::COMPLEX()</a><br> COMPLEX</dd>
|
|
<dt><b>CONCATENATE</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodCONCATENATE">PHPExcel_Calculation_TextData::CONCATENATE()</a><br> CONCATENATE</dd>
|
|
<dt><b>CONFIDENCE</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodCONFIDENCE">PHPExcel_Calculation_Statistical::CONFIDENCE()</a><br> CONFIDENCE</dd>
|
|
<dt><b>CONVERTUOM</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodCONVERTUOM">PHPExcel_Calculation_Engineering::CONVERTUOM()</a><br> CONVERTUOM</dd>
|
|
<dt><b>CORREL</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodCORREL">PHPExcel_Calculation_Statistical::CORREL()</a><br> CORREL</dd>
|
|
<dt><b>COUNT</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodCOUNT">PHPExcel_Calculation_Statistical::COUNT()</a><br> COUNT</dd>
|
|
<dt><b>count</b></dt>
|
|
<dd>in file Stack.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Token_Stack.html#methodcount">PHPExcel_Calculation_Token_Stack::count()</a></dd>
|
|
<dt><b>COUNTA</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodCOUNTA">PHPExcel_Calculation_Statistical::COUNTA()</a><br> COUNTA</dd>
|
|
<dt><b>COUNTBLANK</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodCOUNTBLANK">PHPExcel_Calculation_Statistical::COUNTBLANK()</a><br> COUNTBLANK</dd>
|
|
<dt><b>COUNTIF</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodCOUNTIF">PHPExcel_Calculation_Statistical::COUNTIF()</a><br> COUNTIF</dd>
|
|
<dt><b>COUPDAYBS</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCOUPDAYBS">PHPExcel_Calculation_Financial::COUPDAYBS()</a><br> COUPDAYBS</dd>
|
|
<dt><b>COUPDAYS</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCOUPDAYS">PHPExcel_Calculation_Financial::COUPDAYS()</a><br> COUPDAYS</dd>
|
|
<dt><b>COUPDAYSNC</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCOUPDAYSNC">PHPExcel_Calculation_Financial::COUPDAYSNC()</a><br> COUPDAYSNC</dd>
|
|
<dt><b>COUPNCD</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCOUPNCD">PHPExcel_Calculation_Financial::COUPNCD()</a><br> COUPNCD</dd>
|
|
<dt><b>COUPNUM</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCOUPNUM">PHPExcel_Calculation_Financial::COUPNUM()</a><br> COUPNUM</dd>
|
|
<dt><b>COUPPCD</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCOUPPCD">PHPExcel_Calculation_Financial::COUPPCD()</a><br> COUPPCD</dd>
|
|
<dt><b>COVAR</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodCOVAR">PHPExcel_Calculation_Statistical::COVAR()</a><br> COVAR</dd>
|
|
<dt><b>CRITBINOM</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodCRITBINOM">PHPExcel_Calculation_Statistical::CRITBINOM()</a><br> CRITBINOM</dd>
|
|
<dt><b>CUMIPMT</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCUMIPMT">PHPExcel_Calculation_Financial::CUMIPMT()</a><br> CUMIPMT</dd>
|
|
<dt><b>CUMPRINC</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCUMPRINC">PHPExcel_Calculation_Financial::CUMPRINC()</a><br> CUMPRINC</dd>
|
|
<dt><b>Calculation.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation.php.html">Calculation.php</a></dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="d"></a>
|
|
<div>
|
|
<h2>d</h2>
|
|
<dl>
|
|
<dt><b>$debugLog</b></dt>
|
|
<dd>in file Calculation.php, variable <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#var$debugLog">PHPExcel_Calculation::$debugLog</a><br> The debug log generated by the calculation engine</dd>
|
|
<dt><b>DATE</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodDATE">PHPExcel_Calculation_DateTime::DATE()</a><br> DATE</dd>
|
|
<dt><b>DATEDIF</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodDATEDIF">PHPExcel_Calculation_DateTime::DATEDIF()</a><br> DATEDIF</dd>
|
|
<dt><b>DATENOW</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodDATENOW">PHPExcel_Calculation_DateTime::DATENOW()</a><br> DATENOW</dd>
|
|
<dt><b>DATETIMENOW</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodDATETIMENOW">PHPExcel_Calculation_DateTime::DATETIMENOW()</a><br> DATETIMENOW</dd>
|
|
<dt><b>DATEVALUE</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodDATEVALUE">PHPExcel_Calculation_DateTime::DATEVALUE()</a><br> DATEVALUE</dd>
|
|
<dt><b>DAVERAGE</b></dt>
|
|
<dd>in file Database.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Database.html#methodDAVERAGE">PHPExcel_Calculation_Database::DAVERAGE()</a><br> DAVERAGE</dd>
|
|
<dt><b>DAYOFMONTH</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodDAYOFMONTH">PHPExcel_Calculation_DateTime::DAYOFMONTH()</a><br> DAYOFMONTH</dd>
|
|
<dt><b>DAYOFWEEK</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodDAYOFWEEK">PHPExcel_Calculation_DateTime::DAYOFWEEK()</a><br> DAYOFWEEK</dd>
|
|
<dt><b>DAYS360</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodDAYS360">PHPExcel_Calculation_DateTime::DAYS360()</a><br> DAYS360</dd>
|
|
<dt><b>DB</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodDB">PHPExcel_Calculation_Financial::DB()</a><br> DB</dd>
|
|
<dt><b>DCOUNT</b></dt>
|
|
<dd>in file Database.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Database.html#methodDCOUNT">PHPExcel_Calculation_Database::DCOUNT()</a><br> DCOUNT</dd>
|
|
<dt><b>DCOUNTA</b></dt>
|
|
<dd>in file Database.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Database.html#methodDCOUNTA">PHPExcel_Calculation_Database::DCOUNTA()</a><br> DCOUNTA</dd>
|
|
<dt><b>DDB</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodDDB">PHPExcel_Calculation_Financial::DDB()</a><br> DDB</dd>
|
|
<dt><b>DECTOBIN</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodDECTOBIN">PHPExcel_Calculation_Engineering::DECTOBIN()</a><br> DECTOBIN</dd>
|
|
<dt><b>DECTOHEX</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodDECTOHEX">PHPExcel_Calculation_Engineering::DECTOHEX()</a><br> DECTOHEX</dd>
|
|
<dt><b>DECTOOCT</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodDECTOOCT">PHPExcel_Calculation_Engineering::DECTOOCT()</a><br> DECTOOCT</dd>
|
|
<dt><b>DELTA</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodDELTA">PHPExcel_Calculation_Engineering::DELTA()</a><br> DELTA</dd>
|
|
<dt><b>DEVSQ</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodDEVSQ">PHPExcel_Calculation_Statistical::DEVSQ()</a><br> DEVSQ</dd>
|
|
<dt><b>DGET</b></dt>
|
|
<dd>in file Database.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Database.html#methodDGET">PHPExcel_Calculation_Database::DGET()</a><br> DGET</dd>
|
|
<dt><b>disableCalculationCache</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methoddisableCalculationCache">PHPExcel_Calculation::disableCalculationCache()</a><br> Disable calculation cache</dd>
|
|
<dt><b>DISC</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodDISC">PHPExcel_Calculation_Financial::DISC()</a><br> DISC</dd>
|
|
<dt><b>DIV0</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodDIV0">PHPExcel_Calculation_Functions::DIV0()</a><br> DIV0</dd>
|
|
<dt><b>DMAX</b></dt>
|
|
<dd>in file Database.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Database.html#methodDMAX">PHPExcel_Calculation_Database::DMAX()</a><br> DMAX</dd>
|
|
<dt><b>DMIN</b></dt>
|
|
<dd>in file Database.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Database.html#methodDMIN">PHPExcel_Calculation_Database::DMIN()</a><br> DMIN</dd>
|
|
<dt><b>DOLLAR</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodDOLLAR">PHPExcel_Calculation_TextData::DOLLAR()</a><br> DOLLAR</dd>
|
|
<dt><b>DOLLARDE</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodDOLLARDE">PHPExcel_Calculation_Financial::DOLLARDE()</a><br> DOLLARDE</dd>
|
|
<dt><b>DOLLARFR</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodDOLLARFR">PHPExcel_Calculation_Financial::DOLLARFR()</a><br> DOLLARFR</dd>
|
|
<dt><b>DPRODUCT</b></dt>
|
|
<dd>in file Database.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Database.html#methodDPRODUCT">PHPExcel_Calculation_Database::DPRODUCT()</a><br> DPRODUCT</dd>
|
|
<dt><b>DSTDEV</b></dt>
|
|
<dd>in file Database.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Database.html#methodDSTDEV">PHPExcel_Calculation_Database::DSTDEV()</a><br> DSTDEV</dd>
|
|
<dt><b>DSTDEVP</b></dt>
|
|
<dd>in file Database.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Database.html#methodDSTDEVP">PHPExcel_Calculation_Database::DSTDEVP()</a><br> DSTDEVP</dd>
|
|
<dt><b>DSUM</b></dt>
|
|
<dd>in file Database.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Database.html#methodDSUM">PHPExcel_Calculation_Database::DSUM()</a><br> DSUM</dd>
|
|
<dt><b>DUMMY</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodDUMMY">PHPExcel_Calculation_Functions::DUMMY()</a><br> DUMMY</dd>
|
|
<dt><b>DVAR</b></dt>
|
|
<dd>in file Database.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Database.html#methodDVAR">PHPExcel_Calculation_Database::DVAR()</a><br> DVAR</dd>
|
|
<dt><b>DVARP</b></dt>
|
|
<dd>in file Database.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Database.html#methodDVARP">PHPExcel_Calculation_Database::DVARP()</a><br> DVARP</dd>
|
|
<dt><b>Database.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Database.php.html">Database.php</a></dd>
|
|
<dt><b>DateTime.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---DateTime.php.html">DateTime.php</a></dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="e"></a>
|
|
<div>
|
|
<h2>e</h2>
|
|
<dl>
|
|
<dt><b>$echoDebugLog</b></dt>
|
|
<dd>in file Calculation.php, variable <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#var$echoDebugLog">PHPExcel_Calculation::$echoDebugLog</a><br> Flag to determine whether a debug log should be echoed by the calculation engine</dd>
|
|
<dt><b>EDATE</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodEDATE">PHPExcel_Calculation_DateTime::EDATE()</a><br> EDATE</dd>
|
|
<dt><b>EFFECT</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodEFFECT">PHPExcel_Calculation_Financial::EFFECT()</a><br> EFFECT</dd>
|
|
<dt><b>enableCalculationCache</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodenableCalculationCache">PHPExcel_Calculation::enableCalculationCache()</a><br> Enable calculation cache</dd>
|
|
<dt><b>EOMONTH</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodEOMONTH">PHPExcel_Calculation_DateTime::EOMONTH()</a><br> EOMONTH</dd>
|
|
<dt><b>EPS</b></dt>
|
|
<dd>in file Statistical.php, constant <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Statistical.php.html#defineEPS">EPS</a><br> EPS</dd>
|
|
<dt><b>ERF</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodERF">PHPExcel_Calculation_Engineering::ERF()</a><br> ERF</dd>
|
|
<dt><b>ERFC</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodERFC">PHPExcel_Calculation_Engineering::ERFC()</a><br> ERFC</dd>
|
|
<dt><b>errorHandlerCallback</b></dt>
|
|
<dd>in file Exception.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Exception.html#methoderrorHandlerCallback">PHPExcel_Calculation_Exception::errorHandlerCallback()</a><br> Error handler callback</dd>
|
|
<dt><b>ERROR_START</b></dt>
|
|
<dd>in file FormulaParser.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#constERROR_START">PHPExcel_Calculation_FormulaParser::ERROR_START</a></dd>
|
|
<dt><b>ERROR_TYPE</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodERROR_TYPE">PHPExcel_Calculation_Functions::ERROR_TYPE()</a><br> ERROR_TYPE</dd>
|
|
<dt><b>EULER</b></dt>
|
|
<dd>in file Engineering.php, constant <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Engineering.php.html#defineEULER">EULER</a><br> EULER</dd>
|
|
<dt><b>EVEN</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodEVEN">PHPExcel_Calculation_MathTrig::EVEN()</a><br> EVEN</dd>
|
|
<dt><b>EXPONDIST</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodEXPONDIST">PHPExcel_Calculation_Statistical::EXPONDIST()</a><br> EXPONDIST</dd>
|
|
<dt><b>extractCellRange</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodextractCellRange">PHPExcel_Calculation::extractCellRange()</a><br> Extract range values</dd>
|
|
<dt><b>extractNamedRange</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodextractNamedRange">PHPExcel_Calculation::extractNamedRange()</a><br> Extract range values</dd>
|
|
<dt><b>Engineering.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Engineering.php.html">Engineering.php</a></dd>
|
|
<dt><b>Exception.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Exception.php.html">Exception.php</a></dd>
|
|
<dt><b>ExceptionHandler.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---ExceptionHandler.php.html">ExceptionHandler.php</a></dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="f"></a>
|
|
<div>
|
|
<h2>f</h2>
|
|
<dl>
|
|
<dt><b>$formulaError</b></dt>
|
|
<dd>in file Calculation.php, variable <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#var$formulaError">PHPExcel_Calculation::$formulaError</a><br> Error message for any error that was raised/thrown by the calculation engine</dd>
|
|
<dt><b>FACT</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodFACT">PHPExcel_Calculation_MathTrig::FACT()</a><br> FACT</dd>
|
|
<dt><b>FACTDOUBLE</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodFACTDOUBLE">PHPExcel_Calculation_MathTrig::FACTDOUBLE()</a><br> FACTDOUBLE</dd>
|
|
<dt><b>FALSE</b></dt>
|
|
<dd>in file Logical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Logical.html#methodFALSE">PHPExcel_Calculation_Logical::FALSE()</a><br> FALSE</dd>
|
|
<dt><b>FINANCIAL_MAX_ITERATIONS</b></dt>
|
|
<dd>in file Financial.php, constant <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Financial.php.html#defineFINANCIAL_MAX_ITERATIONS">FINANCIAL_MAX_ITERATIONS</a><br> FINANCIAL_MAX_ITERATIONS</dd>
|
|
<dt><b>FINANCIAL_PRECISION</b></dt>
|
|
<dd>in file Financial.php, constant <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Financial.php.html#defineFINANCIAL_PRECISION">FINANCIAL_PRECISION</a><br> FINANCIAL_PRECISION</dd>
|
|
<dt><b>FISHER</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodFISHER">PHPExcel_Calculation_Statistical::FISHER()</a><br> FISHER</dd>
|
|
<dt><b>FISHERINV</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodFISHERINV">PHPExcel_Calculation_Statistical::FISHERINV()</a><br> FISHERINV</dd>
|
|
<dt><b>FIXEDFORMAT</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodFIXEDFORMAT">PHPExcel_Calculation_TextData::FIXEDFORMAT()</a><br> FIXEDFORMAT</dd>
|
|
<dt><b>flattenArray</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodflattenArray">PHPExcel_Calculation_Functions::flattenArray()</a><br> Convert a multi-dimensional array to a simple 1-dimensional array</dd>
|
|
<dt><b>flattenArrayIndexed</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodflattenArrayIndexed">PHPExcel_Calculation_Functions::flattenArrayIndexed()</a><br> Convert a multi-dimensional array to a simple 1-dimensional array, but retain an element of indexing</dd>
|
|
<dt><b>flattenSingleValue</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodflattenSingleValue">PHPExcel_Calculation_Functions::flattenSingleValue()</a><br> Convert an array to a single scalar value by extracting the first element</dd>
|
|
<dt><b>FLOOR</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodFLOOR">PHPExcel_Calculation_MathTrig::FLOOR()</a><br> FLOOR</dd>
|
|
<dt><b>flushInstance</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodflushInstance">PHPExcel_Calculation::flushInstance()</a><br> Flush the calculation cache for any existing instance of this class but only if a PHPExcel_Calculation instance exists</dd>
|
|
<dt><b>FORECAST</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodFORECAST">PHPExcel_Calculation_Statistical::FORECAST()</a><br> FORECAST</dd>
|
|
<dt><b>FV</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodFV">PHPExcel_Calculation_Financial::FV()</a><br> FV</dd>
|
|
<dt><b>FVSCHEDULE</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodFVSCHEDULE">PHPExcel_Calculation_Financial::FVSCHEDULE()</a><br> FVSCHEDULE</dd>
|
|
<dt><b>Financial.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Financial.php.html">Financial.php</a></dd>
|
|
<dt><b>FormulaParser.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---FormulaParser.php.html">FormulaParser.php</a></dd>
|
|
<dt><b>FormulaToken.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---FormulaToken.php.html">FormulaToken.php</a></dd>
|
|
<dt><b>Function.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Function.php.html">Function.php</a></dd>
|
|
<dt><b>Functions.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Functions.php.html">Functions.php</a></dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="g"></a>
|
|
<div>
|
|
<h2>g</h2>
|
|
<dl>
|
|
<dt><b>GAMMADIST</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodGAMMADIST">PHPExcel_Calculation_Statistical::GAMMADIST()</a><br> GAMMADIST</dd>
|
|
<dt><b>GAMMAINV</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodGAMMAINV">PHPExcel_Calculation_Statistical::GAMMAINV()</a><br> GAMMAINV</dd>
|
|
<dt><b>GAMMALN</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodGAMMALN">PHPExcel_Calculation_Statistical::GAMMALN()</a><br> GAMMALN</dd>
|
|
<dt><b>GCD</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodGCD">PHPExcel_Calculation_MathTrig::GCD()</a><br> GCD</dd>
|
|
<dt><b>GEOMEAN</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodGEOMEAN">PHPExcel_Calculation_Statistical::GEOMEAN()</a><br> GEOMEAN</dd>
|
|
<dt><b>GESTEP</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodGESTEP">PHPExcel_Calculation_Engineering::GESTEP()</a><br> GESTEP</dd>
|
|
<dt><b>getArrayReturnType</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodgetArrayReturnType">PHPExcel_Calculation::getArrayReturnType()</a><br> Return the Array Return Type (Array or Value of first element in the array)</dd>
|
|
<dt><b>getCalculationCacheEnabled</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodgetCalculationCacheEnabled">PHPExcel_Calculation::getCalculationCacheEnabled()</a><br> Is calculation caching enabled?</dd>
|
|
<dt><b>getCalculationCacheExpirationTime</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodgetCalculationCacheExpirationTime">PHPExcel_Calculation::getCalculationCacheExpirationTime()</a><br> Get calculation cache expiration time</dd>
|
|
<dt><b>getCategory</b></dt>
|
|
<dd>in file Function.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#methodgetCategory">PHPExcel_Calculation_Function::getCategory()</a><br> Get Category (represented by CATEGORY_*)</dd>
|
|
<dt><b>getCompatibilityMode</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodgetCompatibilityMode">PHPExcel_Calculation_Functions::getCompatibilityMode()</a><br> Return the current Compatibility Mode</dd>
|
|
<dt><b>getConversionGroups</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodgetConversionGroups">PHPExcel_Calculation_Engineering::getConversionGroups()</a><br> getConversionGroups Returns a list of the different conversion groups for UOM conversions</dd>
|
|
<dt><b>getConversionGroupUnitDetails</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodgetConversionGroupUnitDetails">PHPExcel_Calculation_Engineering::getConversionGroupUnitDetails()</a><br> getConversionGroupUnitDetails</dd>
|
|
<dt><b>getConversionGroupUnits</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodgetConversionGroupUnits">PHPExcel_Calculation_Engineering::getConversionGroupUnits()</a><br> getConversionGroupUnits Returns an array of units of measure, for a specified conversion group, or for all groups</dd>
|
|
<dt><b>getConversionMultipliers</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodgetConversionMultipliers">PHPExcel_Calculation_Engineering::getConversionMultipliers()</a><br> getConversionMultipliers Returns an array of the Multiplier prefixes that can be used with Units of Measure in CONVERTUOM()</dd>
|
|
<dt><b>getExcelName</b></dt>
|
|
<dd>in file Function.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#methodgetExcelName">PHPExcel_Calculation_Function::getExcelName()</a><br> Get Excel name</dd>
|
|
<dt><b>getFALSE</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodgetFALSE">PHPExcel_Calculation::getFALSE()</a><br> Return the locale-specific translation of FALSE</dd>
|
|
<dt><b>getFormula</b></dt>
|
|
<dd>in file FormulaParser.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#methodgetFormula">PHPExcel_Calculation_FormulaParser::getFormula()</a><br> Get Formula</dd>
|
|
<dt><b>getInstance</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodgetInstance">PHPExcel_Calculation::getInstance()</a><br> Get an instance of this class</dd>
|
|
<dt><b>getLocale</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodgetLocale">PHPExcel_Calculation::getLocale()</a><br> Get the currently defined locale code</dd>
|
|
<dt><b>getPHPExcelName</b></dt>
|
|
<dd>in file Function.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#methodgetPHPExcelName">PHPExcel_Calculation_Function::getPHPExcelName()</a><br> Get PHPExcel name</dd>
|
|
<dt><b>getReturnDateType</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodgetReturnDateType">PHPExcel_Calculation_Functions::getReturnDateType()</a><br> Return the current Return Date Format for functions that return a date/time (Excel, PHP Serialized Numeric or PHP Object)</dd>
|
|
<dt><b>getToken</b></dt>
|
|
<dd>in file FormulaParser.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#methodgetToken">PHPExcel_Calculation_FormulaParser::getToken()</a><br> Get Token</dd>
|
|
<dt><b>getTokenCount</b></dt>
|
|
<dd>in file FormulaParser.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#methodgetTokenCount">PHPExcel_Calculation_FormulaParser::getTokenCount()</a><br> Get Token count</dd>
|
|
<dt><b>getTokens</b></dt>
|
|
<dd>in file FormulaParser.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#methodgetTokens">PHPExcel_Calculation_FormulaParser::getTokens()</a><br> Get Tokens</dd>
|
|
<dt><b>getTokenSubType</b></dt>
|
|
<dd>in file FormulaToken.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#methodgetTokenSubType">PHPExcel_Calculation_FormulaToken::getTokenSubType()</a><br> Get Token SubType (represented by TOKEN_SUBTYPE_*)</dd>
|
|
<dt><b>getTokenType</b></dt>
|
|
<dd>in file FormulaToken.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#methodgetTokenType">PHPExcel_Calculation_FormulaToken::getTokenType()</a><br> Get Token Type (represented by TOKEN_TYPE_*)</dd>
|
|
<dt><b>getTRUE</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodgetTRUE">PHPExcel_Calculation::getTRUE()</a><br> Return the locale-specific translation of TRUE</dd>
|
|
<dt><b>getValue</b></dt>
|
|
<dd>in file FormulaToken.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#methodgetValue">PHPExcel_Calculation_FormulaToken::getValue()</a><br> Get Value</dd>
|
|
<dt><b>GROWTH</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodGROWTH">PHPExcel_Calculation_Statistical::GROWTH()</a><br> GROWTH</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="h"></a>
|
|
<div>
|
|
<h2>h</h2>
|
|
<dl>
|
|
<dt><b>HARMEAN</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodHARMEAN">PHPExcel_Calculation_Statistical::HARMEAN()</a><br> HARMEAN</dd>
|
|
<dt><b>HEXTOBIN</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodHEXTOBIN">PHPExcel_Calculation_Engineering::HEXTOBIN()</a><br> HEXTOBIN</dd>
|
|
<dt><b>HEXTODEC</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodHEXTODEC">PHPExcel_Calculation_Engineering::HEXTODEC()</a><br> HEXTODEC</dd>
|
|
<dt><b>HEXTOOCT</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodHEXTOOCT">PHPExcel_Calculation_Engineering::HEXTOOCT()</a><br> HEXTOOCT</dd>
|
|
<dt><b>HOUROFDAY</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodHOUROFDAY">PHPExcel_Calculation_DateTime::HOUROFDAY()</a><br> HOUROFDAY</dd>
|
|
<dt><b>HYPERLINK</b></dt>
|
|
<dd>in file LookupRef.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html#methodHYPERLINK">PHPExcel_Calculation_LookupRef::HYPERLINK()</a><br> HYPERLINK</dd>
|
|
<dt><b>HYPGEOMDIST</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodHYPGEOMDIST">PHPExcel_Calculation_Statistical::HYPGEOMDIST()</a><br> HYPGEOMDIST</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="i"></a>
|
|
<div>
|
|
<h2>i</h2>
|
|
<dl>
|
|
<dt><b>IFERROR</b></dt>
|
|
<dd>in file Logical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Logical.html#methodIFERROR">PHPExcel_Calculation_Logical::IFERROR()</a><br> IFERROR</dd>
|
|
<dt><b>IMABS</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMABS">PHPExcel_Calculation_Engineering::IMABS()</a><br> IMABS</dd>
|
|
<dt><b>IMAGINARY</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMAGINARY">PHPExcel_Calculation_Engineering::IMAGINARY()</a><br> IMAGINARY</dd>
|
|
<dt><b>IMARGUMENT</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMARGUMENT">PHPExcel_Calculation_Engineering::IMARGUMENT()</a><br> IMARGUMENT</dd>
|
|
<dt><b>IMCONJUGATE</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMCONJUGATE">PHPExcel_Calculation_Engineering::IMCONJUGATE()</a><br> IMCONJUGATE</dd>
|
|
<dt><b>IMCOS</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMCOS">PHPExcel_Calculation_Engineering::IMCOS()</a><br> IMCOS</dd>
|
|
<dt><b>IMDIV</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMDIV">PHPExcel_Calculation_Engineering::IMDIV()</a><br> IMDIV</dd>
|
|
<dt><b>IMEXP</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMEXP">PHPExcel_Calculation_Engineering::IMEXP()</a><br> IMEXP</dd>
|
|
<dt><b>IMLN</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMLN">PHPExcel_Calculation_Engineering::IMLN()</a><br> IMLN</dd>
|
|
<dt><b>IMLOG2</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMLOG2">PHPExcel_Calculation_Engineering::IMLOG2()</a><br> IMLOG2</dd>
|
|
<dt><b>IMLOG10</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMLOG10">PHPExcel_Calculation_Engineering::IMLOG10()</a><br> IMLOG10</dd>
|
|
<dt><b>IMPOWER</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMPOWER">PHPExcel_Calculation_Engineering::IMPOWER()</a><br> IMPOWER</dd>
|
|
<dt><b>IMPRODUCT</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMPRODUCT">PHPExcel_Calculation_Engineering::IMPRODUCT()</a><br> IMPRODUCT</dd>
|
|
<dt><b>IMREAL</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMREAL">PHPExcel_Calculation_Engineering::IMREAL()</a><br> IMREAL</dd>
|
|
<dt><b>IMSIN</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMSIN">PHPExcel_Calculation_Engineering::IMSIN()</a><br> IMSIN</dd>
|
|
<dt><b>IMSQRT</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMSQRT">PHPExcel_Calculation_Engineering::IMSQRT()</a><br> IMSQRT</dd>
|
|
<dt><b>IMSUB</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMSUB">PHPExcel_Calculation_Engineering::IMSUB()</a><br> IMSUB</dd>
|
|
<dt><b>IMSUM</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodIMSUM">PHPExcel_Calculation_Engineering::IMSUM()</a><br> IMSUM</dd>
|
|
<dt><b>INDEX</b></dt>
|
|
<dd>in file LookupRef.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html#methodINDEX">PHPExcel_Calculation_LookupRef::INDEX()</a><br> INDEX</dd>
|
|
<dt><b>INDIRECT</b></dt>
|
|
<dd>in file LookupRef.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html#methodINDIRECT">PHPExcel_Calculation_LookupRef::INDIRECT()</a><br> INDIRECT</dd>
|
|
<dt><b>INT</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodINT">PHPExcel_Calculation_MathTrig::INT()</a><br> INT</dd>
|
|
<dt><b>INTERCEPT</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodINTERCEPT">PHPExcel_Calculation_Statistical::INTERCEPT()</a><br> INTERCEPT</dd>
|
|
<dt><b>INTRATE</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodINTRATE">PHPExcel_Calculation_Financial::INTRATE()</a><br> INTRATE</dd>
|
|
<dt><b>IPMT</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodIPMT">PHPExcel_Calculation_Financial::IPMT()</a><br> IPMT</dd>
|
|
<dt><b>IRR</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodIRR">PHPExcel_Calculation_Financial::IRR()</a></dd>
|
|
<dt><b>isCellValue</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodisCellValue">PHPExcel_Calculation_Functions::isCellValue()</a></dd>
|
|
<dt><b>isImplemented</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodisImplemented">PHPExcel_Calculation::isImplemented()</a><br> Is a specific function implemented?</dd>
|
|
<dt><b>isMatrixValue</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodisMatrixValue">PHPExcel_Calculation_Functions::isMatrixValue()</a></dd>
|
|
<dt><b>ISPMT</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodISPMT">PHPExcel_Calculation_Financial::ISPMT()</a><br> ISPMT</dd>
|
|
<dt><b>isValue</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodisValue">PHPExcel_Calculation_Functions::isValue()</a></dd>
|
|
<dt><b>IS_BLANK</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodIS_BLANK">PHPExcel_Calculation_Functions::IS_BLANK()</a><br> IS_BLANK</dd>
|
|
<dt><b>IS_ERR</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodIS_ERR">PHPExcel_Calculation_Functions::IS_ERR()</a><br> IS_ERR</dd>
|
|
<dt><b>IS_ERROR</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodIS_ERROR">PHPExcel_Calculation_Functions::IS_ERROR()</a><br> IS_ERROR</dd>
|
|
<dt><b>IS_EVEN</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodIS_EVEN">PHPExcel_Calculation_Functions::IS_EVEN()</a><br> IS_EVEN</dd>
|
|
<dt><b>IS_LOGICAL</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodIS_LOGICAL">PHPExcel_Calculation_Functions::IS_LOGICAL()</a><br> IS_LOGICAL</dd>
|
|
<dt><b>IS_NA</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodIS_NA">PHPExcel_Calculation_Functions::IS_NA()</a><br> IS_NA</dd>
|
|
<dt><b>IS_NONTEXT</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodIS_NONTEXT">PHPExcel_Calculation_Functions::IS_NONTEXT()</a><br> IS_NONTEXT</dd>
|
|
<dt><b>IS_NUMBER</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodIS_NUMBER">PHPExcel_Calculation_Functions::IS_NUMBER()</a><br> IS_NUMBER</dd>
|
|
<dt><b>IS_ODD</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodIS_ODD">PHPExcel_Calculation_Functions::IS_ODD()</a><br> IS_ODD</dd>
|
|
<dt><b>IS_TEXT</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodIS_TEXT">PHPExcel_Calculation_Functions::IS_TEXT()</a><br> IS_TEXT</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="k"></a>
|
|
<div>
|
|
<h2>k</h2>
|
|
<dl>
|
|
<dt><b>KURT</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodKURT">PHPExcel_Calculation_Statistical::KURT()</a><br> KURT</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="l"></a>
|
|
<div>
|
|
<h2>l</h2>
|
|
<dl>
|
|
<dt><b>LARGE</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodLARGE">PHPExcel_Calculation_Statistical::LARGE()</a><br> LARGE</dd>
|
|
<dt><b>last</b></dt>
|
|
<dd>in file Stack.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Token_Stack.html#methodlast">PHPExcel_Calculation_Token_Stack::last()</a></dd>
|
|
<dt><b>LCM</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodLCM">PHPExcel_Calculation_MathTrig::LCM()</a><br> LCM</dd>
|
|
<dt><b>LEFT</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodLEFT">PHPExcel_Calculation_TextData::LEFT()</a><br> LEFT</dd>
|
|
<dt><b>LINEST</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodLINEST">PHPExcel_Calculation_Statistical::LINEST()</a><br> LINEST</dd>
|
|
<dt><b>listAllFunctionNames</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodlistAllFunctionNames">PHPExcel_Calculation::listAllFunctionNames()</a><br> Get a list of all Excel function names</dd>
|
|
<dt><b>listFunctionNames</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodlistFunctionNames">PHPExcel_Calculation::listFunctionNames()</a><br> Get a list of implemented Excel function names</dd>
|
|
<dt><b>listFunctions</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodlistFunctions">PHPExcel_Calculation::listFunctions()</a><br> Get a list of all implemented functions as an array of function objects</dd>
|
|
<dt><b>LOGEST</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodLOGEST">PHPExcel_Calculation_Statistical::LOGEST()</a><br> LOGEST</dd>
|
|
<dt><b>LOGICAL_AND</b></dt>
|
|
<dd>in file Logical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Logical.html#methodLOGICAL_AND">PHPExcel_Calculation_Logical::LOGICAL_AND()</a><br> LOGICAL_AND</dd>
|
|
<dt><b>LOGICAL_OR</b></dt>
|
|
<dd>in file Logical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Logical.html#methodLOGICAL_OR">PHPExcel_Calculation_Logical::LOGICAL_OR()</a><br> LOGICAL_OR</dd>
|
|
<dt><b>LOGINV</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodLOGINV">PHPExcel_Calculation_Statistical::LOGINV()</a><br> LOGINV</dd>
|
|
<dt><b>LOGNORMDIST</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodLOGNORMDIST">PHPExcel_Calculation_Statistical::LOGNORMDIST()</a><br> LOGNORMDIST</dd>
|
|
<dt><b>LOG_BASE</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodLOG_BASE">PHPExcel_Calculation_MathTrig::LOG_BASE()</a><br> LOG_BASE</dd>
|
|
<dt><b>LOG_GAMMA_X_MAX_VALUE</b></dt>
|
|
<dd>in file Statistical.php, constant <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Statistical.php.html#defineLOG_GAMMA_X_MAX_VALUE">LOG_GAMMA_X_MAX_VALUE</a><br> LOG_GAMMA_X_MAX_VALUE</dd>
|
|
<dt><b>LOOKUP</b></dt>
|
|
<dd>in file LookupRef.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html#methodLOOKUP">PHPExcel_Calculation_LookupRef::LOOKUP()</a><br> LOOKUP The LOOKUP function searches for value either from a one-row or one-column range or from an array.</dd>
|
|
<dt><b>LOWERCASE</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodLOWERCASE">PHPExcel_Calculation_TextData::LOWERCASE()</a><br> LOWERCASE</dd>
|
|
<dt><b>Logical.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Logical.php.html">Logical.php</a></dd>
|
|
<dt><b>LookupRef.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---LookupRef.php.html">LookupRef.php</a></dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="m"></a>
|
|
<div>
|
|
<h2>m</h2>
|
|
<dl>
|
|
<dt><b>MATCH</b></dt>
|
|
<dd>in file LookupRef.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html#methodMATCH">PHPExcel_Calculation_LookupRef::MATCH()</a><br> MATCH</dd>
|
|
<dt><b>MAX</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodMAX">PHPExcel_Calculation_Statistical::MAX()</a><br> MAX</dd>
|
|
<dt><b>MAXA</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodMAXA">PHPExcel_Calculation_Statistical::MAXA()</a><br> MAXA</dd>
|
|
<dt><b>MAXIF</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodMAXIF">PHPExcel_Calculation_Statistical::MAXIF()</a><br> MAXIF</dd>
|
|
<dt><b>MAX_ITERATIONS</b></dt>
|
|
<dd>in file Functions.php, constant <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Functions.php.html#defineMAX_ITERATIONS">MAX_ITERATIONS</a><br> MAX_ITERATIONS</dd>
|
|
<dt><b>MAX_VALUE</b></dt>
|
|
<dd>in file Functions.php, constant <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Functions.php.html#defineMAX_VALUE">MAX_VALUE</a><br> MAX_VALUE</dd>
|
|
<dt><b>mb_str_replace</b></dt>
|
|
<dd>in file Functions.php, function <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Functions.php.html#functionmb_str_replace">mb_str_replace()</a></dd>
|
|
<dt><b>MDETERM</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodMDETERM">PHPExcel_Calculation_MathTrig::MDETERM()</a><br> MDETERM</dd>
|
|
<dt><b>MEDIAN</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodMEDIAN">PHPExcel_Calculation_Statistical::MEDIAN()</a><br> MEDIAN</dd>
|
|
<dt><b>MID</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodMID">PHPExcel_Calculation_TextData::MID()</a><br> MID</dd>
|
|
<dt><b>MIN</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodMIN">PHPExcel_Calculation_Statistical::MIN()</a><br> MIN</dd>
|
|
<dt><b>MINA</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodMINA">PHPExcel_Calculation_Statistical::MINA()</a><br> MINA</dd>
|
|
<dt><b>MINIF</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodMINIF">PHPExcel_Calculation_Statistical::MINIF()</a><br> MINIF</dd>
|
|
<dt><b>MINUTEOFHOUR</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodMINUTEOFHOUR">PHPExcel_Calculation_DateTime::MINUTEOFHOUR()</a><br> MINUTEOFHOUR</dd>
|
|
<dt><b>MINVERSE</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodMINVERSE">PHPExcel_Calculation_MathTrig::MINVERSE()</a><br> MINVERSE</dd>
|
|
<dt><b>MIRR</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodMIRR">PHPExcel_Calculation_Financial::MIRR()</a></dd>
|
|
<dt><b>MMULT</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodMMULT">PHPExcel_Calculation_MathTrig::MMULT()</a><br> MMULT</dd>
|
|
<dt><b>MOD</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodMOD">PHPExcel_Calculation_MathTrig::MOD()</a><br> MOD</dd>
|
|
<dt><b>MODE</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodMODE">PHPExcel_Calculation_Statistical::MODE()</a><br> MODE</dd>
|
|
<dt><b>money_format</b></dt>
|
|
<dd>in file Functions.php, function <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Functions.php.html#functionmoney_format">money_format()</a></dd>
|
|
<dt><b>MONTHOFYEAR</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodMONTHOFYEAR">PHPExcel_Calculation_DateTime::MONTHOFYEAR()</a><br> MONTHOFYEAR</dd>
|
|
<dt><b>MROUND</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodMROUND">PHPExcel_Calculation_MathTrig::MROUND()</a><br> MROUND</dd>
|
|
<dt><b>MULTINOMIAL</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodMULTINOMIAL">PHPExcel_Calculation_MathTrig::MULTINOMIAL()</a><br> MULTINOMIAL</dd>
|
|
<dt><b>M_2DIVPI</b></dt>
|
|
<dd>in file Functions.php, constant <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Functions.php.html#defineM_2DIVPI">M_2DIVPI</a><br> 2 / PI</dd>
|
|
<dt><b>MathTrig.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---MathTrig.php.html">MathTrig.php</a></dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="n"></a>
|
|
<div>
|
|
<h2>n</h2>
|
|
<dl>
|
|
<dt><b>N</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodN">PHPExcel_Calculation_Functions::N()</a><br> N</dd>
|
|
<dt><b>NA</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodNA">PHPExcel_Calculation_Functions::NA()</a><br> NA</dd>
|
|
<dt><b>NAME</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodNAME">PHPExcel_Calculation_Functions::NAME()</a><br> NAME</dd>
|
|
<dt><b>NaN</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodNaN">PHPExcel_Calculation_Functions::NaN()</a><br> NaN</dd>
|
|
<dt><b>NEGBINOMDIST</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodNEGBINOMDIST">PHPExcel_Calculation_Statistical::NEGBINOMDIST()</a><br> NEGBINOMDIST</dd>
|
|
<dt><b>NETWORKDAYS</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodNETWORKDAYS">PHPExcel_Calculation_DateTime::NETWORKDAYS()</a><br> NETWORKDAYS</dd>
|
|
<dt><b>NOMINAL</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodNOMINAL">PHPExcel_Calculation_Financial::NOMINAL()</a><br> NOMINAL</dd>
|
|
<dt><b>NORMDIST</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodNORMDIST">PHPExcel_Calculation_Statistical::NORMDIST()</a><br> NORMDIST</dd>
|
|
<dt><b>NORMINV</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodNORMINV">PHPExcel_Calculation_Statistical::NORMINV()</a><br> NORMINV</dd>
|
|
<dt><b>NORMSDIST</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodNORMSDIST">PHPExcel_Calculation_Statistical::NORMSDIST()</a><br> NORMSDIST</dd>
|
|
<dt><b>NORMSINV</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodNORMSINV">PHPExcel_Calculation_Statistical::NORMSINV()</a><br> NORMSINV</dd>
|
|
<dt><b>NOT</b></dt>
|
|
<dd>in file Logical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Logical.html#methodNOT">PHPExcel_Calculation_Logical::NOT()</a><br> NOT</dd>
|
|
<dt><b>NPER</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodNPER">PHPExcel_Calculation_Financial::NPER()</a><br> NPER</dd>
|
|
<dt><b>NPV</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodNPV">PHPExcel_Calculation_Financial::NPV()</a><br> NPV</dd>
|
|
<dt><b>NULL</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodNULL">PHPExcel_Calculation_Functions::NULL()</a><br> NULL</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="o"></a>
|
|
<div>
|
|
<h2>o</h2>
|
|
<dl>
|
|
<dt><b>OCTTOBIN</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodOCTTOBIN">PHPExcel_Calculation_Engineering::OCTTOBIN()</a><br> OCTTOBIN</dd>
|
|
<dt><b>OCTTODEC</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodOCTTODEC">PHPExcel_Calculation_Engineering::OCTTODEC()</a><br> OCTTODEC</dd>
|
|
<dt><b>OCTTOHEX</b></dt>
|
|
<dd>in file Engineering.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html#methodOCTTOHEX">PHPExcel_Calculation_Engineering::OCTTOHEX()</a><br> OCTTOHEX</dd>
|
|
<dt><b>ODD</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodODD">PHPExcel_Calculation_MathTrig::ODD()</a><br> ODD</dd>
|
|
<dt><b>OFFSET</b></dt>
|
|
<dd>in file LookupRef.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html#methodOFFSET">PHPExcel_Calculation_LookupRef::OFFSET()</a><br> OFFSET</dd>
|
|
<dt><b>OPERATORS_INFIX</b></dt>
|
|
<dd>in file FormulaParser.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#constOPERATORS_INFIX">PHPExcel_Calculation_FormulaParser::OPERATORS_INFIX</a></dd>
|
|
<dt><b>OPERATORS_POSTFIX</b></dt>
|
|
<dd>in file FormulaParser.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#constOPERATORS_POSTFIX">PHPExcel_Calculation_FormulaParser::OPERATORS_POSTFIX</a></dd>
|
|
<dt><b>OPERATORS_SN</b></dt>
|
|
<dd>in file FormulaParser.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#constOPERATORS_SN">PHPExcel_Calculation_FormulaParser::OPERATORS_SN</a></dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="p"></a>
|
|
<div>
|
|
<h2>p</h2>
|
|
<dl>
|
|
<dt><b>PAREN_CLOSE</b></dt>
|
|
<dd>in file FormulaParser.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#constPAREN_CLOSE">PHPExcel_Calculation_FormulaParser::PAREN_CLOSE</a></dd>
|
|
<dt><b>PAREN_OPEN</b></dt>
|
|
<dd>in file FormulaParser.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#constPAREN_OPEN">PHPExcel_Calculation_FormulaParser::PAREN_OPEN</a></dd>
|
|
<dt><b>parseFormula</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodparseFormula">PHPExcel_Calculation::parseFormula()</a><br> Validate and parse a formula string</dd>
|
|
<dt><b>PERCENTILE</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodPERCENTILE">PHPExcel_Calculation_Statistical::PERCENTILE()</a><br> PERCENTILE</dd>
|
|
<dt><b>PERCENTRANK</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodPERCENTRANK">PHPExcel_Calculation_Statistical::PERCENTRANK()</a><br> PERCENTRANK</dd>
|
|
<dt><b>PERMUT</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodPERMUT">PHPExcel_Calculation_Statistical::PERMUT()</a><br> PERMUT</dd>
|
|
<dt><b>PHPExcel_Calculation</b></dt>
|
|
<dd>in file Calculation.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation.html">PHPExcel_Calculation</a><br> PHPExcel_Calculation (Singleton)</dd>
|
|
<dt><b>PHPExcel_Calculation_Database</b></dt>
|
|
<dd>in file Database.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_Database.html">PHPExcel_Calculation_Database</a><br> PHPExcel_Calculation_Database</dd>
|
|
<dt><b>PHPExcel_Calculation_DateTime</b></dt>
|
|
<dd>in file DateTime.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html">PHPExcel_Calculation_DateTime</a><br> PHPExcel_Calculation_DateTime</dd>
|
|
<dt><b>PHPExcel_Calculation_Engineering</b></dt>
|
|
<dd>in file Engineering.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html">PHPExcel_Calculation_Engineering</a><br> PHPExcel_Calculation_Engineering</dd>
|
|
<dt><b>PHPExcel_Calculation_Exception</b></dt>
|
|
<dd>in file Exception.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_Exception.html">PHPExcel_Calculation_Exception</a><br> PHPExcel_Calculation_Exception</dd>
|
|
<dt><b>PHPExcel_Calculation_ExceptionHandler</b></dt>
|
|
<dd>in file ExceptionHandler.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_ExceptionHandler.html">PHPExcel_Calculation_ExceptionHandler</a><br> PHPExcel_Calculation_ExceptionHandler</dd>
|
|
<dt><b>PHPExcel_Calculation_Financial</b></dt>
|
|
<dd>in file Financial.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html">PHPExcel_Calculation_Financial</a><br> PHPExcel_Calculation_Financial</dd>
|
|
<dt><b>PHPExcel_Calculation_FormulaParser</b></dt>
|
|
<dd>in file FormulaParser.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html">PHPExcel_Calculation_FormulaParser</a><br> PHPExcel_Calculation_FormulaParser</dd>
|
|
<dt><b>PHPExcel_Calculation_FormulaToken</b></dt>
|
|
<dd>in file FormulaToken.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html">PHPExcel_Calculation_FormulaToken</a><br> PHPExcel_Calculation_FormulaToken</dd>
|
|
<dt><b>PHPExcel_Calculation_Function</b></dt>
|
|
<dd>in file Function.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html">PHPExcel_Calculation_Function</a><br> PHPExcel_Calculation_Function</dd>
|
|
<dt><b>PHPExcel_Calculation_Functions</b></dt>
|
|
<dd>in file Functions.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html">PHPExcel_Calculation_Functions</a><br> PHPExcel_Calculation_Functions</dd>
|
|
<dt><b>PHPExcel_Calculation_Logical</b></dt>
|
|
<dd>in file Logical.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_Logical.html">PHPExcel_Calculation_Logical</a><br> PHPExcel_Calculation_Logical</dd>
|
|
<dt><b>PHPExcel_Calculation_LookupRef</b></dt>
|
|
<dd>in file LookupRef.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html">PHPExcel_Calculation_LookupRef</a><br> PHPExcel_Calculation_LookupRef</dd>
|
|
<dt><b>PHPExcel_Calculation_MathTrig</b></dt>
|
|
<dd>in file MathTrig.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html">PHPExcel_Calculation_MathTrig</a><br> PHPExcel_Calculation_MathTrig</dd>
|
|
<dt><b>PHPExcel_Calculation_Statistical</b></dt>
|
|
<dd>in file Statistical.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html">PHPExcel_Calculation_Statistical</a><br> PHPExcel_Calculation_Statistical</dd>
|
|
<dt><b>PHPExcel_Calculation_TextData</b></dt>
|
|
<dd>in file TextData.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html">PHPExcel_Calculation_TextData</a><br> PHPExcel_Calculation_TextData</dd>
|
|
<dt><b>PHPExcel_Calculation_Token_Stack</b></dt>
|
|
<dd>in file Stack.php, class <a href="PHPExcel_Calculation/PHPExcel_Calculation_Token_Stack.html">PHPExcel_Calculation_Token_Stack</a><br> PHPExcel</dd>
|
|
<dt><b>PMT</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodPMT">PHPExcel_Calculation_Financial::PMT()</a><br> PMT</dd>
|
|
<dt><b>POISSON</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodPOISSON">PHPExcel_Calculation_Statistical::POISSON()</a><br> POISSON</dd>
|
|
<dt><b>pop</b></dt>
|
|
<dd>in file Stack.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Token_Stack.html#methodpop">PHPExcel_Calculation_Token_Stack::pop()</a></dd>
|
|
<dt><b>POWER</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodPOWER">PHPExcel_Calculation_MathTrig::POWER()</a><br> POWER</dd>
|
|
<dt><b>PPMT</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodPPMT">PHPExcel_Calculation_Financial::PPMT()</a><br> PPMT</dd>
|
|
<dt><b>PRECISION</b></dt>
|
|
<dd>in file Functions.php, constant <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Functions.php.html#definePRECISION">PRECISION</a><br> PRECISION</dd>
|
|
<dt><b>PRICE</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodPRICE">PHPExcel_Calculation_Financial::PRICE()</a></dd>
|
|
<dt><b>PRICEDISC</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodPRICEDISC">PHPExcel_Calculation_Financial::PRICEDISC()</a><br> PRICEDISC</dd>
|
|
<dt><b>PRICEMAT</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodPRICEMAT">PHPExcel_Calculation_Financial::PRICEMAT()</a><br> PRICEMAT</dd>
|
|
<dt><b>PRODUCT</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodPRODUCT">PHPExcel_Calculation_MathTrig::PRODUCT()</a><br> PRODUCT</dd>
|
|
<dt><b>PROPERCASE</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodPROPERCASE">PHPExcel_Calculation_TextData::PROPERCASE()</a><br> PROPERCASE</dd>
|
|
<dt><b>push</b></dt>
|
|
<dd>in file Stack.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Token_Stack.html#methodpush">PHPExcel_Calculation_Token_Stack::push()</a></dd>
|
|
<dt><b>PV</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodPV">PHPExcel_Calculation_Financial::PV()</a><br> PV</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="q"></a>
|
|
<div>
|
|
<h2>q</h2>
|
|
<dl>
|
|
<dt><b>QUARTILE</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodQUARTILE">PHPExcel_Calculation_Statistical::QUARTILE()</a><br> QUARTILE</dd>
|
|
<dt><b>QUOTE_DOUBLE</b></dt>
|
|
<dd>in file FormulaParser.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#constQUOTE_DOUBLE">PHPExcel_Calculation_FormulaParser::QUOTE_DOUBLE</a></dd>
|
|
<dt><b>QUOTE_SINGLE</b></dt>
|
|
<dd>in file FormulaParser.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#constQUOTE_SINGLE">PHPExcel_Calculation_FormulaParser::QUOTE_SINGLE</a></dd>
|
|
<dt><b>QUOTIENT</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodQUOTIENT">PHPExcel_Calculation_MathTrig::QUOTIENT()</a><br> QUOTIENT</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="r"></a>
|
|
<div>
|
|
<h2>r</h2>
|
|
<dl>
|
|
<dt><b>$ReturnDateType</b></dt>
|
|
<dd>in file Functions.php, variable <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#var$ReturnDateType">PHPExcel_Calculation_Functions::$ReturnDateType</a><br> Data Type to use when returning date values</dd>
|
|
<dt><b>RAND</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodRAND">PHPExcel_Calculation_MathTrig::RAND()</a><br> RAND</dd>
|
|
<dt><b>RANK</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodRANK">PHPExcel_Calculation_Statistical::RANK()</a><br> RANK</dd>
|
|
<dt><b>RATE</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodRATE">PHPExcel_Calculation_Financial::RATE()</a><br> RATE</dd>
|
|
<dt><b>RECEIVED</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodRECEIVED">PHPExcel_Calculation_Financial::RECEIVED()</a><br> RECEIVED</dd>
|
|
<dt><b>REF</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodREF">PHPExcel_Calculation_Functions::REF()</a><br> REF</dd>
|
|
<dt><b>REPLACE</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodREPLACE">PHPExcel_Calculation_TextData::REPLACE()</a><br> REPLACE</dd>
|
|
<dt><b>RETURNDATE_EXCEL</b></dt>
|
|
<dd>in file Functions.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#constRETURNDATE_EXCEL">PHPExcel_Calculation_Functions::RETURNDATE_EXCEL</a></dd>
|
|
<dt><b>RETURNDATE_PHP_NUMERIC</b></dt>
|
|
<dd>in file Functions.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#constRETURNDATE_PHP_NUMERIC">PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC</a></dd>
|
|
<dt><b>RETURNDATE_PHP_OBJECT</b></dt>
|
|
<dd>in file Functions.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#constRETURNDATE_PHP_OBJECT">PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT</a></dd>
|
|
<dt><b>RETURNSTRING</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodRETURNSTRING">PHPExcel_Calculation_TextData::RETURNSTRING()</a><br> RETURNSTRING</dd>
|
|
<dt><b>RETURN_ARRAY_AS_ARRAY</b></dt>
|
|
<dd>in file Calculation.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#constRETURN_ARRAY_AS_ARRAY">PHPExcel_Calculation::RETURN_ARRAY_AS_ARRAY</a></dd>
|
|
<dt><b>RETURN_ARRAY_AS_ERROR</b></dt>
|
|
<dd>in file Calculation.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#constRETURN_ARRAY_AS_ERROR">PHPExcel_Calculation::RETURN_ARRAY_AS_ERROR</a><br> constants</dd>
|
|
<dt><b>RETURN_ARRAY_AS_VALUE</b></dt>
|
|
<dd>in file Calculation.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#constRETURN_ARRAY_AS_VALUE">PHPExcel_Calculation::RETURN_ARRAY_AS_VALUE</a></dd>
|
|
<dt><b>RIGHT</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodRIGHT">PHPExcel_Calculation_TextData::RIGHT()</a><br> RIGHT</dd>
|
|
<dt><b>ROMAN</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodROMAN">PHPExcel_Calculation_MathTrig::ROMAN()</a></dd>
|
|
<dt><b>ROUNDDOWN</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodROUNDDOWN">PHPExcel_Calculation_MathTrig::ROUNDDOWN()</a><br> ROUNDDOWN</dd>
|
|
<dt><b>ROUNDUP</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodROUNDUP">PHPExcel_Calculation_MathTrig::ROUNDUP()</a><br> ROUNDUP</dd>
|
|
<dt><b>ROW</b></dt>
|
|
<dd>in file LookupRef.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html#methodROW">PHPExcel_Calculation_LookupRef::ROW()</a><br> ROW</dd>
|
|
<dt><b>ROWS</b></dt>
|
|
<dd>in file LookupRef.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html#methodROWS">PHPExcel_Calculation_LookupRef::ROWS()</a><br> ROWS</dd>
|
|
<dt><b>RSQ</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodRSQ">PHPExcel_Calculation_Statistical::RSQ()</a><br> RSQ</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="s"></a>
|
|
<div>
|
|
<h2>s</h2>
|
|
<dl>
|
|
<dt><b>$suppressFormulaErrors</b></dt>
|
|
<dd>in file Calculation.php, variable <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#var$suppressFormulaErrors">PHPExcel_Calculation::$suppressFormulaErrors</a><br> 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</dd>
|
|
<dt><b>Statistical.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Statistical.php.html">Statistical.php</a></dd>
|
|
<dt><b>Stack.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Token---Stack.php.html">Stack.php</a></dd>
|
|
<dt><b>SEARCHINSENSITIVE</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodSEARCHINSENSITIVE">PHPExcel_Calculation_TextData::SEARCHINSENSITIVE()</a><br> SEARCHINSENSITIVE</dd>
|
|
<dt><b>SEARCHSENSITIVE</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodSEARCHSENSITIVE">PHPExcel_Calculation_TextData::SEARCHSENSITIVE()</a><br> SEARCHSENSITIVE</dd>
|
|
<dt><b>SECONDOFMINUTE</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodSECONDOFMINUTE">PHPExcel_Calculation_DateTime::SECONDOFMINUTE()</a><br> SECONDOFMINUTE</dd>
|
|
<dt><b>SEMICOLON</b></dt>
|
|
<dd>in file FormulaParser.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#constSEMICOLON">PHPExcel_Calculation_FormulaParser::SEMICOLON</a></dd>
|
|
<dt><b>SERIESSUM</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodSERIESSUM">PHPExcel_Calculation_MathTrig::SERIESSUM()</a><br> SERIESSUM</dd>
|
|
<dt><b>setArrayReturnType</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodsetArrayReturnType">PHPExcel_Calculation::setArrayReturnType()</a><br> Set the Array Return Type (Array or Value of first element in the array)</dd>
|
|
<dt><b>setCalculationCacheEnabled</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodsetCalculationCacheEnabled">PHPExcel_Calculation::setCalculationCacheEnabled()</a><br> Enable/disable calculation cache</dd>
|
|
<dt><b>setCalculationCacheExpirationTime</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodsetCalculationCacheExpirationTime">PHPExcel_Calculation::setCalculationCacheExpirationTime()</a><br> Set calculation cache expiration time</dd>
|
|
<dt><b>setCategory</b></dt>
|
|
<dd>in file Function.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#methodsetCategory">PHPExcel_Calculation_Function::setCategory()</a><br> Set Category (represented by CATEGORY_*)</dd>
|
|
<dt><b>setCompatibilityMode</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodsetCompatibilityMode">PHPExcel_Calculation_Functions::setCompatibilityMode()</a><br> Set the Compatibility Mode</dd>
|
|
<dt><b>setExcelName</b></dt>
|
|
<dd>in file Function.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#methodsetExcelName">PHPExcel_Calculation_Function::setExcelName()</a><br> Set Excel name</dd>
|
|
<dt><b>setLocale</b></dt>
|
|
<dd>in file Calculation.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#methodsetLocale">PHPExcel_Calculation::setLocale()</a><br> Set the locale code</dd>
|
|
<dt><b>setPHPExcelName</b></dt>
|
|
<dd>in file Function.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Function.html#methodsetPHPExcelName">PHPExcel_Calculation_Function::setPHPExcelName()</a><br> Set PHPExcel name</dd>
|
|
<dt><b>setReturnDateType</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodsetReturnDateType">PHPExcel_Calculation_Functions::setReturnDateType()</a><br> Set the Return Date Format used by functions that return a date/time (Excel, PHP Serialized Numeric or PHP Object)</dd>
|
|
<dt><b>setTokenSubType</b></dt>
|
|
<dd>in file FormulaToken.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#methodsetTokenSubType">PHPExcel_Calculation_FormulaToken::setTokenSubType()</a><br> Set Token SubType</dd>
|
|
<dt><b>setTokenType</b></dt>
|
|
<dd>in file FormulaToken.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#methodsetTokenType">PHPExcel_Calculation_FormulaToken::setTokenType()</a><br> Set Token Type</dd>
|
|
<dt><b>setValue</b></dt>
|
|
<dd>in file FormulaToken.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#methodsetValue">PHPExcel_Calculation_FormulaToken::setValue()</a><br> Set Value</dd>
|
|
<dt><b>SIGN</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodSIGN">PHPExcel_Calculation_MathTrig::SIGN()</a><br> SIGN</dd>
|
|
<dt><b>SKEW</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodSKEW">PHPExcel_Calculation_Statistical::SKEW()</a><br> SKEW</dd>
|
|
<dt><b>SLN</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodSLN">PHPExcel_Calculation_Financial::SLN()</a><br> SLN</dd>
|
|
<dt><b>SLOPE</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodSLOPE">PHPExcel_Calculation_Statistical::SLOPE()</a><br> SLOPE</dd>
|
|
<dt><b>SMALL</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodSMALL">PHPExcel_Calculation_Statistical::SMALL()</a><br> SMALL</dd>
|
|
<dt><b>SQRT2PI</b></dt>
|
|
<dd>in file Statistical.php, constant <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Statistical.php.html#defineSQRT2PI">SQRT2PI</a><br> SQRT2PI</dd>
|
|
<dt><b>SQRTPI</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodSQRTPI">PHPExcel_Calculation_MathTrig::SQRTPI()</a><br> SQRTPI</dd>
|
|
<dt><b>STANDARDIZE</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodSTANDARDIZE">PHPExcel_Calculation_Statistical::STANDARDIZE()</a><br> STANDARDIZE</dd>
|
|
<dt><b>STATEMENT_IF</b></dt>
|
|
<dd>in file Logical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Logical.html#methodSTATEMENT_IF">PHPExcel_Calculation_Logical::STATEMENT_IF()</a><br> STATEMENT_IF</dd>
|
|
<dt><b>STDEV</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodSTDEV">PHPExcel_Calculation_Statistical::STDEV()</a><br> STDEV</dd>
|
|
<dt><b>STDEVA</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodSTDEVA">PHPExcel_Calculation_Statistical::STDEVA()</a><br> STDEVA</dd>
|
|
<dt><b>STDEVP</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodSTDEVP">PHPExcel_Calculation_Statistical::STDEVP()</a><br> STDEVP</dd>
|
|
<dt><b>STDEVPA</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodSTDEVPA">PHPExcel_Calculation_Statistical::STDEVPA()</a><br> STDEVPA</dd>
|
|
<dt><b>STEYX</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodSTEYX">PHPExcel_Calculation_Statistical::STEYX()</a><br> STEYX</dd>
|
|
<dt><b>STRINGLENGTH</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodSTRINGLENGTH">PHPExcel_Calculation_TextData::STRINGLENGTH()</a><br> STRINGLENGTH</dd>
|
|
<dt><b>SUBSTITUTE</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodSUBSTITUTE">PHPExcel_Calculation_TextData::SUBSTITUTE()</a><br> SUBSTITUTE</dd>
|
|
<dt><b>SUBTOTAL</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodSUBTOTAL">PHPExcel_Calculation_MathTrig::SUBTOTAL()</a><br> SUBTOTAL</dd>
|
|
<dt><b>SUM</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodSUM">PHPExcel_Calculation_MathTrig::SUM()</a><br> SUM</dd>
|
|
<dt><b>SUMIF</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodSUMIF">PHPExcel_Calculation_MathTrig::SUMIF()</a><br> SUMIF</dd>
|
|
<dt><b>SUMPRODUCT</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodSUMPRODUCT">PHPExcel_Calculation_MathTrig::SUMPRODUCT()</a><br> SUMPRODUCT</dd>
|
|
<dt><b>SUMSQ</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodSUMSQ">PHPExcel_Calculation_MathTrig::SUMSQ()</a><br> SUMSQ</dd>
|
|
<dt><b>SUMX2MY2</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodSUMX2MY2">PHPExcel_Calculation_MathTrig::SUMX2MY2()</a><br> SUMX2MY2</dd>
|
|
<dt><b>SUMX2PY2</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodSUMX2PY2">PHPExcel_Calculation_MathTrig::SUMX2PY2()</a><br> SUMX2PY2</dd>
|
|
<dt><b>SUMXMY2</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodSUMXMY2">PHPExcel_Calculation_MathTrig::SUMXMY2()</a><br> SUMXMY2</dd>
|
|
<dt><b>SYD</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodSYD">PHPExcel_Calculation_Financial::SYD()</a><br> SYD</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="t"></a>
|
|
<div>
|
|
<h2>t</h2>
|
|
<dl>
|
|
<dt><b>TextData.php</b></dt>
|
|
<dd>procedural page <a href="PHPExcel_Calculation/_PHPExcel---Calculation---TextData.php.html">TextData.php</a></dd>
|
|
<dt><b>TBILLEQ</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodTBILLEQ">PHPExcel_Calculation_Financial::TBILLEQ()</a><br> TBILLEQ</dd>
|
|
<dt><b>TBILLPRICE</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodTBILLPRICE">PHPExcel_Calculation_Financial::TBILLPRICE()</a><br> TBILLPRICE</dd>
|
|
<dt><b>TBILLYIELD</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodTBILLYIELD">PHPExcel_Calculation_Financial::TBILLYIELD()</a><br> TBILLYIELD</dd>
|
|
<dt><b>TDIST</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodTDIST">PHPExcel_Calculation_Statistical::TDIST()</a><br> TDIST</dd>
|
|
<dt><b>TEXTFORMAT</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodTEXTFORMAT">PHPExcel_Calculation_TextData::TEXTFORMAT()</a><br> TEXTFORMAT</dd>
|
|
<dt><b>TIME</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodTIME">PHPExcel_Calculation_DateTime::TIME()</a><br> TIME</dd>
|
|
<dt><b>TIMEVALUE</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodTIMEVALUE">PHPExcel_Calculation_DateTime::TIMEVALUE()</a><br> TIMEVALUE</dd>
|
|
<dt><b>TINV</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodTINV">PHPExcel_Calculation_Statistical::TINV()</a><br> TINV</dd>
|
|
<dt><b>TOKEN_SUBTYPE_CONCATENATION</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_SUBTYPE_CONCATENATION">PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_CONCATENATION</a></dd>
|
|
<dt><b>TOKEN_SUBTYPE_ERROR</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_SUBTYPE_ERROR">PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_ERROR</a></dd>
|
|
<dt><b>TOKEN_SUBTYPE_INTERSECTION</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_SUBTYPE_INTERSECTION">PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_INTERSECTION</a></dd>
|
|
<dt><b>TOKEN_SUBTYPE_LOGICAL</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_SUBTYPE_LOGICAL">PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_LOGICAL</a></dd>
|
|
<dt><b>TOKEN_SUBTYPE_MATH</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_SUBTYPE_MATH">PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_MATH</a></dd>
|
|
<dt><b>TOKEN_SUBTYPE_NOTHING</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_SUBTYPE_NOTHING">PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_NOTHING</a></dd>
|
|
<dt><b>TOKEN_SUBTYPE_NUMBER</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_SUBTYPE_NUMBER">PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_NUMBER</a></dd>
|
|
<dt><b>TOKEN_SUBTYPE_RANGE</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_SUBTYPE_RANGE">PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_RANGE</a></dd>
|
|
<dt><b>TOKEN_SUBTYPE_START</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_SUBTYPE_START">PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_START</a></dd>
|
|
<dt><b>TOKEN_SUBTYPE_STOP</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_SUBTYPE_STOP">PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_STOP</a></dd>
|
|
<dt><b>TOKEN_SUBTYPE_TEXT</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_SUBTYPE_TEXT">PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_TEXT</a></dd>
|
|
<dt><b>TOKEN_SUBTYPE_UNION</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_SUBTYPE_UNION">PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_UNION</a></dd>
|
|
<dt><b>TOKEN_TYPE_ARGUMENT</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_TYPE_ARGUMENT">PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_ARGUMENT</a></dd>
|
|
<dt><b>TOKEN_TYPE_FUNCTION</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_TYPE_FUNCTION">PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_FUNCTION</a></dd>
|
|
<dt><b>TOKEN_TYPE_NOOP</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_TYPE_NOOP">PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_NOOP</a></dd>
|
|
<dt><b>TOKEN_TYPE_OPERAND</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_TYPE_OPERAND">PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_OPERAND</a></dd>
|
|
<dt><b>TOKEN_TYPE_OPERATORINFIX</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_TYPE_OPERATORINFIX">PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_OPERATORINFIX</a></dd>
|
|
<dt><b>TOKEN_TYPE_OPERATORPOSTFIX</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_TYPE_OPERATORPOSTFIX">PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_OPERATORPOSTFIX</a></dd>
|
|
<dt><b>TOKEN_TYPE_OPERATORPREFIX</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_TYPE_OPERATORPREFIX">PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_OPERATORPREFIX</a></dd>
|
|
<dt><b>TOKEN_TYPE_SUBEXPRESSION</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_TYPE_SUBEXPRESSION">PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_SUBEXPRESSION</a></dd>
|
|
<dt><b>TOKEN_TYPE_UNKNOWN</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_TYPE_UNKNOWN">PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_UNKNOWN</a></dd>
|
|
<dt><b>TOKEN_TYPE_WHITESPACE</b></dt>
|
|
<dd>in file FormulaToken.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html#constTOKEN_TYPE_WHITESPACE">PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_WHITESPACE</a></dd>
|
|
<dt><b>TRANSPOSE</b></dt>
|
|
<dd>in file LookupRef.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html#methodTRANSPOSE">PHPExcel_Calculation_LookupRef::TRANSPOSE()</a><br> TRANSPOSE</dd>
|
|
<dt><b>TREND</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodTREND">PHPExcel_Calculation_Statistical::TREND()</a><br> TREND</dd>
|
|
<dt><b>TRIMMEAN</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodTRIMMEAN">PHPExcel_Calculation_Statistical::TRIMMEAN()</a><br> TRIMMEAN</dd>
|
|
<dt><b>TRIMNONPRINTABLE</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodTRIMNONPRINTABLE">PHPExcel_Calculation_TextData::TRIMNONPRINTABLE()</a><br> TRIMNONPRINTABLE</dd>
|
|
<dt><b>TRIMSPACES</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodTRIMSPACES">PHPExcel_Calculation_TextData::TRIMSPACES()</a><br> TRIMSPACES</dd>
|
|
<dt><b>TRUE</b></dt>
|
|
<dd>in file Logical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Logical.html#methodTRUE">PHPExcel_Calculation_Logical::TRUE()</a><br> TRUE</dd>
|
|
<dt><b>TRUNC</b></dt>
|
|
<dd>in file MathTrig.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html#methodTRUNC">PHPExcel_Calculation_MathTrig::TRUNC()</a><br> TRUNC</dd>
|
|
<dt><b>TYPE</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodTYPE">PHPExcel_Calculation_Functions::TYPE()</a><br> TYPE</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="u"></a>
|
|
<div>
|
|
<h2>u</h2>
|
|
<dl>
|
|
<dt><b>UPPERCASE</b></dt>
|
|
<dd>in file TextData.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_TextData.html#methodUPPERCASE">PHPExcel_Calculation_TextData::UPPERCASE()</a><br> UPPERCASE</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="v"></a>
|
|
<div>
|
|
<h2>v</h2>
|
|
<dl>
|
|
<dt><b>VALUE</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodVALUE">PHPExcel_Calculation_Functions::VALUE()</a><br> VALUE</dd>
|
|
<dt><b>VARA</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodVARA">PHPExcel_Calculation_Statistical::VARA()</a><br> VARA</dd>
|
|
<dt><b>VARFunc</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodVARFunc">PHPExcel_Calculation_Statistical::VARFunc()</a><br> VARFunc</dd>
|
|
<dt><b>VARP</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodVARP">PHPExcel_Calculation_Statistical::VARP()</a><br> VARP</dd>
|
|
<dt><b>VARPA</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodVARPA">PHPExcel_Calculation_Statistical::VARPA()</a><br> VARPA</dd>
|
|
<dt><b>VERSION</b></dt>
|
|
<dd>in file Functions.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Functions.html#methodVERSION">PHPExcel_Calculation_Functions::VERSION()</a><br> VERSION</dd>
|
|
<dt><b>VLOOKUP</b></dt>
|
|
<dd>in file LookupRef.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html#methodVLOOKUP">PHPExcel_Calculation_LookupRef::VLOOKUP()</a><br> 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.</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="w"></a>
|
|
<div>
|
|
<h2>w</h2>
|
|
<dl>
|
|
<dt><b>$writeDebugLog</b></dt>
|
|
<dd>in file Calculation.php, variable <a href="PHPExcel_Calculation/PHPExcel_Calculation.html#var$writeDebugLog">PHPExcel_Calculation::$writeDebugLog</a><br> 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</dd>
|
|
<dt><b>WEEKOFYEAR</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodWEEKOFYEAR">PHPExcel_Calculation_DateTime::WEEKOFYEAR()</a><br> WEEKOFYEAR</dd>
|
|
<dt><b>WEIBULL</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodWEIBULL">PHPExcel_Calculation_Statistical::WEIBULL()</a><br> WEIBULL</dd>
|
|
<dt><b>WHITESPACE</b></dt>
|
|
<dd>in file FormulaParser.php, class constant <a href="PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html#constWHITESPACE">PHPExcel_Calculation_FormulaParser::WHITESPACE</a></dd>
|
|
<dt><b>WORKDAY</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodWORKDAY">PHPExcel_Calculation_DateTime::WORKDAY()</a><br> WORKDAY</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="x"></a>
|
|
<div>
|
|
<h2>x</h2>
|
|
<dl>
|
|
<dt><b>XIRR</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodXIRR">PHPExcel_Calculation_Financial::XIRR()</a></dd>
|
|
<dt><b>XMININ</b></dt>
|
|
<dd>in file Statistical.php, constant <a href="PHPExcel_Calculation/_PHPExcel---Calculation---Statistical.php.html#defineXMININ">XMININ</a><br> XMININ</dd>
|
|
<dt><b>XNPV</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodXNPV">PHPExcel_Calculation_Financial::XNPV()</a><br> XNPV</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="y"></a>
|
|
<div>
|
|
<h2>y</h2>
|
|
<dl>
|
|
<dt><b>YEAR</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodYEAR">PHPExcel_Calculation_DateTime::YEAR()</a><br> YEAR</dd>
|
|
<dt><b>YEARFRAC</b></dt>
|
|
<dd>in file DateTime.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html#methodYEARFRAC">PHPExcel_Calculation_DateTime::YEARFRAC()</a><br> YEARFRAC</dd>
|
|
<dt><b>YIELDDISC</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodYIELDDISC">PHPExcel_Calculation_Financial::YIELDDISC()</a><br> YIELDDISC</dd>
|
|
<dt><b>YIELDMAT</b></dt>
|
|
<dd>in file Financial.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodYIELDMAT">PHPExcel_Calculation_Financial::YIELDMAT()</a><br> YIELDMAT</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<hr />
|
|
<a name="z"></a>
|
|
<div>
|
|
<h2>z</h2>
|
|
<dl>
|
|
<dt><b>ZTEST</b></dt>
|
|
<dd>in file Statistical.php, method <a href="PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html#methodZTEST">PHPExcel_Calculation_Statistical::ZTEST()</a><br> ZTEST</dd>
|
|
</dl>
|
|
</div>
|
|
<a href="elementindex_PHPExcel_Calculation.html#top">top</a><br>
|
|
<div class="credit">
|
|
<hr />
|
|
Documentation generated on Fri, 12 Oct 2012 00:15:04 +0200 by <a href="http://www.phpdoc.org">phpDocumentor 1.4.4</a>
|
|
</div>
|
|
</td></tr></table>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
|
|
</body>
|
|
</html> |