Issue 25701 - Cell value not directly accessible through named range across sheets if coordinates differ
Summary: Cell value not directly accessible through named range across sheets if coord...
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: ui (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: 2004-02-19 18:01 UTC by wallbrecht
Modified: 2004-02-20 10:15 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 wallbrecht 2004-02-19 18:01:05 UTC 
Can not directly accesss the cell value of named range (consisting of a single 
cell) across sheets if the cell source and target coordinates differ.

1. Open up a new spreadsheet.
2. Put the number "23" in cell A1 of Sheet1.
3. Assign a range name ("Data" - "Define Range...") of "twentythree" to cell A1.
4. Switch to Sheet2 and move the selection to cell B2.
5. Enter the formula "=twentythree" into cell B2.
This will result in "#VALUE!".

- Using the formula "=twentythree" in any cell of row 1 of Sheet2 gives "23".
- Using the formula "=twentythree" in any cell of column "A" of Sheet2 
gives "23".
- Using the formula "=sum(twentythree)" works correct in any cell of Sheet2.

Good luck while hunting this bug!
Comment 1 wallbrecht 2004-02-19 18:03:07 UTC 
Same problem on a single sheet.
Comment 2 frank 2004-02-20 10:15:06 UTC 
Hi,

this is not a bug of OOo Calc.

Data Define Range is to define a database range. What you need is a range name
which can be set either by pressing CTRL+F3 or choose Names - define from the
insert menu.

Frank
Comment 3 frank 2004-02-20 10:15:23 UTC 
closed invalid