Wikifunctions:OpenFunctions
documentation
- https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html
- https://wiki.documentfoundation.org/module:calc_fn_name/data
- https://github.com/LibreOffice/core/tree/master/formula
- https://gitlab.com/search?project_id=13209615&group_id=5586175&search=formula&search_code=true&repository_ref=master
- https://gitlab.gnome.org/search?project_id=1547&group_id=8search=openformula&&search_code=true&repository_ref=master
- https://community.kde.org/Calligra/Formula_Shape
types
- Text (String)
- Number
- Time
- Date
- DateTime
- Percentage
- Currency
- Logical (Number)
- Complex Number
- Logical (Boolean)
- Error
- Empty Cell
- Reference
- ReferenceList
- Array
- Pseudotypes
- Scalar
- DateParam
- TimeParam
- Integer
- TextOrNumber
- Basis
- Criterion
- Database
- Field
- Criteria
- Sequences
- NumberSequence
- NumberSequenceList
- DateSequence
- LogicalSequence
- ComplexSequence
- Any
conversion
- to Scalar
- Implied intersection
- Force to array context (ForceArray)
- to Number
- to Integer
- to NumberSequence
- to NumberSequenceList
- to DateSequence
- to Complex Number
- to ComplexSequence
- to Logical
- to LogicalSequence
- to Text
- to DateParam
- to TimeParam
functions
operators
prefix
- + (positive)
- - (negative)
infix
- + (add)
- - (subtract)
- * (multiply)
- / (divide)
- unordered comparisons
- = (equal to)
- <> (not equal to)
- ordered comparisons
- < (less than)
- <= (less than or equal to)
- > (greater than)
- >= (greater than or equal to)
- &
- : (reference range)
- null string
- ! (reference intersection)
- ~ (concatenation/union)
postfix
- % (percent)
matrix
- MDETERM
- MINVERSE
- MMULT
- MUNIT
- TRANSPOSE
bit operations
- BITAND
- BITLSHIFT
- BITOR
- BITRSHIFT
- BITXOR
byte-position (text)
- FINDB
- LEFTB
- LENB
- MIDB
- REPLACEB
- RIGHTB
- SEARCHB
complex numbers
- COMPLEX
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMCOSH
- IMCOT
- IMCSC
- IMCSCH
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSIN
- IMSINH
- IMSEC
- IMSECH
- IMSQRT
- IMSUB
- IMSUM
- IMTAN
database
- DAVERAGE
- DCOUNT
- DCOUNTA
- DGET
- DMAX
- DMIN
- DPRODUCT
- DSTDEV
- DSTDEVP
- DSUM
- DVAR
- DVARP
date and time
- DATE
- DATEDIF
- DATEVALUE
- DAY
- DAYS
- DAYS360
- EDATE
- EOMONTH
- HOUR
- ISOWEEKNUM
- MINUTE
- MONTH
- NETWORKDAYS
- NOW
- SECOND
- TIME
- TIMEVALUE
- TODAY
- WEEKDAY
- WEEKNUM
- WORKDAY
- YEAR
- YEARFRAC
external access
- DDE
- HYPERLINK
financial
- ACCRINT
- ACCRINTM
- AMORLINC
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CUMIPMT
- CUMPRINC
- DB
- DDB
- DISC
- DOLLARDE
- DOLLARFR
- DURATION
- EFFECT
- FV
- FVSCHEDULE
- INTRATE
- IPMT
- IRR
- ISPMT
- MDURATION
- MIRR
- NOMINAL
- NPER
- NPV
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- PDURATION
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- RRI
- SLN
- SYD
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
information
- AREAS
- CELL
- COLUMN
- COLUMNS
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- ERROR.TYPE
- FORMULA
- INFO
- ISBLANK
- ISERR
- ISERROR
- ISEVEN
- ISFORMULA
- ISLOGICAL
- ISNA
- ISNONTEXT
- ISNUMBER
- ISODD
- ISREF
- ISTEXT
- N
- NA
- NUMBERVALUE
- ROW
- ROWS
- SHEET
- SHEETS
- TYPE
- VALUE
lookup
- ADDRESS
- CHOOSE
- GETPIVOTDATA
- HLOOKUP
- INDEX
- INDIRECT
- LOOKUP
- MATCH
- MULTIPLE.OPERATIONS
- OFFSET
- VLOOKUP
logical
- AND
- FALSE
- IF
- IFERROR
- IFNA
- NOT
- OR
- TRUE
- XOR
mathematical
- 6.16.2 ABS
- ACOS
- ACOSH
- ACOT
- ACOTH
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- COMBIN
- COMBINA
- CONVERT
- COS
- COSH
- COT
- COTH
- CSC
- CSCH
- DEGREES
- DELTA
- ERF
- ERFC
- EUROCONVERT
- EVEN
- EXP
- FACT
- FACTDOUBLE
- GAMMA
- GAMMALN
- GCD
- GESTEP
- LCM
- LN
- LOG
- LOG10
- MOD
- MULTINOMIAL
- ODD
- PI
- POWER
- PRODUCT
- QUOTIENT
- RADIANS
- RAND
- RANDBETWEEN
- SEC
- SERIESSUM
- SIGN
- SIN
- SINH
- SECH
- SQRT
- SQRTPI
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TAN
- TANH
rounding
- CEILING
- INT
- FLOOR
- MROUND
- ROUND
- ROUNDDOWN
- ROUNDUP
- TRUNC
statistical
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOM.DIST.RANGE
- BINOMDIST
- LEGACY.CHIDIST
- CHISQDIST
- LEGACY.CHIINV
- CHISQINV
- LEGACY.CHITEST
- CONFIDENCE
- CORREL
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- LEGACY.FDIST
- FINV
- LEGACY.FINV
- FISHER
- FISHERINV
- FORECAST
- FREQUENCY
- FTEST
- GAMMADIST
- GAMMAINV
- GAUSS
- GEOMEAN
- GROWTH
- HARMEAN
- HYPGEOMDIST
- INTERCEPT
- KURT
- LARGE
- LINEST
- LOGEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MEDIAN
- MIN
- MINA
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- LEGACY.NORMSDIST
- LEGACY.NORMSINV
- PEARSON
- PERCENTILE
- PERCENTRANK
- PERMUT
- PERMUTATIONA
- PHI
- POISSON
- PROB
- QUARTILE
- RANK
- RSQ
- SKEW
- SKEWP
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- STEYX
- LEGACY.TDIST
- TINV
- TREND
- TRIMMEAN
- TTEST
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
number representation conversion
- ARABIC
- BASE
- BIN2DEC
- BIN2HEX
- BIN2OCT
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DECIMAL
- HEX2BIN
- HEX2DEC
- HEX2OCT
- OCT2BIN
- OCT2DEC
- OCT2HEX
- ROMAN
text
- ASC
- CHAR
- CLEAN
- CODE
- CONCATENATE
- DOLLAR
- EXACT
- FIND
- FIXED
- JIS
- LEFT
- LEN
- LOWER
- MID
- PROPER
- REPLACE
- REPT
- RIGHT
- SEARCH
- SUBSTITUTE
- T
- TEXT
- TRIM
- UNICHAR
- UNICODE
- UPPER