Bug 137659

Summary:	Calc does not recalculate sheet properly
Product:	LibreOffice	Reporter:	Dominique (DimStar) Leuenberger <dimstar>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	xiscofauli
Priority:	medium
Version:	7.0.2.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Sample file used to test

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 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

Comment 2 Dominique (DimStar) Leuenberger 2020-10-21 15:10:03 UTC

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

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 ***