Issue 23214 - Sheet reference based on sheet position not name
Summary: Sheet reference based on sheet position not name
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-12-04 22:11 UTC by sbclint
Modified: 2003-12-08 08:56 UTC (History)
1 user (show)

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

Attachments
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 sbclint 2003-12-04 22:12:33 UTC 
A cell in a calculation is based on the name of a sheet dotted with the cell. 
If you copy a cell value and paste the value into a different sheet, the
reference for the sheet will become the value of the receiving sheet plus an
offset value that is based on the relative positions of the initial sheet to the
referring sheet.

For example, if we have three sheets named constants, calc_1, and calc_10.  In
calc_1 we have a reference to constants.C7.  We copy that cell into calc_10. 
The result will erroneously have calc_1.C7.  This is most likely going to lead
to an erroneous calculation.
Comment 1 frank 2003-12-05 09:43:25 UTC 
Hi,

this is not a bug but relative addressing / referencing.

If you want the absolute referencing just place a $ in front of the
addressing so it reads like this :

$constants.$C$7

Frank
Comment 2 frank 2003-12-05 09:43:42 UTC 
closed invalid
Comment 3 daniel.rentz 2003-12-08 08:56:10 UTC 
@submitter: FYI: It is the same mechanism supported for column and row addresses
-> C7 versus $C$7. MS Excel does not support this feature of addressing sheets
relatively, therefore our Excel import filter always adds the dollar signs
before sheet names in formulas.