Issue 96529 - Named range used on another sheet gives different reference.
Summary: Named range used on another sheet gives different reference.
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: recent-trunk
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: regression
: 97225 97789 (view as issue list)
Depends on:
Blocks: 93339
  Show dependency tree
 
Reported: 2008-11-24 12:13 UTC by ooo
Modified: 2013-08-07 15:14 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 ooo 2008-11-24 12:13:00 UTC 
Note: This is about OOO300_m12, version field set to 'current' because
OOO300m12 does not exist yet.

1. On Sheet1 define a named range 'foo' with reference $Sheet1.$B$3:$D$5
   and close dialog.
2. Switch to Sheet2.
3. Open the Define Names dialog again and look at the definition of
   'foo', the reference now reads $Sheet1.$B$3:Sheet2.$D$5 and behaves
   as such.
Comment 1 ooo 2008-11-24 12:44:11 UTC 
This regression may have been be introduced with issue 94124.
Comment 2 ooo 2008-11-24 18:10:09 UTC 
In cws i96529:

sc/source/core/tool/refdata.cxx  1.7.122.1.2.1
Comment 3 ooo 2008-11-25 12:53:11 UTC 
Reassigning to QA.
Comment 4 oc 2008-11-26 15:42:27 UTC 
verified in internal build cws_i96529
Comment 5 erack 2008-12-14 14:07:28 UTC 
*** Issue 97225 has been marked as a duplicate of this issue. ***
Comment 6 ooo 2009-01-07 12:25:22 UTC 
*** Issue 97789 has been marked as a duplicate of this issue. ***
Comment 7 amy2008 2009-01-13 12:01:36 UTC 
Verified with OOo300m15
Closing