Bug 57110 - Absolute references to cells in copied area handled as relative references (FEATURE)
Summary: Absolute references to cells in copied area handled as relative references (F...
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-11-14 07:51 UTC by rene.zw
Modified: 2013-12-22 17:23 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
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 rene.zw 2012-11-14 07:51:42 UTC 
Behaviour in Version 3.5:
If several cells are copied, where one of the copied cells has an absolute reference to another cell in the copied area, the absolute reference will change.

This behaviour is very charming, e.g. if you want to rearrange a worksheet.

In version 3.6 we are back on the same behaviour like in Excel... 

Referring to discussion of BUG 55603, I want the behaviour of version 3.5 back. Or at least a possibility do force this behaviour.
Comment 1 Joel Madero 2013-11-24 23:29:42 UTC 
Markus - any thoughts on this one - it's confirmed but adding yet another option in our endless number of options to "fix" something that was purposely done. Not sure what to do about it.
Comment 2 Markus Mohrhard 2013-11-25 10:49:59 UTC 
I'm sorry but the current behavior is the wanted and expected one.