Is there solution for =SEQUENCE formula from Excel in Libreoffice?
Example how to configure following formula:


I believe you can not easily generate an arbitrary size matrix by formula in Calc.

I guess I would create a “foundation matrix” in a separate sheet for this kind of source data, but I can’t envision a use case. If you describe your purpose and/or workflow, someone may have a more specific suggestion for a workaround.

It’s really strange what hokum developers of Excel assume to be useful.
However, if your

Number of Rows
Number of columns
Start value

are given in the cells A1:A4 in this order, it’s as simple as


entered somewhere for array evaluation (Ctrl+Shift+Enter).

The difficult part comes when a sheet containing such a construct needs changes like enhancements/maintenance/scaling up or down/insertion of rows/columns for different purposes…
You will then get plenty of problems for little benefit. In other words: The disadvantage-benefit ratio is great.

Of course it’s very simple to write the “SEQUENCE()” thing as a UDF.

See attached example:
disask89001sequenceLikeExcelAndMore.ods (19.8 KB)
Note: The included UDF can only run if either document macros are permitted, or the code of the little function is moved to a module of the Standard library. The demo for the above given solution is independent of this.

1 Like