Issue 105700

Summary: External range references exported incorrectly to Excel document.
Product: Calc Reporter: visispace <visispace>
Component: save-exportAssignee: AOO issues mailing list <issues>
Status: CLOSED IRREPRODUCIBLE QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOO310m19Keywords: needmoreinfo
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description visispace 2009-10-07 19:45:20 UTC 
When using the Define Name feature to define an area in an external spreadsheet
the formatting used for the path is incompatible with Excel.

Calc is able to import the reference from Excel, however on reopenning the file
in Excel after saving from Calc, the Name path is corrupted, as far as Excel is
concerned.

In the example below I am using a network path:

Saved in Excel as :
='G:\Reference\[Reference Codes.xls]Project Codes'!$A$7:$B$222

Converted upon opening in Calc to :
'file:///G:/Reference/Reference Codes.xls'#$'Project Codes'.$A$7:$B$222

Result upon returning to Excel :
=#REF!


This is a critical feature in a critical document in my workplace; this
compatibility bug inhibits our conversion to OO.

Thank you kindly.
Comment 1 kyoshida 2009-10-07 19:54:15 UTC 
It's a duplicate.  BTW the core functionality is already in place, but disabled,
blocking on ODF TC's file format change approval.

*** This issue has been marked as a duplicate of 3740 ***
Comment 2 kyoshida 2009-10-07 19:54:42 UTC 
closing a dupe.
Comment 3 visispace 2009-10-07 22:48:31 UTC 
Hi kohei,

I had performed a search on [Summary:define&&names,
Description:excel||interopability||external||sheet] and did not see any of the
prior duplicates or the original.

The thread for issue #3740 does not really specify the Names:Define feature by
name, however I trust that "named spaces" encompasses it, yes?

Thanks!
Comment 4 kyoshida 2009-10-08 01:45:26 UTC 
Names ranges == defined names in this context, so yes.
Comment 5 kyoshida 2009-10-08 13:52:24 UTC 
Ah, sorry, I mis-understood this bug report because of the use of "define name".
 This has nothing to do with defined names, or range names, but everything to do
with external range reference.
Comment 6 kyoshida 2009-10-08 13:53:24 UTC 
better, more accurate title.
Comment 7 Edwin Sharp 2014-01-02 11:34:13 UTC 
Please attach spreadsheet.
Comment 8 Edwin Sharp 2014-01-16 10:27:43 UTC 
No info from author.