Apache OpenOffice (AOO) Bugzilla – Issue 99844
calculated cells not updating when deleting the underlying cell's content
Last modified: 2013-08-07 15:14:39 UTC
(hope this isn't a duplicate, but it's hard to guess what terms one would need to search for here ...) - open the attached spreadsheet document - select cells A1 and B1 - press DEL - in the "Delete Contents" dialog, check "All" (actually, "Numbers" is the one which matters here) - press OK => the content of A1 and B1 is removed => C1 still displays "2". This is actually wrong, since C1 contains the sum of A1 and B1. If you do the very same in OOo 3.0.1, C1 is correctly updated to "0". In OOO310.m3, if you save, close, and re-open the document, the C1 also correctly displays "0".
regression => nominating as blocker for 3.1
Also broken in m41. The "bugdoc" is not attached, but I assume it has been "=A1+B1" in "C1" You also loose the formula in "C1". The cell-relations are replaced by the numbers of the deleted cells and you find "=1+1"
Created attachment 60661 [details] document to reproduce the bug case
I have build a OOoDEV300m42 (build 9386). There the error not occurs. I see the error in OOo3.1m3 (build 9387).
The error will occur in DEV300m43, where CWS dr66 has been integrated into.
fixed in CWS OOO310/calc31stopper
back to QA
Seen ok in CWS -> verified
Seen ok in current master -> closed