https://bugs.documentfoundation.org/show_bug.cgi?id=129396
Bug ID: 129396
Summary: Shared formula group created by pasting row(s) stops
listening to (part of) a range after insertion of a
column before the formula group.
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Short reproducers:
A1: 2
B1: =SUM(A1:A1)
copy A1:B1
paste onto A2:B2
insert column before B => formulas now in C1:C2
change A1 or A2 => C1 or C2 not recalculated
Similar with:
A1: 2
B1: 3
C1: =SUM(A1:B1)
copy A1:C1
paste onto A2:C2
select/mark C1:C2
Sheet -> Insert Cells..., Shift cells right, OK
Note that if A1:C1 is pasted also onto A3:C3 but still only shifting C1:C2 to
D1:D2 (thus keeping C3), the broadcaster/listener mechanism is kept intact and
recalculation continues to work.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
