SEQUENCE
Supported, behaves as documentedCategory: Math and trigonometry · Last tested 2026-08-06
Real, executed compatibility results for the SEQUENCE function across Microsoft Excel, Google Sheets, and LibreOffice Calc — verified by actually running it. Syntax and links to each vendor’s official documentation are below.
SEQUENCE under every LibreOffice release we test
(24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3):
it returned #NAME? (unrecognized) in 24.2.0.3 and first works in 24.8.7.2.
If you need SEQUENCE in LibreOffice Calc, use 24.8.7.2 or newer.
Support matrix
| Engine | Documented | Live-tested | Verdict |
|---|---|---|---|
| Excel | Yes | Not yet | n/a |
| Google Sheets | Yes | Not yet | n/a |
| LibreOffice Calc | No | Yes (25.8.7.3, 2026-08-06) | Supported, behaves as documented |
LibreOffice version history
We executed the same test cases under each LibreOffice release to show exactly when SEQUENCE’s support changed — not documentation claims, real results.
| LibreOffice version | Verdict | Tested |
|---|---|---|
| 24.2.0.3 | Unsupported (not recognized) | 2026-07-19 |
| 24.8.7.2 | Supported, behaves as documented | 2026-07-19 |
| 25.2.0.3 | Supported, behaves as documented | 2026-07-24 |
| 25.8.7.3 | Supported, behaves as documented | 2026-08-06 |
Why isn't SEQUENCE working in LibreOffice?
If SEQUENCE returns a #NAME? error in LibreOffice Calc, you are
almost certainly running a release older than 24.8.7.2 — that is exactly
what our executed tests show: #NAME? in 24.2.0.3, working from
24.8.7.2 onward. Check your version under Help → About LibreOffice and upgrade to
24.8.7.2 or newer; no setting or extension enables it in older releases. (Other causes of this
error: see the error values guide.)
Executed test cases
LibreOffice Calc 25.8.7.3 (tested 2026-08-06)
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =SEQUENCE(5) | Default rows-only sequence starting at 1, step 1 | {1, 2, 3, 4, 5} | {1, 2, 3, 4, 5} | Matched |
| =SEQUENCE(2,3) | 2 rows x 3 columns filled row-major from 1 | {1, 2, 3, 4, 5, 6} | {{1, 2, 3}, {4, 5, 6}} | Matched |
| =SEQUENCE(5,1,10,5) | Custom start=10, step=5 | {10, 15, 20, 25, 30} | {10, 15, 20, 25, 30} | Matched |
| =SEQUENCE(3,1,5,-1) | Negative step counts down | {5, 4, 3} | {5, 4, 3} | Matched |
Docs & syntax
- Excel: official documentation
- Google Sheets: official documentation
Related how-to recipes
- How to auto-number rows with a formula
- How to create a list of dates
- How to extract numbers from text in a cell
- How to reverse a text string