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:57:24 UTC
svn commit: r1897498 - /poi/site/src/documentation/content/xdocs/components/spreadsheet/eval-devguide.xml
Author: fanningpj
Date: Wed Jan 26 11:57:24 2022
New Revision: 1897498
URL: http://svn.apache.org/viewvc?rev=1897498&view=rev
Log:
update functions list
Modified:
poi/site/src/documentation/content/xdocs/components/spreadsheet/eval-devguide.xml
Modified: poi/site/src/documentation/content/xdocs/components/spreadsheet/eval-devguide.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/spreadsheet/eval-devguide.xml?rev=1897498&r1=1897497&r2=1897498&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/components/spreadsheet/eval-devguide.xml (original)
+++ poi/site/src/documentation/content/xdocs/components/spreadsheet/eval-devguide.xml Wed Jan 26 11:57:24 2022
@@ -96,8 +96,8 @@
</section>
<section><title>What functions are supported?</title>
<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>
<source>import org.apache.poi.ss.formula.ss.formula.WorkbookEvaluator;
@@ -115,7 +115,7 @@ Collection<String> unsupportedFunc
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.
@@ -382,310 +382,210 @@ private static Function[] produceFunctio
<section>
<title>Appendix A — Functions supported by POI</title>
<p>
- Functions supported by POI (as of July 2021)
+ Functions supported by POI (as of v5.2.0 release)
</p>
<source> ABS
- ABSREF
- ACOS
- ACOSH
- ADDRESS
- AND
- APP.TITLE
- AREAS
- ARGUMENT
- ASC
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- AVEDEV
- AVERAGE
- AVERAGEA
- BETADIST
- BETAINV
- BINOMDIST
- BIN2DEC
- CALL
- CEILING
- CELL
- CHAR
- CHIDIST
- CHIINV
- CHITEST
- CHOOSE
- CLEAN
- CODE
- COLUMN
- COLUMNS
- COMBIN
- COMPLEX
- CONCAT
- CONCATENATE
- CONFIDENCE
- CORREL
- COS
- COSH
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DATE
- DATEDIF
- DATESTRING
- DAVERAGE
- DAY
- DAYS360
- DB
- DBCS
- DCOUNT
- DCOUNTA
- DDB
- DEC2BIN
- DEC2HEX
- DEGREES
- DELTA
- DEVSQ
- DGET
- DMAX
- DMIN
- DOLLAR
- DPRODUCT
- DSTDEV
- DSTDEVP
- DSUM
- DVAR
- DVARP
- EDATE
- ENABLE.TOOL
- END.IF
- EOMONTH
- ERROR
- ERROR.TYPE
- EVALUATE
- EVEN
- EXACT
- EXEC
- EXP
- EXPONDIST
- FACT
- FACTDOUBLE
- FALSE
- FDIST
- FIND
- FINDB
- FINV
- FISHER
- FISHERINV
- FIXED
- FLOOR
- FORECAST
- FREQUENCY
- FTEST
- FV
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- GET.CELL
- GET.DOCUMENT
- GET.WINDOW
- GET.WORKBOOK
- GET.WORKSPACE
- GETPIVOTDATA
- GOTO
- GROWTH
- HARMEAN
- HEX2DEC
- HLOOKUP
- HOUR
- HYPERLINK
- HYPGEOMDIST
- IF
- IFS
- IFERROR
- IFNA
- IMAGINARY
- IMREAL
- INDEX
- INDIRECT
- INFO
- INT
- INTERCEPT
- IPMT
- IRR
- ISBLANK
- ISERR
- ISERROR
- ISEVEN
- ISLOGICAL
- ISNA
- ISNONTEXT
- ISNUMBER
- ISODD
- ISPMT
- ISREF
- ISTEXT
- JIS
- KURT
- LARGE
- LAST.ERROR
- LEFT
- LEFTB
- LEN
- LENB
- LINEST
- LINEST
- LN
- LOG
- LOG10
- LOGEST
- LOGEST
- LOGINV
- LOGNORMDIST
- LOOKUP
- LOWER
- MATCH
- MAX
- MAXA
- MDETERM
- MEDIAN
- MID
- MIDB
- MIN
- MINA
- MINUTE
- MINVERSE
- MIRR
- MMULT
- MOD
- MODE
- MONTH
- MROUND
- N
- NA
- NEGBINOMDIST
- NETWORKDAYS
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- NOT
- NOW
- NPER
- NPV
- NUMBERSTRING
- OCT2DEC
- ODD
- OFFSET
- OR
- PEARSON
- PERCENTILE
- PERCENTRANK
- PERMUT
- PHONETIC
- PI
- PMT
- POISSON
- POWER
- PPMT
- PRESS.TOOL
- PROB
- PRODUCT
- PROPER
- PV
- QUARTILE
- QUOTIENT
- RADIANS
- RAND
- RANDBETWEEN
- RANK
- RATE
- REGISTER.ID
- RELREF
- REPLACEB
- REPLACE
- REPT
- RETURN
- RIGHT
- RIGHTB
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- ROW
- ROWS
- RSQ
- SAVE.TOOLBAR
- SEARCH
- SEARCHB
- SECOND
- SIGN
- SIN
- SINGLE
- SINH
- SKEW
- SLN
- SLOPE
- SMALL
- SQRT
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- STEP
- STEYX
- SUBSTITUTE
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- SYD
- T
- TAN
- TANH
- TDIST
- TEXT
- TEXTJOIN
- TIME
- TIMEVALUE
- TINV
- TODAY
- TRANSPOSE
- TREND
- TRIM
- TRIMMEAN
- TRUE
- TRUNC
- TTEST
- TYPE
- UPPER
- USDOLLAR
- VALUE
- VAR
- VARA
- VARP
- VARPA
- VDB
- VLOOKUP
- WEEKDAY
- WEEKNUM
- WEIBULL
- WINDOW.TITLE
- WORKDAY
- YEAR
- YEARFRAC
- YEN
- ZTEST</source>
+ ACOS
+ ACOSH
+ ADDRESS
+ AND
+ AREAS
+ ASIN
+ ASINH
+ ATAN
+ ATAN2
+ ATANH
+ AVEDEV
+ AVERAGE
+ AVERAGEIFS
+ BIN2DEC
+ CEILING
+ CHAR
+ CHOOSE
+ CLEAN
+ CODE
+ COLUMN
+ COLUMNS
+ COMBIN
+ COMPLEX
+ CONCAT
+ CONCATENATE
+ COS
+ COSH
+ COUNT
+ COUNTA
+ COUNTBLANK
+ COUNTIF
+ COUNTIFS
+ DATE
+ DATEVALUE
+ DAY
+ DAYS360
+ DEC2BIN
+ DEC2HEX
+ DEGREES
+ DELTA
+ DEVSQ
+ DGET
+ DMAX
+ DMIN
+ DOLLAR
+ DSUM
+ EDATE
+ EOMONTH
+ ERROR.TYPE
+ EVEN
+ EXACT
+ EXP
+ FACT
+ FACTDOUBLE
+ FALSE
+ FIND
+ FIXED
+ FLOOR
+ FREQUENCY
+ FV
+ GEOMEAN
+ HEX2DEC
+ HLOOKUP
+ HOUR
+ HYPERLINK
+ IF
+ IFERROR
+ IFNA
+ IFS
+ IMAGINARY
+ IMREAL
+ INDEX
+ INDIRECT
+ INT
+ INTERCEPT
+ IPMT
+ IRR
+ ISBLANK
+ ISERR
+ ISERROR
+ ISEVEN
+ ISLOGICAL
+ ISNA
+ ISNONTEXT
+ ISNUMBER
+ ISODD
+ ISREF
+ ISTEXT
+ LARGE
+ LEFT
+ LEN
+ LN
+ LOG
+ LOG10
+ LOOKUP
+ LOWER
+ MATCH
+ MAX
+ MAXA
+ MAXIFS
+ MDETERM
+ MEDIAN
+ MID
+ MIN
+ MINA
+ MINIFS
+ MINUTE
+ MINVERSE
+ MIRR
+ MMULT
+ MOD
+ MODE
+ MONTH
+ MROUND
+ NA
+ NETWORKDAYS
+ NOT
+ NOW
+ NPER
+ NPV
+ OCT2DEC
+ ODD
+ OFFSET
+ OR
+ PERCENTILE
+ PERCENTRANK
+ PERCENTRANK.EXC
+ PERCENTRANK.INC
+ PI
+ PMT
+ POISSON
+ POWER
+ PPMT
+ PRODUCT
+ PROPER
+ PV
+ QUOTIENT
+ RADIANS
+ RAND
+ RANDBETWEEN
+ RANK
+ RATE
+ REPLACE
+ REPT
+ RIGHT
+ ROMAN
+ ROUND
+ ROUNDDOWN
+ ROUNDUP
+ ROW
+ ROWS
+ SEARCH
+ SECOND
+ SIGN
+ SIN
+ SINGLE
+ SINH
+ SLOPE
+ SMALL
+ SQRT
+ STDEV
+ SUBSTITUTE
+ SUBTOTAL
+ SUM
+ SUMIF
+ SUMIFS
+ SUMPRODUCT
+ SUMSQ
+ SUMX2MY2
+ SUMX2PY2
+ SUMXMY2
+ SWITCH
+ T
+ T.DIST
+ T.DIST.2T
+ T.DIST.RT
+ TAN
+ TANH
+ TDIST
+ TEXT
+ TEXTJOIN
+ TIME
+ TIMEVALUE
+ TODAY
+ TRANSPOSE
+ TREND
+ TRIM
+ TRUE
+ TRUNC
+ UPPER
+ VALUE
+ VAR
+ VARP
+ VLOOKUP
+ WEEKDAY
+ WEEKNUM
+ WORKDAY
+ XLOOKUP
+ XMATCH
+ YEAR
+ YEARFRAC</source>
</section>
</body>
</document>
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org