references change when copying sheet [closed]

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

Anonymous

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

add a comment

0

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

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

Comments

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 ( 2013-03-01 02:30:12 +0200 )edit

add a comment

0

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

Gaffer
121 ●10 ●13 ●20

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

add a comment

references change when copying sheet [closed]

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

Comments

Question Tools

Stats

Related questions

references change when copying sheet [closed] edit

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

Comments

Question Tools

Stats

Related questions

references change when copying sheet [closed]

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