Description: I have a formula calculating a value based on values of different cells. When I change other cells, the final value does not get updated. I have to save the document to see the change. Steps to Reproduce: 1. Create an .ods file with a formula that uses other multiple cells to calculate the value 2. create a copy of the file 3. formula calculation stops working in the .ods copy. Actual Results: look at the attachment. Expected Results: Value gets updated right after I change value in relevant cells. Reproducible: Always User Profile Reset: Yes Additional Info: more information
Created attachment 166293 [details] offending file. Formulas don't update.
Well, you probably should be more specific about your example file, as the formulas are not trival, and it's hard to see which cell has the wrong result. Also recalculation bugs are tricky to reproduce, it's better to give steps, like: change cell A from value X to value Y, then cell B should also change, but didn't. On the other hand, if this bug only occurs in 7.0.2 and not earlier versions, it's probably a duplicate of bug 137248.
When you change value in B63 H59, H62, H68, I62, I68 all should change. Clicking on the Cell name field in the top left updates values.
(In reply to osowiecki from comment #3) > When you change value in B63 > > H59, H62, H68, I62, I68 all should change. > > Clicking on the Cell name field in the top left updates values. OK, reproduced in 7.0.2, but not in 6.4.6. Should be a duplicate of bug 137248, marking it so. If this bug annoys you too much, you can downgrade to version 7.0.1, which shouldn't have this bug. OTOH, if you can live with this, you don't need to save the document and reopen to see the change, just use menu "Data > Calculate > Recalculate" (or keyboard shortcut F9) to update the results. *** This bug has been marked as a duplicate of bug 137248 ***