Ask Your Question

references change when copying sheet [closed]

asked 2012-10-25 20:11:25 +0100

anonymous user


Please consider a spreadsheet with initially three sheets. Enter data in Sheet1 and in Sheet2. In Sheet3, enter a reference to a cell in Sheet1, something like "=Sheet1.D10" Now, if you produce a copy of Sheet3 and select "move to end", the reference will now point to "=Sheet2.D10". If you instead place the copy with "insert before" Sheet3, the reference remains to "=Sheet1.D10". This behaviour is present in OOo3.2 as well as in LibreOffice 3.4.5, so I guess it's a Feature rather than a bug. I'm afraid but I find it non-intuitive, to say the least. Is there any way to customise the copying of sheets such that any references remain unchanged? Thanks in advance for any advice you can give! Klaus

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 19:35:23.456133

2 Answers

Sort by » oldest newest most voted

answered 2012-10-26 00:02:17 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Thanks for the quick reply! Yes, I agree that there could be cases where you might want it as a feature.

Take this then as an example of what I like to achieve: A number of sheets contain parts list, let's say parts sourced from different vendors. Then I have a sheet that collects the info from all the parts lists together (all parts make one specific product). Finally when I want to create a new "product" sheet, very similar to the first, referencing the same parts lists: Copy sheet ==> failed due to the feature ;-(

Hence I ask whether maybe this feature could be customised?

edit flag offensive delete link more


Hi @KID, If you'd like to customize or see changes to this "feature," please file an enhancement bug and provide as much information about this new feature as possible. Don't forget to mark your bug as an 'enhancement'.

qubit gravatar imagequbit ( 2013-03-01 02:30:12 +0100 )edit

answered 2012-10-25 22:48:04 +0100

Gaffer gravatar image

That's a fabulous feature. It makes it easy to work in three dimensions.

By way of example, lets take your example and turn it into a Fibonacci sequence.

It makes it easy to do a spreadsheet for your accounts for Jan, bring the totals into the next sheet in Feb, then replicate the layout and relationships for the rest of the year. Learn to love it :-)

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2012-10-25 20:11:25 +0100

Seen: 446 times

Last updated: Oct 26 '12