First time here? Check out the FAQ!
asked 2012-10-25 20:11:25 +0200
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
answered 2012-10-26 00:02:17 +0200
This post is a wiki. Anyone with karma >750 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?
answered 2012-10-25 22:48:04 +0200Gaffer
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 :-)
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-10-25 20:11:25 +0200
Seen: 62 times
Last updated: Oct 26 '12