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
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 7.0.2.2 form openSUSE and also with LibreOffice 7.0.2.2 from flathub (flatpak) to exclude errors on the packaging done by openSUSE
Version info as copied out of LO/Calc Version: 7.0.2.2 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
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 ***