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.
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:
Depends on:
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: ---

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

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