Issue 105700 - External range references exported incorrectly to Excel document.
Summary: External range references exported incorrectly to Excel document.
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOO310m19
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo
Depends on:
Reported: 2009-10-07 19:45 UTC by visispace
Modified: 2017-05-20 09:57 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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

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 :

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?

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.