Issue 98185

Summary: Spreadsheet sheet copy changes sheet reference in formulas
Product: Calc Reporter: ccheney <ccheney>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, oliver.brinzing, papilucky63
Version: OOo 3.0   
Target Milestone: ---   
Hardware: All   
OS: All   
URL: https://bugs.launchpad.net/bugs/243271
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Testcase showing clearly what's going wrong none

Description ccheney 2009-01-18 06:10:45 UTC 
If you a spreadsheet with say three sheets: Sheet1, Sheet2, Sheet3.
On Sheet2 you reference a cell on Sheet1 eg =Sheet1.$A$2 and then make a copy of
Sheet2 after Sheet3 eg Sheet2_2 it will update the reference on Sheet2_2 to say
=Sheet2.$A$2 instead of staying as =Sheet1.$A$2. You can use =$Sheet1.$A$2 to
work around this issue but Excel doesn't require this so it would be good to use
similar conventions as they do.
Comment 1 Oliver Brinzing 2009-01-18 17:47:24 UTC 
on Sheet2 you reference a cell from Sheet1: =Sheet1.$A$2
Sheet1's index is 0, Sheet2's index is 1

after copying Sheet2 after Sheet3, the new newly created sheet will
reference to =Sheet3.$A$2, the next left sheet ...

> You can use =$Sheet1.$A$2
as you mentionend, this will do the trick :-)
a sheet name without leading $ is treated as a relative address

Oliver
Comment 2 Jean-Louis 2016-11-15 20:35:09 UTC 
Created attachment 85857 [details]
Testcase showing clearly what's going wrong

First sheet describes exactly the expexted formulas and the ones generated automaticaly by sheet copy