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 11:58:55 UTC
svn commit: r1897499 - in /poi/site/publish: components/spreadsheet/eval-devguide.html encryption.html

Author: fanningpj
Date: Wed Jan 26 11:58:55 2022
New Revision: 1897499

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

Modified:
    poi/site/publish/components/spreadsheet/eval-devguide.html
    poi/site/publish/encryption.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=1897499&r1=1897498&r2=1897499&view=diff
==============================================================================
--- poi/site/publish/components/spreadsheet/eval-devguide.html (original)
+++ poi/site/publish/components/spreadsheet/eval-devguide.html Wed Jan 26 11:58:55 2022
@@ -371,8 +371,8 @@ document.write("Last Published: " + docu
 <h2 class="boxed">What functions are supported?</h2>
 <div class="section">
 <p>
-				As of July 2021, POI supports 302 built-in functions,
-				see <a href="#appendixA">Appendix A</a> for the full list.
+				As of release 5.2.0, POI implements 202 built-in functions,
+				see <a href="#appendixA">Appendix A</a> for the list of supported functions with an implementation.
 				You can programmatically list supported / unsupported functions using the following helper methods:
 			</p>
 <div class="code">
@@ -406,7 +406,7 @@ document.write("Last Published: " + docu
 					run-time.  Doing this will help you get the function you need as soon as possible.
 					The other option is to create the function yourself, and build it into the POI library,
 					possibly contributing the code to the POI project.  Doing this will help you get the
-					function you need, but you'll have to build POI from source youself.  And if you
+					function you need, but you'll have to build POI from source yourself.  And if you
 					contribute the code, you'll help others who need the function in the future, because
 					it will already be supported in the next release of POI.  The two options require
 					almost identical code, but the process of deploying the function is different.
@@ -902,914 +902,614 @@ document.write("Last Published: " + docu
 <h2 class="boxed">Appendix A &mdash; Functions supported by POI</h2>
 <div class="section">
 <p>
-				Functions supported by POI (as of July 2021)
+				Functions supported by POI (as of v5.2.0 release)
 			</p>
 <div class="code">
 <div class="codeline">
 <span class="lineno"></span><span class="codebody"> ABS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ABSREF</span>
+<span class="lineno"></span><span class="codebody">OS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ACOS</span>
+<span class="lineno"></span><span class="codebody">OSH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ACOSH</span>
+<span class="lineno"></span><span class="codebody">DRESS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ADDRESS</span>
+<span class="lineno"></span><span class="codebody">D</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> AND</span>
+<span class="lineno"></span><span class="codebody">EAS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> APP.TITLE</span>
+<span class="lineno"></span><span class="codebody">IN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> AREAS</span>
+<span class="lineno"></span><span class="codebody">INH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ARGUMENT</span>
+<span class="lineno"></span><span class="codebody">AN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ASC</span>
+<span class="lineno"></span><span class="codebody">AN2</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ASIN</span>
+<span class="lineno"></span><span class="codebody">ANH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ASINH</span>
+<span class="lineno"></span><span class="codebody">EDEV</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ATAN</span>
+<span class="lineno"></span><span class="codebody">ERAGE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ATAN2</span>
+<span class="lineno"></span><span class="codebody">ERAGEIFS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ATANH</span>
+<span class="lineno"></span><span class="codebody">N2DEC</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> AVEDEV</span>
+<span class="lineno"></span><span class="codebody">ILING</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> AVERAGE</span>
+<span class="lineno"></span><span class="codebody">AR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> AVERAGEA</span>
+<span class="lineno"></span><span class="codebody">OOSE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> BETADIST</span>
+<span class="lineno"></span><span class="codebody">EAN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> BETAINV</span>
+<span class="lineno"></span><span class="codebody">DE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> BINOMDIST</span>
+<span class="lineno"></span><span class="codebody">LUMN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> BIN2DEC</span>
+<span class="lineno"></span><span class="codebody">LUMNS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> CALL</span>
+<span class="lineno"></span><span class="codebody">MBIN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> CEILING</span>
+<span class="lineno"></span><span class="codebody">MPLEX</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> CELL</span>
+<span class="lineno"></span><span class="codebody">NCAT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> CHAR</span>
+<span class="lineno"></span><span class="codebody">NCATENATE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> CHIDIST</span>
+<span class="lineno"></span><span class="codebody">S</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> CHIINV</span>
+<span class="lineno"></span><span class="codebody">SH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> CHITEST</span>
+<span class="lineno"></span><span class="codebody">UNT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> CHOOSE</span>
+<span class="lineno"></span><span class="codebody">UNTA</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> CLEAN</span>
+<span class="lineno"></span><span class="codebody">UNTBLANK</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> CODE</span>
+<span class="lineno"></span><span class="codebody">UNTIF</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> COLUMN</span>
+<span class="lineno"></span><span class="codebody">UNTIFS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> COLUMNS</span>
+<span class="lineno"></span><span class="codebody">TE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> COMBIN</span>
+<span class="lineno"></span><span class="codebody">TEVALUE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> COMPLEX</span>
+<span class="lineno"></span><span class="codebody">Y</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> CONCAT</span>
+<span class="lineno"></span><span class="codebody">YS360</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> CONCATENATE</span>
+<span class="lineno"></span><span class="codebody">C2BIN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> CONFIDENCE</span>
+<span class="lineno"></span><span class="codebody">C2HEX</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> CORREL</span>
+<span class="lineno"></span><span class="codebody">GREES</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> COS</span>
+<span class="lineno"></span><span class="codebody">LTA</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> COSH</span>
+<span class="lineno"></span><span class="codebody">VSQ</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> COUNT</span>
+<span class="lineno"></span><span class="codebody">ET</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> COUNTA</span>
+<span class="lineno"></span><span class="codebody">AX</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> COUNTBLANK</span>
+<span class="lineno"></span><span class="codebody">IN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> COUNTIF</span>
+<span class="lineno"></span><span class="codebody">LLAR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> COUNTIFS</span>
+<span class="lineno"></span><span class="codebody">UM</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> COVAR</span>
+<span class="lineno"></span><span class="codebody">ATE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> CRITBINOM</span>
+<span class="lineno"></span><span class="codebody">MONTH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> DATE</span>
+<span class="lineno"></span><span class="codebody">ROR.TYPE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> DATEDIF</span>
+<span class="lineno"></span><span class="codebody">EN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> DATESTRING</span>
+<span class="lineno"></span><span class="codebody">ACT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> DAVERAGE</span>
+<span class="lineno"></span><span class="codebody">P</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> DAY</span>
+<span class="lineno"></span><span class="codebody">CT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> DAYS360</span>
+<span class="lineno"></span><span class="codebody">CTDOUBLE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> DB</span>
+<span class="lineno"></span><span class="codebody">LSE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> DBCS</span>
+<span class="lineno"></span><span class="codebody">ND</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> DCOUNT</span>
+<span class="lineno"></span><span class="codebody">XED</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> DCOUNTA</span>
+<span class="lineno"></span><span class="codebody">OOR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> DDB</span>
+<span class="lineno"></span><span class="codebody">EQUENCY</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> DEC2BIN</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> DEC2HEX</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> DEGREES</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> DELTA</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> DEVSQ</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> DGET</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> DMAX</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> DMIN</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> DOLLAR</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> DPRODUCT</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> DSTDEV</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> DSTDEVP</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> DSUM</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> DVAR</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> DVARP</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> EDATE</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> ENABLE.TOOL</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> END.IF</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> EOMONTH</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> ERROR</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> ERROR.TYPE</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> EVALUATE</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> EVEN</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> EXACT</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> EXEC</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> EXP</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> EXPONDIST</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> FACT</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> FACTDOUBLE</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> FALSE</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> FDIST</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> FIND</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> FINDB</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> FINV</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> FISHER</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> FISHERINV</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> FIXED</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> FLOOR</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> FORECAST</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> FREQUENCY</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> FTEST</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> FV</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> GAMMADIST</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> GAMMAINV</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> GAMMALN</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> GEOMEAN</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> GET.CELL</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> GET.DOCUMENT</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> GET.WINDOW</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> GET.WORKBOOK</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> GET.WORKSPACE</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> GETPIVOTDATA</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> GOTO</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> GROWTH</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> HARMEAN</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> HEX2DEC</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> HLOOKUP</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> HOUR</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> HYPERLINK</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> HYPGEOMDIST</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> IF</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> IFS</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> IFERROR</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> IFNA</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> IMAGINARY</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> IMREAL</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> INDEX</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> INDIRECT</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> INFO</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> INT</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> INTERCEPT</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> IPMT</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> IRR</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> ISBLANK</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> ISERR</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> ISERROR</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> ISEVEN</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> ISLOGICAL</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> ISNA</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> ISNONTEXT</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> ISNUMBER</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> ISODD</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> ISPMT</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> ISREF</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> ISTEXT</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> JIS</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> KURT</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> LARGE</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> LAST.ERROR</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> LEFT</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> LEFTB</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> LEN</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> LENB</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> LINEST</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> LINEST</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> LN</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> LOG</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> LOG10</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> LOGEST</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> LOGEST</span>
-</div>
-<div class="codeline">
-<span class="lineno"></span><span class="codebody"> LOGINV</span>
+<span class="lineno"></span><span class="codebody"></span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> LOGNORMDIST</span>
+<span class="lineno"></span><span class="codebody">OMEAN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> LOOKUP</span>
+<span class="lineno"></span><span class="codebody">X2DEC</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> LOWER</span>
+<span class="lineno"></span><span class="codebody">OOKUP</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MATCH</span>
+<span class="lineno"></span><span class="codebody">UR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MAX</span>
+<span class="lineno"></span><span class="codebody">PERLINK</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MAXA</span>
+<span class="lineno"></span><span class="codebody"></span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MDETERM</span>
+<span class="lineno"></span><span class="codebody">ERROR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MEDIAN</span>
+<span class="lineno"></span><span class="codebody">NA</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MID</span>
+<span class="lineno"></span><span class="codebody">S</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MIDB</span>
+<span class="lineno"></span><span class="codebody">AGINARY</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MIN</span>
+<span class="lineno"></span><span class="codebody">REAL</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MINA</span>
+<span class="lineno"></span><span class="codebody">DEX</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MINUTE</span>
+<span class="lineno"></span><span class="codebody">DIRECT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MINVERSE</span>
+<span class="lineno"></span><span class="codebody">T</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MIRR</span>
+<span class="lineno"></span><span class="codebody">TERCEPT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MMULT</span>
+<span class="lineno"></span><span class="codebody">MT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MOD</span>
+<span class="lineno"></span><span class="codebody">R</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MODE</span>
+<span class="lineno"></span><span class="codebody">BLANK</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MONTH</span>
+<span class="lineno"></span><span class="codebody">ERR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> MROUND</span>
+<span class="lineno"></span><span class="codebody">ERROR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> N</span>
+<span class="lineno"></span><span class="codebody">EVEN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> NA</span>
+<span class="lineno"></span><span class="codebody">LOGICAL</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> NEGBINOMDIST</span>
+<span class="lineno"></span><span class="codebody">NA</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> NETWORKDAYS</span>
+<span class="lineno"></span><span class="codebody">NONTEXT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> NORMDIST</span>
+<span class="lineno"></span><span class="codebody">NUMBER</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> NORMINV</span>
+<span class="lineno"></span><span class="codebody">ODD</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> NORMSDIST</span>
+<span class="lineno"></span><span class="codebody">REF</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> NORMSINV</span>
+<span class="lineno"></span><span class="codebody">TEXT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> NOT</span>
+<span class="lineno"></span><span class="codebody">RGE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> NOW</span>
+<span class="lineno"></span><span class="codebody">FT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> NPER</span>
+<span class="lineno"></span><span class="codebody">N</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> NPV</span>
+<span class="lineno"></span><span class="codebody"></span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> NUMBERSTRING</span>
+<span class="lineno"></span><span class="codebody">G</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> OCT2DEC</span>
+<span class="lineno"></span><span class="codebody">G10</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ODD</span>
+<span class="lineno"></span><span class="codebody">OKUP</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> OFFSET</span>
+<span class="lineno"></span><span class="codebody">WER</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> OR</span>
+<span class="lineno"></span><span class="codebody">TCH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> PEARSON</span>
+<span class="lineno"></span><span class="codebody">X</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> PERCENTILE</span>
+<span class="lineno"></span><span class="codebody">XA</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> PERCENTRANK</span>
+<span class="lineno"></span><span class="codebody">XIFS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> PERMUT</span>
+<span class="lineno"></span><span class="codebody">ETERM</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> PHONETIC</span>
+<span class="lineno"></span><span class="codebody">DIAN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> PI</span>
+<span class="lineno"></span><span class="codebody">D</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> PMT</span>
+<span class="lineno"></span><span class="codebody">N</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> POISSON</span>
+<span class="lineno"></span><span class="codebody">NA</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> POWER</span>
+<span class="lineno"></span><span class="codebody">NIFS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> PPMT</span>
+<span class="lineno"></span><span class="codebody">NUTE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> PRESS.TOOL</span>
+<span class="lineno"></span><span class="codebody">NVERSE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> PROB</span>
+<span class="lineno"></span><span class="codebody">RR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> PRODUCT</span>
+<span class="lineno"></span><span class="codebody">ULT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> PROPER</span>
+<span class="lineno"></span><span class="codebody">D</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> PV</span>
+<span class="lineno"></span><span class="codebody">DE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> QUARTILE</span>
+<span class="lineno"></span><span class="codebody">NTH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> QUOTIENT</span>
+<span class="lineno"></span><span class="codebody">OUND</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> RADIANS</span>
+<span class="lineno"></span><span class="codebody"></span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> RAND</span>
+<span class="lineno"></span><span class="codebody">TWORKDAYS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> RANDBETWEEN</span>
+<span class="lineno"></span><span class="codebody">T</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> RANK</span>
+<span class="lineno"></span><span class="codebody">W</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> RATE</span>
+<span class="lineno"></span><span class="codebody">ER</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> REGISTER.ID</span>
+<span class="lineno"></span><span class="codebody">V</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> RELREF</span>
+<span class="lineno"></span><span class="codebody">T2DEC</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> REPLACEB</span>
+<span class="lineno"></span><span class="codebody">D</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> REPLACE</span>
+<span class="lineno"></span><span class="codebody">FSET</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> REPT</span>
+<span class="lineno"></span><span class="codebody"></span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> RETURN</span>
+<span class="lineno"></span><span class="codebody">RCENTILE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> RIGHT</span>
+<span class="lineno"></span><span class="codebody">RCENTRANK</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> RIGHTB</span>
+<span class="lineno"></span><span class="codebody">RCENTRANK.EXC</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ROMAN</span>
+<span class="lineno"></span><span class="codebody">RCENTRANK.INC</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ROUND</span>
+<span class="lineno"></span><span class="codebody"></span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ROUNDDOWN</span>
+<span class="lineno"></span><span class="codebody">T</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ROUNDUP</span>
+<span class="lineno"></span><span class="codebody">ISSON</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ROW</span>
+<span class="lineno"></span><span class="codebody">WER</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ROWS</span>
+<span class="lineno"></span><span class="codebody">MT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> RSQ</span>
+<span class="lineno"></span><span class="codebody">ODUCT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SAVE.TOOLBAR</span>
+<span class="lineno"></span><span class="codebody">OPER</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SEARCH</span>
+<span class="lineno"></span><span class="codebody"></span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SEARCHB</span>
+<span class="lineno"></span><span class="codebody">OTIENT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SECOND</span>
+<span class="lineno"></span><span class="codebody">DIANS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SIGN</span>
+<span class="lineno"></span><span class="codebody">ND</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SIN</span>
+<span class="lineno"></span><span class="codebody">NDBETWEEN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SINGLE</span>
+<span class="lineno"></span><span class="codebody">NK</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SINH</span>
+<span class="lineno"></span><span class="codebody">TE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SKEW</span>
+<span class="lineno"></span><span class="codebody">PLACE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SLN</span>
+<span class="lineno"></span><span class="codebody">PT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SLOPE</span>
+<span class="lineno"></span><span class="codebody">GHT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SMALL</span>
+<span class="lineno"></span><span class="codebody">MAN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SQRT</span>
+<span class="lineno"></span><span class="codebody">UND</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> STANDARDIZE</span>
+<span class="lineno"></span><span class="codebody">UNDDOWN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> STDEV</span>
+<span class="lineno"></span><span class="codebody">UNDUP</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> STDEVA</span>
+<span class="lineno"></span><span class="codebody">W</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> STDEVP</span>
+<span class="lineno"></span><span class="codebody">WS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> STDEVPA</span>
+<span class="lineno"></span><span class="codebody">ARCH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> STEP</span>
+<span class="lineno"></span><span class="codebody">COND</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> STEYX</span>
+<span class="lineno"></span><span class="codebody">GN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SUBSTITUTE</span>
+<span class="lineno"></span><span class="codebody">N</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SUBTOTAL</span>
+<span class="lineno"></span><span class="codebody">NGLE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SUM</span>
+<span class="lineno"></span><span class="codebody">NH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SUMIF</span>
+<span class="lineno"></span><span class="codebody">OPE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SUMIFS</span>
+<span class="lineno"></span><span class="codebody">ALL</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SUMPRODUCT</span>
+<span class="lineno"></span><span class="codebody">RT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SUMSQ</span>
+<span class="lineno"></span><span class="codebody">DEV</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SUMX2MY2</span>
+<span class="lineno"></span><span class="codebody">BSTITUTE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SUMX2PY2</span>
+<span class="lineno"></span><span class="codebody">BTOTAL</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SUMXMY2</span>
+<span class="lineno"></span><span class="codebody">M</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> SYD</span>
+<span class="lineno"></span><span class="codebody">MIF</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> T</span>
+<span class="lineno"></span><span class="codebody">MIFS</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TAN</span>
+<span class="lineno"></span><span class="codebody">MPRODUCT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TANH</span>
+<span class="lineno"></span><span class="codebody">MSQ</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TDIST</span>
+<span class="lineno"></span><span class="codebody">MX2MY2</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TEXT</span>
+<span class="lineno"></span><span class="codebody">MX2PY2</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TEXTJOIN</span>
+<span class="lineno"></span><span class="codebody">MXMY2</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TIME</span>
+<span class="lineno"></span><span class="codebody">ITCH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TIMEVALUE</span>
+<span class="lineno"></span><span class="codebody"></span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TINV</span>
+<span class="lineno"></span><span class="codebody">DIST</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TODAY</span>
+<span class="lineno"></span><span class="codebody">DIST.2T</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TRANSPOSE</span>
+<span class="lineno"></span><span class="codebody">DIST.RT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TREND</span>
+<span class="lineno"></span><span class="codebody">N</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TRIM</span>
+<span class="lineno"></span><span class="codebody">NH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TRIMMEAN</span>
+<span class="lineno"></span><span class="codebody">IST</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TRUE</span>
+<span class="lineno"></span><span class="codebody">XT</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TRUNC</span>
+<span class="lineno"></span><span class="codebody">XTJOIN</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TTEST</span>
+<span class="lineno"></span><span class="codebody">ME</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> TYPE</span>
+<span class="lineno"></span><span class="codebody">MEVALUE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> UPPER</span>
+<span class="lineno"></span><span class="codebody">DAY</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> USDOLLAR</span>
+<span class="lineno"></span><span class="codebody">ANSPOSE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> VALUE</span>
+<span class="lineno"></span><span class="codebody">END</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> VAR</span>
+<span class="lineno"></span><span class="codebody">IM</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> VARA</span>
+<span class="lineno"></span><span class="codebody">UE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> VARP</span>
+<span class="lineno"></span><span class="codebody">UNC</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> VARPA</span>
+<span class="lineno"></span><span class="codebody">PER</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> VDB</span>
+<span class="lineno"></span><span class="codebody">LUE</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> VLOOKUP</span>
+<span class="lineno"></span><span class="codebody">R</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> WEEKDAY</span>
+<span class="lineno"></span><span class="codebody">RP</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> WEEKNUM</span>
+<span class="lineno"></span><span class="codebody">OOKUP</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> WEIBULL</span>
+<span class="lineno"></span><span class="codebody">EKDAY</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> WINDOW.TITLE</span>
+<span class="lineno"></span><span class="codebody">EKNUM</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> WORKDAY</span>
+<span class="lineno"></span><span class="codebody">RKDAY</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> YEAR</span>
+<span class="lineno"></span><span class="codebody">OOKUP</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> YEARFRAC</span>
+<span class="lineno"></span><span class="codebody">ATCH</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> YEN</span>
+<span class="lineno"></span><span class="codebody">AR</span>
 </div>
 <div class="codeline">
-<span class="lineno"></span><span class="codebody"> ZTEST</span>
+<span class="lineno"></span><span class="codebody">ARFRAC</span>
 </div>
 </div>
 </div>

Modified: poi/site/publish/encryption.html
URL: http://svn.apache.org/viewvc/poi/site/publish/encryption.html?rev=1897499&r1=1897498&r2=1897499&view=diff
==============================================================================
--- poi/site/publish/encryption.html (original)
+++ poi/site/publish/encryption.html Wed Jan 26 11:58:55 2022
@@ -566,7 +566,7 @@ document.write("Last Published: " + docu
             
 <li>Apache Santuario "xmlsec" (tested against 2.3.0)</li>
             
-<li>and slf4j-api (tested against 1.7.32)</li>
+<li>and slf4j-api (tested against 1.7.x)</li>
         
 </ul>
 <p>Depending on the <a href="apidocs/dev/org/apache/poi/poifs/crypt/dsig/SignatureConfig.html">configuration</a>



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