https://bugs.documentfoundation.org/show_bug.cgi?id=173607
Bug ID: 173607
Summary: Two dynamic arrays whose spill ranges overlap both
spill instead of one showing #SPILL!, and the shared
cell changes owner on every later edit.
Product: LibreOffice
Version: 27.2.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Steps in a new spreadsheet, typing into the grid:
1. In A2 type =SEQUENCE(1;3;10). A2:C2 shows 10, 11, 12.
2. In B1 type =SEQUENCE(3;1;100). B1:B3 shows 100, 101, 102. B2 now shows 101,
and A2 still looks fully spilled (10, 101, 12).
3. Type anything into an unrelated cell, for example 0 in G1. B2 becomes 11.
4. Type something else in G1. B2 becomes 101. It alternates like this on every
edit.
Actual:
- Neither formula ever shows #SPILL!.
- B2 belongs to whichever array was resized last, and it flips on every edit
anywhere in the document.
- Any formula reading B2, for example =B2*2, flips with it between 22 and 202.
Expected:
- The second formula, B1, shows #SPILL! because B2 is already occupied by A2's
spill.
- The first array is untouched.
- Deleting A2 lets B1 spill.
- The state is stable.
My build is: 08874223db78571f75640aa2a4afc6d6cdd83d0f
(I am new to this, sorry if the bug report is incomplete. And greetings from
IronCalc)
--
You are receiving this mail because:
You are the assignee for the bug.
