Issue 109101 - Reference to external sheets with # in their name
Summary: Reference to external sheets with # in their name
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO310m19
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: yfjiang
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-02-10 09:53 UTC by korsi
Modified: 2017-05-20 10:33 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 korsi 2010-02-10 09:53:25 UTC 
Referencing to sheets in external files with # in their name gives an error
(#NAME?) when reopening the file.

How to reproduce.

1. Create two documents. In document A, change the name of sheet1 to sheet#1.
2. In document B, reference to a cell in A.sheet#1
3. Save both documents and close them.
4. Open document B, and the reference gives an error.
Comment 1 kyoshida 2010-02-11 06:44:47 UTC 
confirmed.
Comment 2 kyoshida 2010-02-11 06:45:20 UTC 
I'll look into this.
Comment 3 kyoshida 2010-02-11 06:45:40 UTC 
started.
Comment 4 kyoshida 2010-03-08 18:42:47 UTC 
Found another problem while working on fixing this.  When an external cell
contains a string value with '#' in it, the cache only picks up the part after
the '#' character.
Comment 5 kyoshida 2010-03-08 18:47:03 UTC 
Both issues have been fixed, in the koheiextref01 cws.
Comment 6 kyoshida 2010-04-29 03:24:50 UTC 
Re-assigning to oc for verification.
Comment 7 kyoshida 2010-05-26 16:31:23 UTC 
Re-assigning to Yi Fan for verification.
Comment 8 yfjiang 2010-05-31 03:30:50 UTC 
Verified on SLED 11 sp1 and Windows xp sp3.