You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ni...@apache.org on 2015/11/24 18:40:33 UTC
svn commit: r1716222 - in /poi/site: publish/spreadsheet/eval-devguide.html
src/documentation/content/xdocs/spreadsheet/eval-devguide.xml
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