Problem description: 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. Current behavior: 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! Expected behavior: After undoing the deletion A4 should show 14 again. Additional info: this error does not appear in OpenOffice. Operating System: Windows 7 Version: 4.2.5.2 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 :-(