References change when copying sheet

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!

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 :slight_smile:

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?

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’.