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:08 UTC
svn commit: r1897500 - /poi/site/src/documentation/content/xdocs/components/spreadsheet/eval-devguide.xml
Author: fanningpj
Date: Wed Jan 26 12:10:08 2022
New Revision: 1897500
URL: http://svn.apache.org/viewvc?rev=1897500&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=1897500&r1=1897499&r2=1897500&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 12:10:08 2022
@@ -384,208 +384,208 @@ private static Function[] produceFunctio
<p>
Functions supported by POI (as of v5.2.0 release)
</p>
-<source> ABS
- 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>
+<source>ABS
+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