Issue 99844 - calculated cells not updating when deleting the underlying cell's content
Summary: calculated cells not updating when deleting the underlying cell's content
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOO310m3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@sc
Keywords: regression
Depends on:
Blocks: 95768
  Show dependency tree
Reported: 2009-03-04 06:14 UTC by Frank Schönheit
Modified: 2013-08-07 15:14 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

document to reproduce the bug case (6.69 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-03-04 08:39 UTC, Frank Schönheit
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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