Bug 137275 - suddenly calc no more changes results after changing the content of one cell
Summary: suddenly calc no more changes results after changing the content of one cell
Status: RESOLVED DUPLICATE of bug 137248
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2020-10-05 20:58 UTC by gerdl
Modified: 2020-10-08 13:06 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

rename to ending point ods as bugzilla wants no ods ending (9.68 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-10-05 21:08 UTC, gerdl

Note You need to log in before you can comment on or make changes to this bug.
Description gerdl 2020-10-05 20:58:33 UTC
Fill cells with numbers. One number points to another cell with a number in it.
Set the sum of all numbers in a cell. You get the sum. Change the number in the pointed cell that is part of the sum. Computing is set to auto. The sum is not changed. You have to push F9 ore save the file, then sum is computed.

Steps to Reproduce:
1.read in the attached file
2.change the number
3.sum is not changed, you have to press F9, computing i set to auto

Actual Results:
no more automatic changing in calc

Expected Results:
sum is not changed

Reproducible: Always

User Profile Reset: No

Additional Info:
sum has to be computed automatic, auto is set.
no problems with version 6.4.7
Comment 1 gerdl 2020-10-05 21:08:47 UTC
Created attachment 166106 [details]
rename to ending point ods as bugzilla wants no ods ending

Comment 2 Ming Hua 2020-10-05 21:10:49 UTC
Thanks for reporting.  This issue about automatic recalculation looks the same as the one reported in bug 137248, so I'm marking this bug as DUPLICATE.

If you disagree, feel free to change it back to UNCONFIRMED and add a brief reasoning.

*** This bug has been marked as a duplicate of bug 137248 ***
Comment 3 Ming Hua 2020-10-05 21:15:24 UTC
I also assume the version you saw this bug happening is actually 7.0.2.x, and you only chose " release" in bugzilla's version field because 7.0.2 versions are not available there.

Version 7.0.1 shouldn't have this bug and you can re-install the old version if this bug is bothering you too much.
Comment 4 b. 2020-10-08 13:06:22 UTC
there is a massive fresh fail, from 2020-10-04 win7(x64) also affected, 
full repro incl. a new construction of a calculation with one value referenced from another cell failing, 
failing with and without 'parallelizing', 
such simple things worked correctly in former versions, 
how could this pass unit tests??? 
from a quick check: fail looks dependent of the sum formula cell being in the same column as the referencing cell whose value is changed by changing the referenced cell, and below it in the sheet, other places look safe (not excluded from autocalculate),