Issue 115941 - Copy/Move row does not preserver range references in function well.
Summary: Copy/Move row does not preserver range references in function well.
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.3 RC7
Hardware: PC Windows, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-12-06 11:00 UTC by eremmel
Modified: 2013-09-24 06:21 UTC (History)
2 users (show)

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

Attachments
Issue reproduction description (50.25 KB, application/vnd.oasis.opendocument.text)
2010-12-06 11:03 UTC, eremmel 		no flags Details
spreadsheet of original attachment (9.49 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2013-09-24 06:21 UTC, Edwin Sharp 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description eremmel 2010-12-06 11:00:19 UTC 
When I have a formula on a row like 'B11-SUM($B$2:B11)' and I copy/move the row
with Ctrl-Alt / Alt and mouse, the range is not well preserved and the row above
the target location is also effected. The result becomes like
'B12-SUM($B$2-B13)' Note the difference between B12 and B13. The latter should
also read B12.
See attached Writer document with detailed instructions and screen-shots.
Comment 1 eremmel 2010-12-06 11:03:25 UTC 
Created attachment 75246 [details]
Issue reproduction description
Comment 2 Edwin Sharp 2013-09-24 06:20:49 UTC 
First issue described in attachment 75246 [details] is fixed.
Second issue is confirmed with Rev. 1525015 Win 7.
See following attachment.
Comment 3 Edwin Sharp 2013-09-24 06:21:28 UTC 
Created attachment 81609 [details]
spreadsheet of original attachment