# ODF 1.4 and Office Excel Function Coverage

## Source
- Canonical inventory: `packages/formula/src/formula-inventory-source.json`
- Generated by: `bun scripts/gen-formula-inventory.ts`
- ODF 1.4 Spreadsheet OpenFormula Formula Functions
- OASIS OpenDocument v1.4 function requirements:
  - https://docs.oasis-open.org/office/OpenDocument/v1.4/os/v1.4-os.html
- Microsoft Office Excel functions by category:
  - https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb
- Scope: ODF mandatory functions + Office by-category function list (merged into one list).

## Coverage Summary
- Unified function count: **525**
- ODF mandatory function count: **59**
- Office function count (cleaned scrape): **508**
- Overlap (present in both): **58**
- ODF-only (mandatory, not listed by Office): **1**
- Office-only (not in ODF 1.4 mandatory): **450**

## Current code coverage snapshot
- Registered in codebase: **525**
- Not yet registered in codebase: **0**
- Placeholder-backed registrations: **0**
- The "Implemented in codebase" column reflects runtime registration, including blocked placeholder registrations.

## Full unified function list (ODF 1.4 mandatory + Office category)

| Function | ODF status | In Office list | Implemented in codebase |
| --- | --- | --- | --- |
| ABS | Not in ODF 1.4 mandatory | Yes | Yes |
| ACCRINT | Implemented | Yes | Yes |
| ACCRINTM | Implemented | Yes | Yes |
| ACOS | Not in ODF 1.4 mandatory | Yes | Yes |
| ACOSH | Implemented | Yes | Yes |
| ACOT | Implemented | Yes | Yes |
| ACOTH | Implemented | Yes | Yes |
| ADDRESS | Placeholder (blocked) | Yes | Yes |
| AGGREGATE | Not in ODF 1.4 mandatory | Yes | Yes |
| AMORDEGRC | Not in ODF 1.4 mandatory | Yes | Yes |
| AMORLINC | Implemented | Yes | Yes |
| AND | Not in ODF 1.4 mandatory | Yes | Yes |
| ARABIC | Implemented | Yes | Yes |
| AREAS | Placeholder (blocked) | Yes | Yes |
| ARRAYTOTEXT | Not in ODF 1.4 mandatory | Yes | Yes |
| ASC | Placeholder (blocked) | Yes | Yes |
| ASIN | Not in ODF 1.4 mandatory | Yes | Yes |
| ASINH | Implemented | Yes | Yes |
| ATAN | Not in ODF 1.4 mandatory | Yes | Yes |
| ATAN2 | Not in ODF 1.4 mandatory | Yes | Yes |
| ATANH | Implemented | Yes | Yes |
| AVEDEV | Placeholder (blocked) | Yes | Yes |
| AVERAGE | Not in ODF 1.4 mandatory | Yes | Yes |
| AVERAGEA | Placeholder (blocked) | Yes | Yes |
| AVERAGEIF | Not in ODF 1.4 mandatory | Yes | Yes |
| AVERAGEIFS | Implemented | Yes | Yes |
| BAHTTEXT | Not in ODF 1.4 mandatory | Yes | Yes |
| BASE | Implemented | Yes | Yes |
| BESSELI | Placeholder (blocked) | Yes | Yes |
| BESSELJ | Placeholder (blocked) | Yes | Yes |
| BESSELK | Placeholder (blocked) | Yes | Yes |
| BESSELY | Placeholder (blocked) | Yes | Yes |
| BETA.DIST | Not in ODF 1.4 mandatory | Yes | Yes |
| BETA.INV | Not in ODF 1.4 mandatory | Yes | Yes |
| BETADIST | Placeholder (blocked) | Yes | Yes |
| BETAINV | Placeholder (blocked) | Yes | Yes |
| BIN2DEC | Placeholder (blocked) | Yes | Yes |
| BIN2HEX | Placeholder (blocked) | Yes | Yes |
| BIN2OCT | Placeholder (blocked) | Yes | Yes |
| BINOM.DIST | Not in ODF 1.4 mandatory | Yes | Yes |
| BINOM.DIST.RANGE | Placeholder (blocked) | Yes | Yes |
| BINOM.INV | Not in ODF 1.4 mandatory | Yes | Yes |
| BINOMDIST | Placeholder (blocked) | Yes | Yes |
| BITAND | Placeholder (blocked) | Yes | Yes |
| BITLSHIFT | Placeholder (blocked) | Yes | Yes |
| BITOR | Placeholder (blocked) | Yes | Yes |
| BITRSHIFT | Placeholder (blocked) | Yes | Yes |
| BITXOR | Placeholder (blocked) | Yes | Yes |
| BYCOL | Not in ODF 1.4 mandatory | Yes | Yes |
| BYROW | Not in ODF 1.4 mandatory | Yes | Yes |
| CALL | Not in ODF 1.4 mandatory | Yes | Yes |
| CEILING | Implemented | Yes | Yes |
| CEILING.MATH | Not in ODF 1.4 mandatory | Yes | Yes |
| CEILING.PRECISE | Not in ODF 1.4 mandatory | Yes | Yes |
| CELL | Not in ODF 1.4 mandatory | Yes | Yes |
| CHAR | Placeholder (blocked) | Yes | Yes |
| CHIDIST | Not in ODF 1.4 mandatory | Yes | Yes |
| CHIINV | Not in ODF 1.4 mandatory | Yes | Yes |
| CHISQ.DIST | Not in ODF 1.4 mandatory | Yes | Yes |
| CHISQ.DIST.RT | Not in ODF 1.4 mandatory | Yes | Yes |
| CHISQ.INV | Not in ODF 1.4 mandatory | Yes | Yes |
| CHISQ.INV.RT | Not in ODF 1.4 mandatory | Yes | Yes |
| CHISQ.TEST | Not in ODF 1.4 mandatory | Yes | Yes |
| CHISQDIST | Missing | No | Yes |
| CHISQINV | Missing | No | Yes |
| CHITEST | Not in ODF 1.4 mandatory | Yes | Yes |
| CHOOSE | Not in ODF 1.4 mandatory | Yes | Yes |
| CHOOSECOLS | Not in ODF 1.4 mandatory | Yes | Yes |
| CHOOSEROWS | Not in ODF 1.4 mandatory | Yes | Yes |
| CLEAN | Placeholder (blocked) | Yes | Yes |
| CODE | Placeholder (blocked) | Yes | Yes |
| COLUMN | Placeholder (blocked) | Yes | Yes |
| COLUMNS | Not in ODF 1.4 mandatory | Yes | Yes |
| COMBIN | Implemented | Yes | Yes |
| COMBINA | Implemented | Yes | Yes |
| COMPLEX | Placeholder (blocked) | Yes | Yes |
| CONCAT | Not in ODF 1.4 mandatory | Yes | Yes |
| CONCATENATE | Placeholder (blocked) | Yes | Yes |
| CONFIDENCE | Placeholder (blocked) | Yes | Yes |
| CONFIDENCE.NORM | Not in ODF 1.4 mandatory | Yes | Yes |
| CONFIDENCE.T | Not in ODF 1.4 mandatory | Yes | Yes |
| CONVERT | Placeholder (blocked) | Yes | Yes |
| CORREL | Placeholder (blocked) | Yes | Yes |
| COS | Not in ODF 1.4 mandatory | Yes | Yes |
| COSH | Implemented | Yes | Yes |
| COT | Implemented | Yes | Yes |
| COTH | Implemented | Yes | Yes |
| COUNT | Not in ODF 1.4 mandatory | Yes | Yes |
| COUNTA | Not in ODF 1.4 mandatory | Yes | Yes |
| COUNTBLANK | Not in ODF 1.4 mandatory | Yes | Yes |
| COUNTIF | Not in ODF 1.4 mandatory | Yes | Yes |
| COUNTIFS | Implemented | Yes | Yes |
| COUPDAYBS | Placeholder (blocked) | Yes | Yes |
| COUPDAYS | Placeholder (blocked) | Yes | Yes |
| COUPDAYSNC | Placeholder (blocked) | Yes | Yes |
| COUPNCD | Placeholder (blocked) | Yes | Yes |
| COUPNUM | Placeholder (blocked) | Yes | Yes |
| COUPPCD | Placeholder (blocked) | Yes | Yes |
| COVAR | Placeholder (blocked) | Yes | Yes |
| COVARIANCE.P | Not in ODF 1.4 mandatory | Yes | Yes |
| COVARIANCE.S | Not in ODF 1.4 mandatory | Yes | Yes |
| CRITBINOM | Placeholder (blocked) | Yes | Yes |
| CSC | Implemented | Yes | Yes |
| CSCH | Implemented | Yes | Yes |
| CUBEKPIMEMBER | Not in ODF 1.4 mandatory | Yes | Yes |
| CUBEMEMBER | Not in ODF 1.4 mandatory | Yes | Yes |
| CUBEMEMBERPROPERTY | Not in ODF 1.4 mandatory | Yes | Yes |
| CUBERANKEDMEMBER | Not in ODF 1.4 mandatory | Yes | Yes |
| CUBESET | Not in ODF 1.4 mandatory | Yes | Yes |
| CUBESETCOUNT | Not in ODF 1.4 mandatory | Yes | Yes |
| CUBEVALUE | Not in ODF 1.4 mandatory | Yes | Yes |
| CUMIPMT | Placeholder (blocked) | Yes | Yes |
| CUMPRINC | Placeholder (blocked) | Yes | Yes |
| DATE | Not in ODF 1.4 mandatory | Yes | Yes |
| DATEDIF | Not in ODF 1.4 mandatory | Yes | Yes |
| DATEVALUE | Placeholder (blocked) | Yes | Yes |
| DAVERAGE | Not in ODF 1.4 mandatory | Yes | Yes |
| DAY | Not in ODF 1.4 mandatory | Yes | Yes |
| DAYS | Placeholder (blocked) | Yes | Yes |
| DAYS360 | Placeholder (blocked) | Yes | Yes |
| DB | Not in ODF 1.4 mandatory | Yes | Yes |
| DBCS | Not in ODF 1.4 mandatory | Yes | Yes |
| DCOUNT | Not in ODF 1.4 mandatory | Yes | Yes |
| DCOUNTA | Not in ODF 1.4 mandatory | Yes | Yes |
| DDB | Not in ODF 1.4 mandatory | Yes | Yes |
| DDE | Missing | No | Yes |
| DEC2BIN | Placeholder (blocked) | Yes | Yes |
| DEC2HEX | Placeholder (blocked) | Yes | Yes |
| DEC2OCT | Placeholder (blocked) | Yes | Yes |
| DECIMAL | Implemented | Yes | Yes |
| DEGREES | Not in ODF 1.4 mandatory | Yes | Yes |
| DELTA | Placeholder (blocked) | Yes | Yes |
| DETECTLANGUAGE | Not in ODF 1.4 mandatory | Yes | Yes |
| DEVSQ | Placeholder (blocked) | Yes | Yes |
| DGET | Not in ODF 1.4 mandatory | Yes | Yes |
| DISC | Placeholder (blocked) | Yes | Yes |
| DMAX | Not in ODF 1.4 mandatory | Yes | Yes |
| DMIN | Not in ODF 1.4 mandatory | Yes | Yes |
| DOLLAR | Not in ODF 1.4 mandatory | Yes | Yes |
| DOLLARDE | Placeholder (blocked) | Yes | Yes |
| DOLLARFR | Placeholder (blocked) | Yes | Yes |
| DPRODUCT | Not in ODF 1.4 mandatory | Yes | Yes |
| DROP | Not in ODF 1.4 mandatory | Yes | Yes |
| DSTDEV | Not in ODF 1.4 mandatory | Yes | Yes |
| DSTDEVP | Not in ODF 1.4 mandatory | Yes | Yes |
| DSUM | Not in ODF 1.4 mandatory | Yes | Yes |
| DURATION | Placeholder (blocked) | Yes | Yes |
| DVAR | Not in ODF 1.4 mandatory | Yes | Yes |
| DVARP | Not in ODF 1.4 mandatory | Yes | Yes |
| EDATE | Implemented | Yes | Yes |
| EFFECT | Placeholder (blocked) | Yes | Yes |
| ENCODEURL | Not in ODF 1.4 mandatory | Yes | Yes |
| EOMONTH | Implemented | Yes | Yes |
| ERF | Placeholder (blocked) | Yes | Yes |
| ERF.PRECISE | Not in ODF 1.4 mandatory | Yes | Yes |
| ERFC | Placeholder (blocked) | Yes | Yes |
| ERFC.PRECISE | Not in ODF 1.4 mandatory | Yes | Yes |
| ERROR.TYPE | Placeholder (blocked) | Yes | Yes |
| EUROCONVERT | Placeholder (blocked) | Yes | Yes |
| EVEN | Not in ODF 1.4 mandatory | Yes | Yes |
| EXACT | Not in ODF 1.4 mandatory | Yes | Yes |
| EXP | Not in ODF 1.4 mandatory | Yes | Yes |
| EXPAND | Not in ODF 1.4 mandatory | Yes | Yes |
| EXPON.DIST | Not in ODF 1.4 mandatory | Yes | Yes |
| EXPONDIST | Placeholder (blocked) | Yes | Yes |
| F.DIST | Not in ODF 1.4 mandatory | Yes | Yes |
| F.DIST.RT | Not in ODF 1.4 mandatory | Yes | Yes |
| F.INV | Not in ODF 1.4 mandatory | Yes | Yes |
| F.INV.RT | Not in ODF 1.4 mandatory | Yes | Yes |
| F.TEST | Not in ODF 1.4 mandatory | Yes | Yes |
| FACT | Not in ODF 1.4 mandatory | Yes | Yes |
| FACTDOUBLE | Implemented | Yes | Yes |
| FALSE | Not in ODF 1.4 mandatory | Yes | Yes |
| FDIST | Placeholder (blocked) | Yes | Yes |
| FILTER | Not in ODF 1.4 mandatory | Yes | Yes |
| FILTERXML | Not in ODF 1.4 mandatory | Yes | Yes |
| FIND | Not in ODF 1.4 mandatory | Yes | Yes |
| FINDB | Missing | Yes | Yes |
| FINV | Placeholder (blocked) | Yes | Yes |
| FISHER | Placeholder (blocked) | Yes | Yes |
| FISHERINV | Placeholder (blocked) | Yes | Yes |
| FIXED | Placeholder (blocked) | Yes | Yes |
| FLOOR | Implemented | Yes | Yes |
| FLOOR.MATH | Not in ODF 1.4 mandatory | Yes | Yes |
| FLOOR.PRECISE | Not in ODF 1.4 mandatory | Yes | Yes |
| FORECAST | Placeholder (blocked) | No | Yes |
| FORMULA | Implemented | No | Yes |
| FORMULATEXT | Not in ODF 1.4 mandatory | Yes | Yes |
| FREQUENCY | Placeholder (blocked) | Yes | Yes |
| FTEST | Placeholder (blocked) | Yes | Yes |
| FV | Not in ODF 1.4 mandatory | Yes | Yes |
| FVSCHEDULE | Placeholder (blocked) | Yes | Yes |
| GAMMA | Placeholder (blocked) | Yes | Yes |
| GAMMA.DIST | Not in ODF 1.4 mandatory | Yes | Yes |
| GAMMA.INV | Not in ODF 1.4 mandatory | Yes | Yes |
| GAMMADIST | Placeholder (blocked) | Yes | Yes |
| GAMMAINV | Placeholder (blocked) | Yes | Yes |
| GAMMALN | Placeholder (blocked) | Yes | Yes |
| GAMMALN.PRECISE | Not in ODF 1.4 mandatory | Yes | Yes |
| GAUSS | Placeholder (blocked) | Yes | Yes |
| GCD | Implemented | Yes | Yes |
| GEOMEAN | Placeholder (blocked) | Yes | Yes |
| GESTEP | Placeholder (blocked) | Yes | Yes |
| GETPIVOTDATA | Placeholder (blocked) | Yes | Yes |
| GROUPBY | Not in ODF 1.4 mandatory | Yes | Yes |
| GROWTH | Placeholder (blocked) | Yes | Yes |
| HARMEAN | Placeholder (blocked) | Yes | Yes |
| HEX2BIN | Placeholder (blocked) | Yes | Yes |
| HEX2DEC | Placeholder (blocked) | Yes | Yes |
| HEX2OCT | Placeholder (blocked) | Yes | Yes |
| HLOOKUP | Not in ODF 1.4 mandatory | Yes | Yes |
| HOUR | Not in ODF 1.4 mandatory | Yes | Yes |
| HSTACK | Not in ODF 1.4 mandatory | Yes | Yes |
| HYPERLINK | Placeholder (blocked) | Yes | Yes |
| HYPGEOM.DIST | Not in ODF 1.4 mandatory | Yes | Yes |
| HYPGEOMDIST | Placeholder (blocked) | Yes | Yes |
| IF | Not in ODF 1.4 mandatory | Yes | Yes |
| IFERROR | Implemented | Yes | Yes |
| IFNA | Implemented | Yes | Yes |
| IFS | Not in ODF 1.4 mandatory | Yes | Yes |
| IMABS | Placeholder (blocked) | Yes | Yes |
| IMAGE | Not in ODF 1.4 mandatory | Yes | Yes |
| IMAGINARY | Placeholder (blocked) | Yes | Yes |
| IMARGUMENT | Placeholder (blocked) | Yes | Yes |
| IMCONJUGATE | Placeholder (blocked) | Yes | Yes |
| IMCOS | Placeholder (blocked) | Yes | Yes |
| IMCOSH | Not in ODF 1.4 mandatory | Yes | Yes |
| IMCOT | Placeholder (blocked) | Yes | Yes |
| IMCSC | Placeholder (blocked) | Yes | Yes |
| IMCSCH | Placeholder (blocked) | Yes | Yes |
| IMDIV | Placeholder (blocked) | Yes | Yes |
| IMEXP | Placeholder (blocked) | Yes | Yes |
| IMLN | Placeholder (blocked) | Yes | Yes |
| IMLOG10 | Placeholder (blocked) | Yes | Yes |
| IMLOG2 | Placeholder (blocked) | Yes | Yes |
| IMPOWER | Placeholder (blocked) | Yes | Yes |
| IMPRODUCT | Placeholder (blocked) | Yes | Yes |
| IMREAL | Placeholder (blocked) | Yes | Yes |
| IMSEC | Placeholder (blocked) | Yes | Yes |
| IMSECH | Placeholder (blocked) | Yes | Yes |
| IMSIN | Placeholder (blocked) | Yes | Yes |
| IMSINH | Not in ODF 1.4 mandatory | Yes | Yes |
| IMSQRT | Placeholder (blocked) | Yes | Yes |
| IMSUB | Placeholder (blocked) | Yes | Yes |
| IMSUM | Placeholder (blocked) | Yes | Yes |
| IMTAN | Placeholder (blocked) | Yes | Yes |
| INDEX | Not in ODF 1.4 mandatory | Yes | Yes |
| INDIRECT | Implemented | Yes | Yes |
| INFO | Placeholder (blocked) | Yes | Yes |
| INT | Not in ODF 1.4 mandatory | Yes | Yes |
| INTERCEPT | Placeholder (blocked) | Yes | Yes |
| INTRATE | Placeholder (blocked) | Yes | Yes |
| IPMT | Placeholder (blocked) | Yes | Yes |
| IRR | Not in ODF 1.4 mandatory | Yes | Yes |
| ISBLANK | Not in ODF 1.4 mandatory | Yes | Yes |
| ISEVEN | Placeholder (blocked) | Yes | Yes |
| ISFORMULA | Placeholder (blocked) | Yes | Yes |
| ISNUMBER | Not in ODF 1.4 mandatory | Yes | Yes |
| ISO.CEILING | Not in ODF 1.4 mandatory | Yes | Yes |
| ISODD | Placeholder (blocked) | No | Yes |
| ISOMITTED | Not in ODF 1.4 mandatory | Yes | Yes |
| ISOWEEKNUM | Placeholder (blocked) | Yes | Yes |
| ISPMT | Placeholder (blocked) | Yes | Yes |
| ISREF | Placeholder (blocked) | No | Yes |
| ISTEXT | Not in ODF 1.4 mandatory | Yes | Yes |
| JIS | Placeholder (blocked) | No | Yes |
| KURT | Placeholder (blocked) | Yes | Yes |
| LAMBDA | Not in ODF 1.4 mandatory | Yes | Yes |
| LARGE | Placeholder (blocked) | Yes | Yes |
| LCM | Implemented | Yes | Yes |
| LEFT | Not in ODF 1.4 mandatory | Yes | Yes |
| LEFTB | Missing | Yes | Yes |
| LEGACY.CHIDIST | Legacy not implemented | No | Yes |
| LEGACY.CHIINV | Legacy not implemented | No | Yes |
| LEGACY.CHITEST | Legacy not implemented | No | Yes |
| LEGACY.FDIST | Legacy not implemented | No | Yes |
| LEGACY.FINV | Legacy not implemented | No | Yes |
| LEGACY.NORMSDIST | Legacy not implemented | No | Yes |
| LEGACY.NORMSINV | Legacy not implemented | No | Yes |
| LEN | Not in ODF 1.4 mandatory | Yes | Yes |
| LENB | Missing | Yes | Yes |
| LET | Not in ODF 1.4 mandatory | Yes | Yes |
| LINEST | Placeholder (blocked) | Yes | Yes |
| LN | Not in ODF 1.4 mandatory | Yes | Yes |
| LOG | Not in ODF 1.4 mandatory | Yes | Yes |
| LOG10 | Not in ODF 1.4 mandatory | Yes | Yes |
| LOGEST | Placeholder (blocked) | Yes | Yes |
| LOGINV | Placeholder (blocked) | Yes | Yes |
| LOGNORM.DIST | Not in ODF 1.4 mandatory | Yes | Yes |
| LOGNORM.INV | Not in ODF 1.4 mandatory | Yes | Yes |
| LOGNORMDIST | Placeholder (blocked) | Yes | Yes |
| LOOKUP | Placeholder (blocked) | Yes | Yes |
| LOWER | Not in ODF 1.4 mandatory | Yes | Yes |
| MAKEARRAY | Not in ODF 1.4 mandatory | Yes | Yes |
| MAP | Not in ODF 1.4 mandatory | Yes | Yes |
| MATCH | Not in ODF 1.4 mandatory | Yes | Yes |
| MAX | Not in ODF 1.4 mandatory | Yes | Yes |
| MAXA | Placeholder (blocked) | Yes | Yes |
| MAXIFS | Not in ODF 1.4 mandatory | Yes | Yes |
| MDETERM | Implemented | Yes | Yes |
| MDURATION | Placeholder (blocked) | Yes | Yes |
| MEDIAN | Placeholder (blocked) | Yes | Yes |
| MID | Not in ODF 1.4 mandatory | Yes | Yes |
| MIDB | Missing | Yes | Yes |
| MIN | Not in ODF 1.4 mandatory | Yes | Yes |
| MINA | Placeholder (blocked) | Yes | Yes |
| MINIFS | Not in ODF 1.4 mandatory | Yes | Yes |
| MINUTE | Not in ODF 1.4 mandatory | Yes | Yes |
| MINVERSE | Implemented | Yes | Yes |
| MIRR | Placeholder (blocked) | Yes | Yes |
| MMULT | Implemented | Yes | Yes |
| MOD | Not in ODF 1.4 mandatory | Yes | Yes |
| MODE | Placeholder (blocked) | Yes | Yes |
| MODE.MULT | Not in ODF 1.4 mandatory | Yes | Yes |
| MODE.SNGL | Not in ODF 1.4 mandatory | Yes | Yes |
| MONTH | Not in ODF 1.4 mandatory | Yes | Yes |
| MROUND | Implemented | Yes | Yes |
| MULTINOMIAL | Implemented | Yes | Yes |
| MULTIPLE.OPERATIONS | Missing | No | Yes |
| MUNIT | Implemented | Yes | Yes |
| N | Not in ODF 1.4 mandatory | Yes | Yes |
| NA | Not in ODF 1.4 mandatory | Yes | Yes |
| NEGBINOM.DIST | Not in ODF 1.4 mandatory | Yes | Yes |
| NEGBINOMDIST | Placeholder (blocked) | Yes | Yes |
| NETWORKDAYS | Placeholder (blocked) | Yes | Yes |
| NETWORKDAYS.INTL | Not in ODF 1.4 mandatory | Yes | Yes |
| NOMINAL | Placeholder (blocked) | Yes | Yes |
| NORM.DIST | Not in ODF 1.4 mandatory | Yes | Yes |
| NORM.INV | Not in ODF 1.4 mandatory | Yes | Yes |
| NORM.S.DIST | Not in ODF 1.4 mandatory | Yes | Yes |
| NORM.S.INV | Not in ODF 1.4 mandatory | Yes | Yes |
| NORMDIST | Placeholder (blocked) | Yes | Yes |
| NORMINV | Placeholder (blocked) | Yes | Yes |
| NORMSDIST | Not in ODF 1.4 mandatory | Yes | Yes |
| NORMSINV | Not in ODF 1.4 mandatory | Yes | Yes |
| NOT | Not in ODF 1.4 mandatory | Yes | Yes |
| NOW | Not in ODF 1.4 mandatory | Yes | Yes |
| NPER | Not in ODF 1.4 mandatory | Yes | Yes |
| NPV | Not in ODF 1.4 mandatory | Yes | Yes |
| NUMBERVALUE | Placeholder (blocked) | Yes | Yes |
| OCT2BIN | Placeholder (blocked) | Yes | Yes |
| OCT2DEC | Placeholder (blocked) | Yes | Yes |
| OCT2HEX | Placeholder (blocked) | Yes | Yes |
| ODD | Not in ODF 1.4 mandatory | Yes | Yes |
| ODDFPRICE | Placeholder (blocked) | Yes | Yes |
| ODDFYIELD | Placeholder (blocked) | Yes | Yes |
| ODDLPRICE | Placeholder (blocked) | Yes | Yes |
| ODDLYIELD | Placeholder (blocked) | Yes | Yes |
| OFFSET | Placeholder (blocked) | Yes | Yes |
| OR | Not in ODF 1.4 mandatory | Yes | Yes |
| PDURATION | Placeholder (blocked) | Yes | Yes |
| PEARSON | Placeholder (blocked) | Yes | Yes |
| PERCENTILE | Placeholder (blocked) | Yes | Yes |
| PERCENTILE.EXC | Not in ODF 1.4 mandatory | Yes | Yes |
| PERCENTILE.INC | Not in ODF 1.4 mandatory | Yes | Yes |
| PERCENTOF | Not in ODF 1.4 mandatory | Yes | Yes |
| PERCENTRANK | Placeholder (blocked) | Yes | Yes |
| PERCENTRANK.EXC | Not in ODF 1.4 mandatory | Yes | Yes |
| PERCENTRANK.INC | Not in ODF 1.4 mandatory | Yes | Yes |
| PERMUT | Placeholder (blocked) | Yes | Yes |
| PERMUTATIONA | Placeholder (blocked) | Yes | Yes |
| PHI | Placeholder (blocked) | Yes | Yes |
| PHONETIC | Not in ODF 1.4 mandatory | Yes | Yes |
| PI | Not in ODF 1.4 mandatory | Yes | Yes |
| PIVOTBY | Not in ODF 1.4 mandatory | Yes | Yes |
| PMT | Not in ODF 1.4 mandatory | Yes | Yes |
| POISSON | Placeholder (blocked) | Yes | Yes |
| POISSON.DIST | Not in ODF 1.4 mandatory | Yes | Yes |
| POWER | Not in ODF 1.4 mandatory | Yes | Yes |
| PPMT | Placeholder (blocked) | Yes | Yes |
| PRICE | Placeholder (blocked) | Yes | Yes |
| PRICEDISC | Placeholder (blocked) | Yes | Yes |
| PRICEMAT | Placeholder (blocked) | Yes | Yes |
| PROB | Placeholder (blocked) | Yes | Yes |
| PRODUCT | Not in ODF 1.4 mandatory | Yes | Yes |
| PROPER | Not in ODF 1.4 mandatory | Yes | Yes |
| PV | Not in ODF 1.4 mandatory | Yes | Yes |
| QUARTILE | Placeholder (blocked) | Yes | Yes |
| QUARTILE.EXC | Not in ODF 1.4 mandatory | Yes | Yes |
| QUARTILE.INC | Not in ODF 1.4 mandatory | Yes | Yes |
| QUOTIENT | Implemented | Yes | Yes |
| RADIANS | Not in ODF 1.4 mandatory | Yes | Yes |
| RAND | Implemented | Yes | Yes |
| RANDARRAY | Not in ODF 1.4 mandatory | Yes | Yes |
| RANDBETWEEN | Implemented | Yes | Yes |
| RANK | Placeholder (blocked) | Yes | Yes |
| RANK.AVG | Not in ODF 1.4 mandatory | Yes | Yes |
| RANK.EQ | Not in ODF 1.4 mandatory | Yes | Yes |
| RATE | Not in ODF 1.4 mandatory | Yes | Yes |
| RECEIVED | Placeholder (blocked) | Yes | Yes |
| REDUCE | Not in ODF 1.4 mandatory | Yes | Yes |
| REGEXEXTRACT | Not in ODF 1.4 mandatory | Yes | Yes |
| REGEXREPLACE | Not in ODF 1.4 mandatory | Yes | Yes |
| REGEXTEST | Not in ODF 1.4 mandatory | Yes | Yes |
| REGISTER.ID | Not in ODF 1.4 mandatory | Yes | Yes |
| REPLACE | Not in ODF 1.4 mandatory | Yes | Yes |
| REPLACEB | Missing | Yes | Yes |
| REPT | Not in ODF 1.4 mandatory | Yes | Yes |
| RIGHT | Not in ODF 1.4 mandatory | Yes | Yes |
| RIGHTB | Missing | Yes | Yes |
| ROMAN | Implemented | Yes | Yes |
| ROUND | Not in ODF 1.4 mandatory | Yes | Yes |
| ROUNDDOWN | Implemented | Yes | Yes |
| ROUNDUP | Implemented | Yes | Yes |
| ROW | Placeholder (blocked) | Yes | Yes |
| ROWS | Not in ODF 1.4 mandatory | Yes | Yes |
| RRI | Placeholder (blocked) | Yes | Yes |
| RSQ | Placeholder (blocked) | Yes | Yes |
| RTD | Not in ODF 1.4 mandatory | Yes | Yes |
| SCAN | Not in ODF 1.4 mandatory | Yes | Yes |
| SEARCH | Implemented | Yes | Yes |
| SEARCHB | Missing | Yes | Yes |
| SEC | Implemented | Yes | Yes |
| SECH | Implemented | Yes | Yes |
| SECOND | Not in ODF 1.4 mandatory | Yes | Yes |
| SEQUENCE | Not in ODF 1.4 mandatory | Yes | Yes |
| SERIESSUM | Implemented | Yes | Yes |
| SHEET | Placeholder (blocked) | Yes | Yes |
| SHEETS | Placeholder (blocked) | Yes | Yes |
| SIGN | Implemented | Yes | Yes |
| SIN | Not in ODF 1.4 mandatory | Yes | Yes |
| SINH | Implemented | Yes | Yes |
| SKEW | Placeholder (blocked) | Yes | Yes |
| SKEW.P | Not in ODF 1.4 mandatory | Yes | Yes |
| SKEWP | Missing | No | Yes |
| SLN | Not in ODF 1.4 mandatory | Yes | Yes |
| SLOPE | Placeholder (blocked) | Yes | Yes |
| SMALL | Placeholder (blocked) | Yes | Yes |
| SORT | Not in ODF 1.4 mandatory | Yes | Yes |
| SORTBY | Not in ODF 1.4 mandatory | Yes | Yes |
| SQRT | Not in ODF 1.4 mandatory | Yes | Yes |
| SQRTPI | Implemented | Yes | Yes |
| STANDARDIZE | Placeholder (blocked) | Yes | Yes |
| STDEV | Not in ODF 1.4 mandatory | Yes | Yes |
| STDEV.P | Not in ODF 1.4 mandatory | Yes | Yes |
| STDEV.S | Not in ODF 1.4 mandatory | Yes | Yes |
| STDEVA | Placeholder (blocked) | Yes | Yes |
| STDEVP | Not in ODF 1.4 mandatory | Yes | Yes |
| STDEVPA | Placeholder (blocked) | Yes | Yes |
| STEYX | Placeholder (blocked) | Yes | Yes |
| STOCKHISTORY | Not in ODF 1.4 mandatory | Yes | Yes |
| SUBSTITUTE | Not in ODF 1.4 mandatory | Yes | Yes |
| SUBTOTAL | Implemented | Yes | Yes |
| SUM | Not in ODF 1.4 mandatory | Yes | Yes |
| SUMIF | Not in ODF 1.4 mandatory | Yes | Yes |
| SUMIFS | Implemented | Yes | Yes |
| SUMPRODUCT | Implemented | Yes | Yes |
| SUMSQ | Implemented | Yes | Yes |
| SUMX2MY2 | Implemented | Yes | Yes |
| SUMX2PY2 | Implemented | Yes | Yes |
| SUMXMY2 | Implemented | Yes | Yes |
| SWITCH | Not in ODF 1.4 mandatory | Yes | Yes |
| SYD | Not in ODF 1.4 mandatory | Yes | Yes |
| T | Not in ODF 1.4 mandatory | Yes | Yes |
| T.DIST | Not in ODF 1.4 mandatory | Yes | Yes |
| T.DIST.2T | Not in ODF 1.4 mandatory | Yes | Yes |
| T.DIST.RT | Not in ODF 1.4 mandatory | Yes | Yes |
| T.INV | Not in ODF 1.4 mandatory | Yes | Yes |
| T.INV.2T | Not in ODF 1.4 mandatory | Yes | Yes |
| T.TEST | Not in ODF 1.4 mandatory | Yes | Yes |
| TAKE | Not in ODF 1.4 mandatory | Yes | Yes |
| TAN | Not in ODF 1.4 mandatory | Yes | Yes |
| TANH | Implemented | Yes | Yes |
| TBILLEQ | Placeholder (blocked) | Yes | Yes |
| TBILLPRICE | Placeholder (blocked) | Yes | Yes |
| TBILLYIELD | Placeholder (blocked) | Yes | Yes |
| TDIST | Not in ODF 1.4 mandatory | Yes | Yes |
| TEXT | Placeholder (blocked) | Yes | Yes |
| TEXTAFTER | Not in ODF 1.4 mandatory | Yes | Yes |
| TEXTBEFORE | Not in ODF 1.4 mandatory | Yes | Yes |
| TEXTJOIN | Not in ODF 1.4 mandatory | Yes | Yes |
| TEXTSPLIT | Not in ODF 1.4 mandatory | Yes | Yes |
| TIME | Not in ODF 1.4 mandatory | Yes | Yes |
| TIMEVALUE | Placeholder (blocked) | Yes | Yes |
| TINV | Placeholder (blocked) | Yes | Yes |
| TOCOL | Not in ODF 1.4 mandatory | Yes | Yes |
| TODAY | Not in ODF 1.4 mandatory | Yes | Yes |
| TOROW | Not in ODF 1.4 mandatory | Yes | Yes |
| TRANSLATE | Not in ODF 1.4 mandatory | Yes | Yes |
| TRANSPOSE | Placeholder (blocked) | Yes | Yes |
| TREND | Placeholder (blocked) | Yes | Yes |
| TRIM | Not in ODF 1.4 mandatory | Yes | Yes |
| TRIMMEAN | Placeholder (blocked) | Yes | Yes |
| TRIMRANGE | Not in ODF 1.4 mandatory | Yes | Yes |
| TRUE | Not in ODF 1.4 mandatory | Yes | Yes |
| TRUNC | Not in ODF 1.4 mandatory | Yes | Yes |
| TTEST | Placeholder (blocked) | Yes | Yes |
| TYPE | Placeholder (blocked) | Yes | Yes |
| UNICHAR | Placeholder (blocked) | Yes | Yes |
| UNICODE | Placeholder (blocked) | Yes | Yes |
| UNIQUE | Not in ODF 1.4 mandatory | Yes | Yes |
| UPPER | Not in ODF 1.4 mandatory | Yes | Yes |
| USE.THE.COUNTIF | Not in ODF 1.4 mandatory | Yes | Yes |
| VALUE | Not in ODF 1.4 mandatory | Yes | Yes |
| VALUETOTEXT | Not in ODF 1.4 mandatory | Yes | Yes |
| VAR | Not in ODF 1.4 mandatory | Yes | Yes |
| VAR.P | Not in ODF 1.4 mandatory | Yes | Yes |
| VAR.S | Not in ODF 1.4 mandatory | Yes | Yes |
| VARA | Placeholder (blocked) | Yes | Yes |
| VARP | Not in ODF 1.4 mandatory | Yes | Yes |
| VARPA | Placeholder (blocked) | Yes | Yes |
| VDB | Not in ODF 1.4 mandatory | Yes | Yes |
| VLOOKUP | Not in ODF 1.4 mandatory | Yes | Yes |
| VSTACK | Not in ODF 1.4 mandatory | Yes | Yes |
| WEBSERVICE | Not in ODF 1.4 mandatory | Yes | Yes |
| WEEKDAY | Not in ODF 1.4 mandatory | Yes | Yes |
| WEEKNUM | Placeholder (blocked) | Yes | Yes |
| WEIBULL | Placeholder (blocked) | Yes | Yes |
| WEIBULL.DIST | Not in ODF 1.4 mandatory | Yes | Yes |
| WORKDAY | Placeholder (blocked) | Yes | Yes |
| WORKDAY.INTL | Not in ODF 1.4 mandatory | Yes | Yes |
| WRAPCOLS | Not in ODF 1.4 mandatory | Yes | Yes |
| WRAPROWS | Not in ODF 1.4 mandatory | Yes | Yes |
| XIRR | Placeholder (blocked) | Yes | Yes |
| XLOOKUP | Not in ODF 1.4 mandatory | Yes | Yes |
| XMATCH | Not in ODF 1.4 mandatory | Yes | Yes |
| XNPV | Placeholder (blocked) | Yes | Yes |
| XOR | Implemented | Yes | Yes |
| YEAR | Not in ODF 1.4 mandatory | Yes | Yes |
| YEARFRAC | Placeholder (blocked) | Yes | Yes |
| YIELD | Placeholder (blocked) | Yes | Yes |
| YIELDDISC | Placeholder (blocked) | Yes | Yes |
| YIELDMAT | Placeholder (blocked) | Yes | Yes |
| Z.TEST | Not in ODF 1.4 mandatory | Yes | Yes |
| ZTEST | Placeholder (blocked) | Yes | Yes |
