Description: 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
Created attachment 166106 [details] rename to ending point ods as bugzilla wants no ods ending a
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 ***
I also assume the version you saw this bug happening is actually 7.0.2.x, and you only chose "7.0.1.2 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.
there is a massive fresh fail, 7.1.0.0.a0+ 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),