poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From n...@apache.org
Subject svn commit: r1716222 - in /poi/site: publish/spreadsheet/eval-devguide.html src/documentation/content/xdocs/spreadsheet/eval-devguide.xml
Date Tue, 24 Nov 2015 17:40:33 GMT
Author: nick
Date: Tue Nov 24 17:40:33 2015
New Revision: 1716222

URL: http://svn.apache.org/viewvc?rev=1716222&view=rev
Log:
Update supported functions list

Modified:
    poi/site/publish/spreadsheet/eval-devguide.html
    poi/site/src/documentation/content/xdocs/spreadsheet/eval-devguide.xml

Modified: poi/site/publish/spreadsheet/eval-devguide.html
URL: http://svn.apache.org/viewvc/poi/site/publish/spreadsheet/eval-devguide.html?rev=1716222&r1=1716221&r2=1716222&view=diff
==============================================================================
--- poi/site/publish/spreadsheet/eval-devguide.html (original)
+++ poi/site/publish/spreadsheet/eval-devguide.html Tue Nov 24 17:40:33 2015
@@ -270,7 +270,7 @@ if (VERSION > 3) {
 </div>
             
 <p>
-                As of Feb 2012, POI supports about 140 built-in functions,
+                As of Nov 2015, POI supports about 170 built-in functions,
                 see <a href="#appendixA">Appendix A</a> for the full list.
                 You can programmatically list supported / unsuported functions using the
following helper methods:
             </p>
@@ -461,7 +461,7 @@ if (VERSION > 3) {
 </div>
            
             
-<p>Functions supported by POI ( as of Feb 2012)</p>
+<p>Functions supported by POI (as of Nov 2015)</p>
             
 <pre class="code">
     ABS
@@ -476,13 +476,16 @@ if (VERSION > 3) {
     ATANH
     AVEDEV
     AVERAGE
+    BIN2DEC
     CEILING
     CHAR
     CHOOSE
     CLEAN
+    CODE
     COLUMN
     COLUMNS
     COMBIN
+    COMPLEX
     CONCATENATE
     COS
     COSH
@@ -490,30 +493,47 @@ if (VERSION > 3) {
     COUNTA
     COUNTBLANK
     COUNTIF
+    COUNTIFS
     DATE
     DAY
     DAYS360
+    DEC2BIN
+    DEC2HEX
     DEGREES
+    DELTA
     DEVSQ
+    DGET
+    DMIN
     DOLLAR
+    EDATE
+    EOMONTH
     ERROR.TYPE
     EVEN
     EXACT
     EXP
     FACT
+    FACTDOUBLE
     FALSE
     FIND
+    FIXED
     FLOOR
     FV
+    HEX2DEC
     HLOOKUP
     HOUR
     HYPERLINK
     IF
+    IFERROR
+    IMAGINARY
+    IMREAL
     INDEX
     INDIRECT
     INT
+    INTERCEPT
+    IPMT
     IRR
     ISBLANK
+    ISERR
     ISERROR
     ISEVEN
     ISLOGICAL
@@ -539,6 +559,7 @@ if (VERSION > 3) {
     MIN
     MINA
     MINUTE
+    MIRR
     MOD
     MODE
     MONTH
@@ -549,22 +570,29 @@ if (VERSION > 3) {
     NOW
     NPER
     NPV
+    OCT2DEC
     ODD
     OFFSET
     OR
+    PERCENTILE
     PI
     PMT
     POISSON
     POWER
+    PPMT
     PRODUCT
+    PROPER
     PV
+    QUOTIENT
     RADIANS
     RAND
     RANDBETWEEN
     RANK
     RATE
     REPLACE
+    REPT
     RIGHT
+    ROMAN
     ROUND
     ROUNDDOWN
     ROUNDUP
@@ -575,6 +603,7 @@ if (VERSION > 3) {
     SIGN
     SIN
     SINH
+    SLOPE
     SMALL
     SQRT
     STDEV
@@ -603,6 +632,7 @@ if (VERSION > 3) {
     VARP
     VLOOKUP
     WEEKDAY
+    WEEKNUM
     WORKDAY
     YEAR
     YEARFRAC

Modified: poi/site/src/documentation/content/xdocs/spreadsheet/eval-devguide.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/spreadsheet/eval-devguide.xml?rev=1716222&r1=1716221&r2=1716222&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/spreadsheet/eval-devguide.xml (original)
+++ poi/site/src/documentation/content/xdocs/spreadsheet/eval-devguide.xml Tue Nov 24 17:40:33
2015
@@ -86,7 +86,7 @@
 
         <section><title>What functions are supported?</title>
             <p>
-                As of Feb 2012, POI supports about 140 built-in functions,
+                As of Nov 2015, POI supports about 170 built-in functions,
                 see <link href="#appendixA">Appendix A</link> for the full list.
                 You can programmatically list supported / unsuported functions using the
following helper methods:
             </p>
@@ -226,7 +226,7 @@
         <anchor id="appendixA"/>
         <section>
            <title>Appendix A</title>
-            <p>Functions supported by POI ( as of Feb 2012)</p>
+            <p>Functions supported by POI (as of Nov 2015)</p>
             <source>
     ABS
     ACOS
@@ -240,13 +240,16 @@
     ATANH
     AVEDEV
     AVERAGE
+    BIN2DEC
     CEILING
     CHAR
     CHOOSE
     CLEAN
+    CODE
     COLUMN
     COLUMNS
     COMBIN
+    COMPLEX
     CONCATENATE
     COS
     COSH
@@ -254,30 +257,47 @@
     COUNTA
     COUNTBLANK
     COUNTIF
+    COUNTIFS
     DATE
     DAY
     DAYS360
+    DEC2BIN
+    DEC2HEX
     DEGREES
+    DELTA
     DEVSQ
+    DGET
+    DMIN
     DOLLAR
+    EDATE
+    EOMONTH
     ERROR.TYPE
     EVEN
     EXACT
     EXP
     FACT
+    FACTDOUBLE
     FALSE
     FIND
+    FIXED
     FLOOR
     FV
+    HEX2DEC
     HLOOKUP
     HOUR
     HYPERLINK
     IF
+    IFERROR
+    IMAGINARY
+    IMREAL
     INDEX
     INDIRECT
     INT
+    INTERCEPT
+    IPMT
     IRR
     ISBLANK
+    ISERR
     ISERROR
     ISEVEN
     ISLOGICAL
@@ -303,6 +323,7 @@
     MIN
     MINA
     MINUTE
+    MIRR
     MOD
     MODE
     MONTH
@@ -313,22 +334,29 @@
     NOW
     NPER
     NPV
+    OCT2DEC
     ODD
     OFFSET
     OR
+    PERCENTILE
     PI
     PMT
     POISSON
     POWER
+    PPMT
     PRODUCT
+    PROPER
     PV
+    QUOTIENT
     RADIANS
     RAND
     RANDBETWEEN
     RANK
     RATE
     REPLACE
+    REPT
     RIGHT
+    ROMAN
     ROUND
     ROUNDDOWN
     ROUNDUP
@@ -339,6 +367,7 @@
     SIGN
     SIN
     SINH
+    SLOPE
     SMALL
     SQRT
     STDEV
@@ -367,6 +396,7 @@
     VARP
     VLOOKUP
     WEEKDAY
+    WEEKNUM
     WORKDAY
     YEAR
     YEARFRAC



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


Mime
View raw message