Bug 45370 - EDITING: Calculated cell contents not updated after copy - paste - delete of source values
Summary: EDITING: Calculated cell contents not updated after copy - paste - delete of ...
Status: RESOLVED DUPLICATE of bug 44143
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Master old -3.6
Hardware: Other All
: medium major
Assignee: Kohei Yoshida
Keywords: regression
Depends on:
Blocks: mab3.5
  Show dependency treegraph
Reported: 2012-01-29 06:58 UTC by john.pratt
Modified: 2012-01-31 14:45 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

First attachment (10.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-01-29 06:58 UTC, john.pratt
Second attachment (8.37 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-01-29 07:01 UTC, john.pratt
Sample Document (8.96 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-01-29 11:06 UTC, Rainer Bielefeld Retired

Note You need to log in before you can comment on or make changes to this bug.
Description john.pratt 2012-01-29 06:58:14 UTC
Created attachment 56290 [details]
First attachment

When deleting an area of data only some of the formulae which reference that data update (somtimes).

The first attachment is an old file, but the second one is a new version (same/similar formulae, but created from scratch in 3.5.0rc2).

This seems to be a reliable way to make it happen:
1) Open either of the attached spreadsheets
2) Highlight cells A1:B9 and copy
3) Place cursor on A10 and paste
4) Highlight A1:B18 and press delete (on the keyboard)

Result: C10:C18 disply the text "test test"
Expected result: C10:C18 display the text "".

Alternative step 4:
4) Undo the previous action

Result: C10:C18 disply the text "test test"
Expected result: C10:C18 display the text "".
Comment 1 john.pratt 2012-01-29 07:01:42 UTC
Created attachment 56291 [details]
Second attachment
Comment 2 Jean-Baptiste Faure 2012-01-29 08:59:40 UTC
Very strange behavior. I reproduce with LO 3.5.0 rc2+ under Ubuntu 11.10 x86_64
(LibreOffice 3.5.0rc2+ Version ID : 20ec7c1-ed94322-5cd2479-2386a41-138191a)

No problem with LO 3.4.5 -> Keyword regression added.

Best regards. JBF
Comment 3 Rainer Bielefeld Retired 2012-01-29 11:05:17 UTC
[Reproducible] with "LibreOffice 3.5.0 RC2 German UI/Locale [Build-ID: e371a95-bf68a13-5a1aa2b-d3c1ae9-b938258] on German WIN7 Home Premium (64bit)  

Very old problem, I also see it in a Master from July 2011

But woks fine with "LibreOffice 3.4.5 German UI [Build ID: OOO340m1 (Build:502)]" parallel Server installation on German WIN7 Home Premium (64bit) 

Problem is not limited to particular formulas, I also see it in a new Document "mysample10.ods" with simple "=A11+B11". The only condition is order of actions 'Copy -> Paste to empty cells -> Delete'

Steps how to reproduce with "mysample10.ods":
1) open document
2) Highlight cells A1:B10 and copy
3) Place cursor on A11 and paste
   > C11 ... C20 shows values
4) Press <Del> to delete still highlighted A11:B20
   Expected: values C11:C20 become 0
   Actual: values stay

Menu 'Options -> Cell Contents -> Update' will not work
Toggling any checkbox in menu 'Tools -> Options -> Calc -> Calculate -> Input Settings' will make the values change, after a new paste - delete a new checkbox toggle will be necessary to update calculated values.

Step 4 works as expected if A11:B20 were not empty before you start the test (I checked with all "1").

That's serious.

I am pretty sure that this one has the same roots like "Bug 44143 - formula's that use data from pivot table don't update with the pivot table"

Good shot!
What's your OS?

Please feel free to reassign (or reset Assignee to default) if it’s not your area or if provided information is not sufficient. Please set Status to ASSIGNED if you accept this Bug.
Comment 4 Rainer Bielefeld Retired 2012-01-29 11:06:49 UTC
Created attachment 56299 [details]
Sample Document

See Comment 3
Comment 5 Rainer Bielefeld Retired 2012-01-29 11:07:19 UTC
OS "All" due to comment 2
Comment 6 john.pratt 2012-01-29 12:00:18 UTC
I found it using Windows XP (SP3) as my OS.

Comment 7 Eike Rathke 2012-01-31 14:45:12 UTC
Very likely a duplicate, at least it's in the delete area and appears fixed with bug 44143.

*** This bug has been marked as a duplicate of bug 44143 ***