Issue 69140 - External links to areas fail
Summary: External links to areas fail
Status: CLOSED DUPLICATE of issue 41183
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.4
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-08-31 12:31 UTC by evoci
Modified: 2007-01-12 13:07 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 evoci 2006-08-31 12:31:08 UTC 
Cell A1 contains "'File:///C:/test.ods'#$Sheet1.A1"
Cell A2 contains "'File:///C:/test.ods'#$Sheet1.A1:B5"
formula "=SUM(INDIRECT(A1))" --> OK
formula "=SUM(INDIRECT(A2))" --> Err:502
formula "=SUM(INDIRECT(A1 & ":B5"))" --> Err:502
formula "=SUM(INDIRECT(A1 & ADDRESS(2;5)))" --> Err:502

Additionally: why three slashes are needed after 'file:'? Shouldn't be like
'file://C:.....' instead?
Comment 1 gercokees 2006-11-20 10:06:27 UTC 
Changed version to OOo 2.0.4 and cConfirmed this issue
Comment 2 gercokees 2006-11-20 13:45:33 UTC 
There is a workaround by the way...
formula "=SUM(OFFSET(INDIRECT(A1);0;0;5;2))" will actualy work
Comment 3 frank 2007-01-12 13:07:03 UTC 
double to Issue 41183

*** This issue has been marked as a duplicate of 41183 ***
Comment 4 frank 2007-01-12 13:07:27 UTC 
closed double