Created attachment 104972 [details]
Simple formulas not working in 220.127.116.11 version of LO
I would like to bring to your notice that the simple formulas are not returning the values correctly at the initial moment. For example I am attaching the sheet and the screenshot can someone help on this.
Bug: In the column D the values are not getting calculated fromsum(D12:D14) wherein it calculates for D12 and D13 only.
Version used: 18.104.22.168
Created attachment 104973 [details]
Formulas issue attached version 22.214.171.124
I don't know how you managed to get those results, also H14,J14,K14,J14,M14 don't reflect the current state, the results are stored in the document file, but a hard recalculation once fixes it, hit Shift+Ctrl+F9
Did you enter the value in D14 while AutoCalculate was off? Or do you know what happened during that time?
Also, this is not a blocker, and please don't set a bug to ASSIGNED status.
Further to our discussion with the user what he is trying to do is.
He is calculating sum(E8:E10) in a new Libre office sheet.
E11=sum(E8:E10) that is 6.
Now user saves the sheet and closes. He opens the same sheet and changes the values in the column E9 from 2 to 3.
E11=sum(E8:E10) that is 7.
Here is the issue-> now user wants to recall the changes so he presses Ctrl+Z. The values are not getting reflected automatically unless we press Ctrl+Shift+F9. Please assist.
In users PC autocalculate is turned all already.
Awaiting your response
Adding to the above issue I tested the same with 4.3.31 version- If a value is changed its getting reflected. For example if I am removing the value from one particular cell and leaving it as blank then do a undo action it does not auto calculate the value.
Awaiting your response.
(In reply to comment #3)
> Here is the issue-> now user wants to recall the changes so he presses
> Ctrl+Z. The values are not getting reflected automatically unless we press
> Ctrl+Shift+F9. Please assist.
This is a "Undo not recalculate" problem.
Fix by Kohei :
*** This bug has been marked as a duplicate of bug 80846 ***