A formula cell is not repainted after this procedure:
1. in A3:B4 enter the values 1, 2, 4, 8 (row-wise)
2. in C1 enter formula =SUM(A1:B1)
3. copy cell C1 to clipboard
4. paste onto C2:C4
5. select A3:B3
6. cut to clipboard
7. paste on A1
=> cell C1 is recalculated and displays 3
=> cell C3 still displays 0 and appears to not being recacluated, but in
fact it is just not repainted, as can be seen with a sequence of PageDn
and PageUp, or Shift+Ctrl+R, or anything else that attempts to obtain
the cell's value.
The same does not happen if steps #6 and #7 instead are performed using
It also does not happen if before step 5 a formula is added in some
(doesn't matter which) cell with =D3
Failure was observed while fixing bug 101002 and bug 123736.
Regression introduced by:
author Dennis Francis <email@example.com> 2019-01-15 21:34:46 +0530
committer Dennis Francis <firstname.lastname@example.org> 2019-02-05 13:56:22 +0100
commit 3346947b7e102384dfc6cd98dbf7da81936f8fd6 (patch)
parent ba1e745b3d022856080c25167226e8a9eeadc911 (diff)
Allow computing spans of formula-groups
Bisected with: bibisect-linux64-6.3
Adding Cc: to Dennis Francis
Dennis Francis committed a patch related to this issue.
It has been pushed to "master":
tdf#124266 : Paint cell if formula-cell has changed even if...
It will be available in 6.3.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:
Affected users are encouraged to test the fix and report feedback.
Build ID: 93f1c3665fcdc31c36078f179ac37fd69d3ebb00
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
@Dennis Francis, thanks for fixing this issue!