You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by fa...@apache.org on 2022/01/26 12:10:30 UTC

svn commit: r1897501 - /poi/site/publish/components/spreadsheet/eval-devguide.html

Author: fanningpj
Date: Wed Jan 26 12:10:30 2022
New Revision: 1897501

URL: http://svn.apache.org/viewvc?rev=1897501&view=rev
Log:
update function list

Modified:
    poi/site/publish/components/spreadsheet/eval-devguide.html

Modified: poi/site/publish/components/spreadsheet/eval-devguide.html
URL: http://svn.apache.org/viewvc/poi/site/publish/components/spreadsheet/eval-devguide.html?rev=1897501&r1=1897500&r2=1897501&view=diff
==============================================================================
--- poi/site/publish/components/spreadsheet/eval-devguide.html (original)
+++ poi/site/publish/components/spreadsheet/eval-devguide.html Wed Jan 26 12:10:30 2022
@@ -906,610 +906,610 @@ document.write("Last Published: " + docu
 			</p>
 <div class="code">
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ABS</span>
+<span class="lineno"></span><span class="codebody">ABS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">OS</span>
+<span class="lineno"></span><span class="codebody">ACOS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">OSH</span>
+<span class="lineno"></span><span class="codebody">ACOSH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">DRESS</span>
+<span class="lineno"></span><span class="codebody">ADDRESS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">D</span>
+<span class="lineno"></span><span class="codebody">AND</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">EAS</span>
+<span class="lineno"></span><span class="codebody">AREAS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">IN</span>
+<span class="lineno"></span><span class="codebody">ASIN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">INH</span>
+<span class="lineno"></span><span class="codebody">ASINH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">AN</span>
+<span class="lineno"></span><span class="codebody">ATAN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">AN2</span>
+<span class="lineno"></span><span class="codebody">ATAN2</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ANH</span>
+<span class="lineno"></span><span class="codebody">ATANH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">EDEV</span>
+<span class="lineno"></span><span class="codebody">AVEDEV</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ERAGE</span>
+<span class="lineno"></span><span class="codebody">AVERAGE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ERAGEIFS</span>
+<span class="lineno"></span><span class="codebody">AVERAGEIFS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">N2DEC</span>
+<span class="lineno"></span><span class="codebody">BIN2DEC</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ILING</span>
+<span class="lineno"></span><span class="codebody">CEILING</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">AR</span>
+<span class="lineno"></span><span class="codebody">CHAR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">OOSE</span>
+<span class="lineno"></span><span class="codebody">CHOOSE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">EAN</span>
+<span class="lineno"></span><span class="codebody">CLEAN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">DE</span>
+<span class="lineno"></span><span class="codebody">CODE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">LUMN</span>
+<span class="lineno"></span><span class="codebody">COLUMN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">LUMNS</span>
+<span class="lineno"></span><span class="codebody">COLUMNS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">MBIN</span>
+<span class="lineno"></span><span class="codebody">COMBIN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">MPLEX</span>
+<span class="lineno"></span><span class="codebody">COMPLEX</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NCAT</span>
+<span class="lineno"></span><span class="codebody">CONCAT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NCATENATE</span>
+<span class="lineno"></span><span class="codebody">CONCATENATE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">S</span>
+<span class="lineno"></span><span class="codebody">COS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">SH</span>
+<span class="lineno"></span><span class="codebody">COSH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">UNT</span>
+<span class="lineno"></span><span class="codebody">COUNT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">UNTA</span>
+<span class="lineno"></span><span class="codebody">COUNTA</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">UNTBLANK</span>
+<span class="lineno"></span><span class="codebody">COUNTBLANK</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">UNTIF</span>
+<span class="lineno"></span><span class="codebody">COUNTIF</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">UNTIFS</span>
+<span class="lineno"></span><span class="codebody">COUNTIFS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">TE</span>
+<span class="lineno"></span><span class="codebody">DATE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">TEVALUE</span>
+<span class="lineno"></span><span class="codebody">DATEVALUE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">Y</span>
+<span class="lineno"></span><span class="codebody">DAY</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">YS360</span>
+<span class="lineno"></span><span class="codebody">DAYS360</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">C2BIN</span>
+<span class="lineno"></span><span class="codebody">DEC2BIN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">C2HEX</span>
+<span class="lineno"></span><span class="codebody">DEC2HEX</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">GREES</span>
+<span class="lineno"></span><span class="codebody">DEGREES</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">LTA</span>
+<span class="lineno"></span><span class="codebody">DELTA</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">VSQ</span>
+<span class="lineno"></span><span class="codebody">DEVSQ</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ET</span>
+<span class="lineno"></span><span class="codebody">DGET</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">AX</span>
+<span class="lineno"></span><span class="codebody">DMAX</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">IN</span>
+<span class="lineno"></span><span class="codebody">DMIN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">LLAR</span>
+<span class="lineno"></span><span class="codebody">DOLLAR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">UM</span>
+<span class="lineno"></span><span class="codebody">DSUM</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ATE</span>
+<span class="lineno"></span><span class="codebody">EDATE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">MONTH</span>
+<span class="lineno"></span><span class="codebody">EOMONTH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ROR.TYPE</span>
+<span class="lineno"></span><span class="codebody">ERROR.TYPE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">EN</span>
+<span class="lineno"></span><span class="codebody">EVEN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ACT</span>
+<span class="lineno"></span><span class="codebody">EXACT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">P</span>
+<span class="lineno"></span><span class="codebody">EXP</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">CT</span>
+<span class="lineno"></span><span class="codebody">FACT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">CTDOUBLE</span>
+<span class="lineno"></span><span class="codebody">FACTDOUBLE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">LSE</span>
+<span class="lineno"></span><span class="codebody">FALSE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ND</span>
+<span class="lineno"></span><span class="codebody">FIND</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">XED</span>
+<span class="lineno"></span><span class="codebody">FIXED</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">OOR</span>
+<span class="lineno"></span><span class="codebody">FLOOR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">EQUENCY</span>
+<span class="lineno"></span><span class="codebody">FREQUENCY</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"></span>
+<span class="lineno"></span><span class="codebody">FV</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">OMEAN</span>
+<span class="lineno"></span><span class="codebody">GEOMEAN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">X2DEC</span>
+<span class="lineno"></span><span class="codebody">HEX2DEC</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">OOKUP</span>
+<span class="lineno"></span><span class="codebody">HLOOKUP</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">UR</span>
+<span class="lineno"></span><span class="codebody">HOUR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">PERLINK</span>
+<span class="lineno"></span><span class="codebody">HYPERLINK</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"></span>
+<span class="lineno"></span><span class="codebody">IF</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ERROR</span>
+<span class="lineno"></span><span class="codebody">IFERROR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NA</span>
+<span class="lineno"></span><span class="codebody">IFNA</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">S</span>
+<span class="lineno"></span><span class="codebody">IFS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">AGINARY</span>
+<span class="lineno"></span><span class="codebody">IMAGINARY</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">REAL</span>
+<span class="lineno"></span><span class="codebody">IMREAL</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">DEX</span>
+<span class="lineno"></span><span class="codebody">INDEX</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">DIRECT</span>
+<span class="lineno"></span><span class="codebody">INDIRECT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">T</span>
+<span class="lineno"></span><span class="codebody">INT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">TERCEPT</span>
+<span class="lineno"></span><span class="codebody">INTERCEPT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">MT</span>
+<span class="lineno"></span><span class="codebody">IPMT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">R</span>
+<span class="lineno"></span><span class="codebody">IRR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">BLANK</span>
+<span class="lineno"></span><span class="codebody">ISBLANK</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ERR</span>
+<span class="lineno"></span><span class="codebody">ISERR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ERROR</span>
+<span class="lineno"></span><span class="codebody">ISERROR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">EVEN</span>
+<span class="lineno"></span><span class="codebody">ISEVEN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">LOGICAL</span>
+<span class="lineno"></span><span class="codebody">ISLOGICAL</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NA</span>
+<span class="lineno"></span><span class="codebody">ISNA</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NONTEXT</span>
+<span class="lineno"></span><span class="codebody">ISNONTEXT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NUMBER</span>
+<span class="lineno"></span><span class="codebody">ISNUMBER</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ODD</span>
+<span class="lineno"></span><span class="codebody">ISODD</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">REF</span>
+<span class="lineno"></span><span class="codebody">ISREF</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">TEXT</span>
+<span class="lineno"></span><span class="codebody">ISTEXT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">RGE</span>
+<span class="lineno"></span><span class="codebody">LARGE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">FT</span>
+<span class="lineno"></span><span class="codebody">LEFT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">N</span>
+<span class="lineno"></span><span class="codebody">LEN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"></span>
+<span class="lineno"></span><span class="codebody">LN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">G</span>
+<span class="lineno"></span><span class="codebody">LOG</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">G10</span>
+<span class="lineno"></span><span class="codebody">LOG10</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">OKUP</span>
+<span class="lineno"></span><span class="codebody">LOOKUP</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">WER</span>
+<span class="lineno"></span><span class="codebody">LOWER</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">TCH</span>
+<span class="lineno"></span><span class="codebody">MATCH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">X</span>
+<span class="lineno"></span><span class="codebody">MAX</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">XA</span>
+<span class="lineno"></span><span class="codebody">MAXA</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">XIFS</span>
+<span class="lineno"></span><span class="codebody">MAXIFS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ETERM</span>
+<span class="lineno"></span><span class="codebody">MDETERM</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">DIAN</span>
+<span class="lineno"></span><span class="codebody">MEDIAN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">D</span>
+<span class="lineno"></span><span class="codebody">MID</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">N</span>
+<span class="lineno"></span><span class="codebody">MIN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NA</span>
+<span class="lineno"></span><span class="codebody">MINA</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NIFS</span>
+<span class="lineno"></span><span class="codebody">MINIFS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NUTE</span>
+<span class="lineno"></span><span class="codebody">MINUTE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NVERSE</span>
+<span class="lineno"></span><span class="codebody">MINVERSE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">RR</span>
+<span class="lineno"></span><span class="codebody">MIRR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ULT</span>
+<span class="lineno"></span><span class="codebody">MMULT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">D</span>
+<span class="lineno"></span><span class="codebody">MOD</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">DE</span>
+<span class="lineno"></span><span class="codebody">MODE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NTH</span>
+<span class="lineno"></span><span class="codebody">MONTH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">OUND</span>
+<span class="lineno"></span><span class="codebody">MROUND</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"></span>
+<span class="lineno"></span><span class="codebody">NA</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">TWORKDAYS</span>
+<span class="lineno"></span><span class="codebody">NETWORKDAYS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">T</span>
+<span class="lineno"></span><span class="codebody">NOT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">W</span>
+<span class="lineno"></span><span class="codebody">NOW</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ER</span>
+<span class="lineno"></span><span class="codebody">NPER</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">V</span>
+<span class="lineno"></span><span class="codebody">NPV</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">T2DEC</span>
+<span class="lineno"></span><span class="codebody">OCT2DEC</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">D</span>
+<span class="lineno"></span><span class="codebody">ODD</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">FSET</span>
+<span class="lineno"></span><span class="codebody">OFFSET</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"></span>
+<span class="lineno"></span><span class="codebody">OR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">RCENTILE</span>
+<span class="lineno"></span><span class="codebody">PERCENTILE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">RCENTRANK</span>
+<span class="lineno"></span><span class="codebody">PERCENTRANK</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">RCENTRANK.EXC</span>
+<span class="lineno"></span><span class="codebody">PERCENTRANK.EXC</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">RCENTRANK.INC</span>
+<span class="lineno"></span><span class="codebody">PERCENTRANK.INC</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"></span>
+<span class="lineno"></span><span class="codebody">PI</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">T</span>
+<span class="lineno"></span><span class="codebody">PMT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ISSON</span>
+<span class="lineno"></span><span class="codebody">POISSON</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">WER</span>
+<span class="lineno"></span><span class="codebody">POWER</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">MT</span>
+<span class="lineno"></span><span class="codebody">PPMT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ODUCT</span>
+<span class="lineno"></span><span class="codebody">PRODUCT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">OPER</span>
+<span class="lineno"></span><span class="codebody">PROPER</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"></span>
+<span class="lineno"></span><span class="codebody">PV</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">OTIENT</span>
+<span class="lineno"></span><span class="codebody">QUOTIENT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">DIANS</span>
+<span class="lineno"></span><span class="codebody">RADIANS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ND</span>
+<span class="lineno"></span><span class="codebody">RAND</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NDBETWEEN</span>
+<span class="lineno"></span><span class="codebody">RANDBETWEEN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NK</span>
+<span class="lineno"></span><span class="codebody">RANK</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">TE</span>
+<span class="lineno"></span><span class="codebody">RATE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">PLACE</span>
+<span class="lineno"></span><span class="codebody">REPLACE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">PT</span>
+<span class="lineno"></span><span class="codebody">REPT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">GHT</span>
+<span class="lineno"></span><span class="codebody">RIGHT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">MAN</span>
+<span class="lineno"></span><span class="codebody">ROMAN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">UND</span>
+<span class="lineno"></span><span class="codebody">ROUND</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">UNDDOWN</span>
+<span class="lineno"></span><span class="codebody">ROUNDDOWN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">UNDUP</span>
+<span class="lineno"></span><span class="codebody">ROUNDUP</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">W</span>
+<span class="lineno"></span><span class="codebody">ROW</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">WS</span>
+<span class="lineno"></span><span class="codebody">ROWS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ARCH</span>
+<span class="lineno"></span><span class="codebody">SEARCH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">COND</span>
+<span class="lineno"></span><span class="codebody">SECOND</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">GN</span>
+<span class="lineno"></span><span class="codebody">SIGN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">N</span>
+<span class="lineno"></span><span class="codebody">SIN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NGLE</span>
+<span class="lineno"></span><span class="codebody">SINGLE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NH</span>
+<span class="lineno"></span><span class="codebody">SINH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">OPE</span>
+<span class="lineno"></span><span class="codebody">SLOPE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ALL</span>
+<span class="lineno"></span><span class="codebody">SMALL</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">RT</span>
+<span class="lineno"></span><span class="codebody">SQRT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">DEV</span>
+<span class="lineno"></span><span class="codebody">STDEV</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">BSTITUTE</span>
+<span class="lineno"></span><span class="codebody">SUBSTITUTE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">BTOTAL</span>
+<span class="lineno"></span><span class="codebody">SUBTOTAL</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">M</span>
+<span class="lineno"></span><span class="codebody">SUM</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">MIF</span>
+<span class="lineno"></span><span class="codebody">SUMIF</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">MIFS</span>
+<span class="lineno"></span><span class="codebody">SUMIFS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">MPRODUCT</span>
+<span class="lineno"></span><span class="codebody">SUMPRODUCT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">MSQ</span>
+<span class="lineno"></span><span class="codebody">SUMSQ</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">MX2MY2</span>
+<span class="lineno"></span><span class="codebody">SUMX2MY2</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">MX2PY2</span>
+<span class="lineno"></span><span class="codebody">SUMX2PY2</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">MXMY2</span>
+<span class="lineno"></span><span class="codebody">SUMXMY2</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ITCH</span>
+<span class="lineno"></span><span class="codebody">SWITCH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"></span>
+<span class="lineno"></span><span class="codebody">T</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">DIST</span>
+<span class="lineno"></span><span class="codebody">T.DIST</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">DIST.2T</span>
+<span class="lineno"></span><span class="codebody">T.DIST.2T</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">DIST.RT</span>
+<span class="lineno"></span><span class="codebody">T.DIST.RT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">N</span>
+<span class="lineno"></span><span class="codebody">TAN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">NH</span>
+<span class="lineno"></span><span class="codebody">TANH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">IST</span>
+<span class="lineno"></span><span class="codebody">TDIST</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">XT</span>
+<span class="lineno"></span><span class="codebody">TEXT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">XTJOIN</span>
+<span class="lineno"></span><span class="codebody">TEXTJOIN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ME</span>
+<span class="lineno"></span><span class="codebody">TIME</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">MEVALUE</span>
+<span class="lineno"></span><span class="codebody">TIMEVALUE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">DAY</span>
+<span class="lineno"></span><span class="codebody">TODAY</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ANSPOSE</span>
+<span class="lineno"></span><span class="codebody">TRANSPOSE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">END</span>
+<span class="lineno"></span><span class="codebody">TREND</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">IM</span>
+<span class="lineno"></span><span class="codebody">TRIM</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">UE</span>
+<span class="lineno"></span><span class="codebody">TRUE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">UNC</span>
+<span class="lineno"></span><span class="codebody">TRUNC</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">PER</span>
+<span class="lineno"></span><span class="codebody">UPPER</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">LUE</span>
+<span class="lineno"></span><span class="codebody">VALUE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">R</span>
+<span class="lineno"></span><span class="codebody">VAR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">RP</span>
+<span class="lineno"></span><span class="codebody">VARP</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">OOKUP</span>
+<span class="lineno"></span><span class="codebody">VLOOKUP</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">EKDAY</span>
+<span class="lineno"></span><span class="codebody">WEEKDAY</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">EKNUM</span>
+<span class="lineno"></span><span class="codebody">WEEKNUM</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">RKDAY</span>
+<span class="lineno"></span><span class="codebody">WORKDAY</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">OOKUP</span>
+<span class="lineno"></span><span class="codebody">XLOOKUP</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ATCH</span>
+<span class="lineno"></span><span class="codebody">XMATCH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">AR</span>
+<span class="lineno"></span><span class="codebody">YEAR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody">ARFRAC</span>
+<span class="lineno"></span><span class="codebody">YEARFRAC</span>
 </div>
 </div>
 </div>



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org