Bug 57110

Summary:	Absolute references to cells in copied area handled as relative references (FEATURE)
Product:	LibreOffice	Reporter:	rene.zw
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WONTFIX	QA Contact:
Severity:	enhancement
Priority:	medium	CC:	jmadero.dev, markus.mohrhard
Version:	3.6.3.2 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
i915 platform:		i915 features:

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.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.