https://bugs.documentfoundation.org/show_bug.cgi?id=170291
Bug ID: 170291
Summary: Add Excel-style dynamic array spilling and spill-range
operator (#)
Product: LibreOffice
Version: 25.8.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
