Issue 98185 - Spreadsheet sheet copy changes sheet reference in formulas
Summary: Spreadsheet sheet copy changes sheet reference in formulas
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 3.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: https://bugs.launchpad.net/bugs/243271
Keywords:
Depends on:
Blocks:
 
Reported: 2009-01-18 06:10 UTC by ccheney
Modified: 2016-11-15 20:35 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Testcase showing clearly what's going wrong (71.16 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-11-15 20:35 UTC, Jean-Louis 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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