https://bugs.documentfoundation.org/show_bug.cgi?id=89207
--- Comment #8 from george <[email protected]> --- I would like to strongly support fixing this issue. Today (December 2025) I ran into the same limitation in LibreOffice Calc: I could not modify an array formula in place, whether I selected just the first cell of the array or the entire array range. The only way to “edit” it was to delete the whole array formula and re-enter it from scratch with the new parameters, which is extremely inefficient and risky for complex spreadsheets. In 2025/2026 this behavior feels really outdated, especially compared to competing spreadsheet tools like Google Sheets, where editing array formulas is much more straightforward and user-friendly. Modern workflows rely heavily on dynamic ranges and array formulas, and not being able to easily adjust them (expand, contract, or tweak arguments) is a serious usability problem, not just a minor inconvenience. Please consider prioritizing this issue so that users can: - Edit existing array formulas directly, without having to delete and recreate them. - Resize array outputs (expand/contract ranges) without losing the formula. - Avoid disruptive error messages when only trying to adjust parameters or ranges. Improving array formula editing would significantly enhance Calc’s usability and make it far more competitive with other spreadsheet applications. -- You are receiving this mail because: You are the assignee for the bug.
