Bug 137659 - Calc does not recalculate sheet properly
Summary: Calc does not recalculate sheet properly
Status: RESOLVED DUPLICATE of bug 137248
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2020-10-21 15:05 UTC by Dominique (DimStar) Leuenberger
Modified: 2020-10-21 15:39 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Sample file used to test (8.94 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-10-21 15:07 UTC, Dominique (DimStar) Leuenberger

Note You need to log in before you can comment on or make changes to this bug.
Description Dominique (DimStar) Leuenberger 2020-10-21 15:05:39 UTC
I observed this in one of my more complex (but by far not really complex) spreadhseets, that cells seem not to be recalculated, neither automatically nor when pressing F9

I created a dummy test file, with simple layout like

   A     |     B      |    C
   1     |     0      |  =SUM:A:A)
   2     |     1      |  =SUM(B:B)
   3     |     2      |  =C1-C2
   4     |     3      |
   5     |     4      |
   6     |     5      |
   7     |     6      |
   8     |     7      |
   8     |     8      |

So, all cells in column C are formulas. When updating any cell in column A, C1 is recalculated, C2 unaffected, but C3 is only recalculated if A3 (or B3) is changed

Similar for changes in column B: C2 is properly calculated, C3 only when one happens to change the value in B3

Other changes in column A and B do not propagate to C3
Comment 1 Dominique (DimStar) Leuenberger 2020-10-21 15:07:13 UTC
Created attachment 166592 [details]
Sample file used to test

This is the file I tried to describe in comment #0

I tested this with LibreOffice form openSUSE and also with LibreOffice from flathub (flatpak) to exclude errors on the packaging done by openSUSE
Comment 2 Dominique (DimStar) Leuenberger 2020-10-21 15:10:03 UTC
Version info as copied out of LO/Calc
Build ID: 00(Build:2)
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 3 Xisco Faulí 2020-10-21 15:39:40 UTC
Thanks for reporting this issue.
it looks like a duplicate of bug 137248 which fix will be available in LibreOffice 7.0.3

*** This bug has been marked as a duplicate of bug 137248 ***