LibreOffice Calc function support by version
Which functions does each LibreOffice Calc release actually support? We ran the
same corpus of test formulas under LibreOffice 24.2.0.3, 24.8.7.2, 25.8.7.3 and recorded the
real computed results — so this is machine-verified compatibility, not documentation claims.
18 functions that returned #NAME? in
24.2.0.3 now work in a later release — and below is the exact version each one
landed in.
Newly supported functions — and the release each landed in
These functions were not recognized (returned #NAME?) in
LibreOffice 24.2.0.3 but became fully supported in a later release. Most are modern
dynamic-array and lookup functions Excel and Google Sheets already had. The
Supported since column is the earliest release we tested where the function works.
| Function | Category | 24.2.0.3 | 24.8.7.2 | 25.8.7.3 | Supported since |
|---|---|---|---|---|---|
| LET | Logical | Unsupported | Supported | Supported | 24.8.7.2 |
| SEQUENCE | Math and trigonometry | Unsupported | Supported | Supported | 24.8.7.2 |
| SORT | Lookup and reference | Unsupported | Supported | Supported | 24.8.7.2 |
| SORTBY | Lookup and reference | Unsupported | Supported | Supported | 24.8.7.2 |
| UNIQUE | Lookup and reference | Unsupported | Supported | Supported | 24.8.7.2 |
| XLOOKUP | Lookup and reference | Unsupported | Supported | Supported | 24.8.7.2 |
| XMATCH | Lookup and reference | Unsupported | Supported | Supported | 24.8.7.2 |
| CHOOSECOLS | Lookup and reference | Unsupported | Unsupported | Supported | 25.8.7.3 |
| CHOOSEROWS | Lookup and reference | Unsupported | Unsupported | Supported | 25.8.7.3 |
| DROP | Lookup and reference | Unsupported | Unsupported | Supported | 25.8.7.3 |
| HSTACK | Lookup and reference | Unsupported | Unsupported | Supported | 25.8.7.3 |
| TAKE | Lookup and reference | Unsupported | Unsupported | Supported | 25.8.7.3 |
| TEXTSPLIT | Text | Unsupported | Unsupported | Supported | 25.8.7.3 |
| TOCOL | Lookup and reference | Unsupported | Unsupported | Supported | 25.8.7.3 |
| TOROW | Lookup and reference | Unsupported | Unsupported | Supported | 25.8.7.3 |
| VSTACK | Lookup and reference | Unsupported | Unsupported | Supported | 25.8.7.3 |
| WRAPCOLS | Lookup and reference | Unsupported | Unsupported | Supported | 25.8.7.3 |
| WRAPROWS | Lookup and reference | Unsupported | Unsupported | Supported | 25.8.7.3 |
Other support changes
Functions whose behaviour changed across these releases in some other way — for example, newly recognized but with an edge-case quirk rather than full support.
| Function | Category | 24.2.0.3 | 24.8.7.2 | 25.8.7.3 |
|---|---|---|---|---|
| FILTER | Lookup and reference | Unsupported | Quirk | Quirk |
| LAMBDA | Logical | Unsupported | Quirk | Quirk |
| TEXTAFTER | Text | Unsupported | Unsupported | Quirk |
| TEXTBEFORE | Text | Unsupported | Unsupported | Quirk |
How we know
For each LibreOffice release, we build a workbook of test formulas with no cached values, force a full headless recalculation, and read back the computed results — with volatile and arithmetic canaries proving the recalculation genuinely happened. The same method powers every function page and the formula checker. Versions tested so far: 24.2.0.3, 24.8.7.2, 25.8.7.3.