Issue 99844

Summary: calculated cells not updating when deleting the underlying cell's content
Product: Calc Reporter: Frank Schönheit <frank.schoenheit>
Component: viewingAssignee: kla <thomas.klarhoefer>
Status: CLOSED FIXED QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues, jbf.faure, rb.henschel
Version: OOO310m3Keywords: regression
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 95768    
Attachments:
Description Flags
document to reproduce the bug case none

Description Frank Schönheit 2009-03-04 06:14:57 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".
Comment 1 Frank Schönheit 2009-03-04 06:15:40 UTC 
regression => nominating as blocker for 3.1
Comment 2 merschmann 2009-03-04 07:28:45 UTC 
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"
Comment 3 Frank Schönheit 2009-03-04 08:39:54 UTC 
Created attachment 60661 [details]
document to reproduce the bug case
Comment 4 Regina Henschel 2009-03-04 08:52:13 UTC 
I have build a OOoDEV300m42 (build 9386). There the error not occurs. I see the
error in OOo3.1m3 (build 9387).
Comment 5 daniel.rentz 2009-03-04 12:03:22 UTC 
The error will occur in DEV300m43, where CWS dr66 has been integrated into.
Comment 6 daniel.rentz 2009-03-04 18:53:15 UTC 
fixed in CWS OOO310/calc31stopper
Comment 7 daniel.rentz 2009-03-05 10:08:40 UTC 
back to QA
Comment 8 kla 2009-03-09 11:16:25 UTC 
Seen ok in CWS -> verified
Comment 9 kla 2009-03-18 10:49:57 UTC 
Seen ok in current master -> closed