If I delete a cell content that is used in a formula of another cell and undo the deletion the formula does not recalculate even if forced to do so with F9 or after reopening the document.
Steps to reproduce:
1. Open a new spreadsheet.
2. Type in 3 values in one column, e.g. 1,5,8 in A1 - A3
3. In cell A4 type: =SUM(A1:A3). The cell displays 14.
4. Now delete the contents of e.g. cell A2 (5). A4 correctly shows 9.
5. Now undo the deletion using the undo-function.
A4 continues showing 9 but should be 14 again. Even if closing and reopening the document or recalculating with F9 the wrong value stays until you reedit one of the cells.
This is a showstopper since in large tables you cannot ensure correct values in all formulas!
After undoing the deletion A4 should show 14 again.
Additional info: this error does not appear in OpenOffice.
Operating System: Windows 7
Version: 220.127.116.11 release
Hello..this problem's been known. Thanks for reporting
*** This bug has been marked as a duplicate of bug 80846 ***
Ok, thank you.
At least it led me to the (temporary) solution of the problem for me: hard recalc with Ctrl+Shift+F9.
Unfortunately Google didn't find any forums where someone posted the solution :-(