https://bugs.documentfoundation.org/show_bug.cgi?id=172021
Bug ID: 172021
Summary: [26.8] Cannot edit formula after array formula spill
error
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Cannot edit formula after array formula spill error.
Steps to Reproduce:
1. Open new Calc.
2. Insert "a" into Cell [ B2 ].
3. Insert Array formula "=SEQUENCE(2;2)" into Cell [ A1 ]
4. "#SPILL!" appears in Cell [ A1 ].
5. Clear Cell [ B2 ], remove "a".
6. Select Array formula range Menu or ( Ctrl + / ).
7. Try to edit.( F2 key )
Actual Results:
8. Caution Dialog appears "You cannot change only part of an array".
Expected Results:
8. Can edit.
Reproducible: Always
User Profile Reset: No
Additional Info:
After saving and restarting, the array formula will be correct and become
editable.
Reproducible
[2026-05-08]
Version: 26.8.0.0.alpha0+ (X86_64)
Build ID: ddbd78e13a92747a2d68c836237f922fa6a43884
CPU threads: 2; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
Calc: threaded
---
Not reproducible
Previously overwritten without warning.
[2026-04-30]
Version: 26.8.0.0.alpha0+ (X86_64)
Build ID: b1e601a83dc811319353499f023a11ecb710f8e5
CPU threads: 2; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
