Description:
LibreOffice Calc supports array-returning functions such as FILTER, UNIQUE, SORT, and SEQUENCE, but it lacks Excel-style dynamic array “spilling.”

In Excel, array formulas automatically expand into adjacent cells and can be referenced using the spill operator (e.g. A1#). In Calc, users must pre-allocate ranges and cannot reference the full output of an array formula dynamically.

This severely limits Calc for modern financial, reporting, and data-modeling workflows and prevents compatibility with spreadsheets built for Excel 365 / Excel 2021+.

Requested features:

Automatic spill of array-returning formulas into adjacent cells

A spill-range reference operator equivalent to Excel’s #

Automatic resizing of downstream formulas when spill size changes

These features are necessary for Calc to support modern spreadsheet models.

Actual Results:
Dynamic array formulas (UNIQUE, FILTER) do not resize output and there is no way to change the output without deleting the entire row and re-entering the formula.

Expected Results:
Dynamic resizing and SPILL ranges, like Excel.


Reproducible: Always


User Profile Reset: No

Additional Info:
n/a