Bug 87380 - Improper or incomplete reference updates when moving cells between sheets in Calc
Summary: Improper or incomplete reference updates when moving cells between sheets in ...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.4.1 release
Hardware: x86 (IA32) All
: medium critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-12-16 21:16 UTC by klsu
Modified: 2014-12-22 14:25 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
test file (31.08 KB, application/x-zip-compressed)
2014-12-17 12:29 UTC, raal 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description klsu 2014-12-16 21:16:56 UTC 
If I move cells with formulas that refer to other cells on that sheet from one sheet to another, the references to those cells that were moved in the cells that were not moved are not updated to show they are now referencing another worksheet, e.g., on Sheet1 enter 12 in A1, 14 in A2, =A1+A2 in A3, =A3*A1 in B3, =B3+E3+A2 in C3, =A2+A1 in D3, =B3-A1 in E3, select and cut B3:C3, select cell K19 on Sheet2 and paste. After moving, the cell references in cell E3 on Sheet1 are displayed incorrectly.

This may be related to bug 84652.
Comment 1 raal 2014-12-17 10:01:46 UTC 
I can confirm with LO 4.3.4, win7


K19  =List1.A1*List1.A2
L19 =List2.K19+List2.N19+List1.A2   -> mismatch List1, List2
M19 =List1.A2+List1.A1
N19 =List2.K19-List1.A1    -> mismatch List1, List2
Comment 2 raal 2014-12-17 12:29:53 UTC 
Created attachment 110948 [details]
test file
Comment 3 Cor Nouws 2014-12-21 20:07:10 UTC 
was this OK in previous versions?
Comment 4 klsu 2014-12-22 14:25:46 UTC 
I have determined that in LO Calc 4.4.0 Beta2 Dev Daily installed 2014-12-18, this problem no longer exists.