| Summary: | EDITING: Calculated cell contents not updated after copy - paste - delete of source values | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | john.pratt |
| Component: | Calc | Assignee: | Kohei Yoshida <kohei> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | major | CC: | jbfaure, john.pratt, LibreOffice |
| Priority: | medium | Keywords: | regression |
| Version: | Master old -3.6 | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 37361 | ||
| Attachments: |
First attachment
Second attachment Sample Document |
||
Created attachment 56291 [details]
Second attachment
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 [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" @john.pratt Good shot! What's your OS? @Kohei: 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. Created attachment 56299 [details] Sample Document See Comment 3 I found it using Windows XP (SP3) as my OS. JP |
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 "".