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.
*** Bug 129333 has been marked as a duplicate of this bug. ***
Regression introduced by: https://cgit.freedesktop.org/libreoffice/core/commit/?id=47230a036fe35b9a7a7c0609232849fcbb51efcc author Eike Rathke <erack@redhat.com> 2015-02-05 11:32:13 +0100 committer Eike Rathke <erack@redhat.com> 2015-02-05 11:52:51 +0100 commit 47230a036fe35b9a7a7c0609232849fcbb51efcc (patch) tree 15f08a8c276e885ce6abc685114e4782e27e1546 parent de68bb85145e68fc170b8eab0fa3357cd7165421 (diff) Resolves: tdf#88792 do not hold a ScFormulaCell** in group area listener Bisected with: bibisect-50max Adding Cc: to Eike Rathke
Taking.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/491e8f60bf7f216a3bb3092b22334924b6c9aee1 Resolves: tdf#129396 Refresh shared formula group area listeners upon shifting It will be available in 6.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/85353 for 6-3
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-4": https://git.libreoffice.org/core/commit/35f82ef89071887726f6cb125cc669dd51a3db47 Resolves: tdf#129396 Refresh shared formula group area listeners upon shifting It will be available in 6.4.0.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in Version: 6.5.0.0.alpha0+ Build ID: 491e8f60bf7f216a3bb3092b22334924b6c9aee1 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded @Eike, thanks for fixing this issue!!
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/28ea93627ea4ea1a3003d3d1620125ea84ea31b3 Unit test insert with shared formula group shift, tdf#129396 It will be available in 6.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/commit/92051303dce5efbc29b2afe426f9e076cee01736 Resolves: tdf#129396 Refresh shared formula group area listeners upon shifting It will be available in 6.3.5. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.