references change when copying sheet [closed]
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