Issue 69139 - 'Link to external data' wizard does not access the files
Summary: 'Link to external data' wizard does not access the files
Status: CLOSED DUPLICATE of issue 1834
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.3
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2006-08-31 12:23 UTC by evoci
Modified: 2006-09-01 10:32 UTC (History)
1 user (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 evoci 2006-08-31 12:23:46 UTC
Choosing 'Insert - Link to External Data' opens the External Data dialog.
You select a spreadsheet.
Available tables/ranges does not appear, and OK button is grayed
Comment 1 frank 2006-08-31 13:15:56 UTC
Please use the query facilities of Issuezilla before submitting Issues. A simple
search for External data in the description field and Spreadsheet as component
would have shown Issue 1834 which this one is a duplicate of.


*** This issue has been marked as a duplicate of 1834 ***
Comment 2 frank 2006-08-31 13:16:11 UTC
closed double
Comment 3 evoci 2006-08-31 13:48:49 UTC
Frank, thanks for this.

Please note the following:
1) It is my habit to query for issues, in order to save mine and other's time.
2) Running the query you suggest does not points to the 1834
3) I understand (and it was not simple, believe me) that 1834 is related to CSV
files, which is not my case. 1834 claims that this function is intended for
spreadsheets or files with objects, which is what I am trying to.

Finally, I would be grateful if you can explain me how this issue (try linking a
spreadsheet does not light OK) is related to 1834, which is marked 'FIXED'
Thanks for your time, and consider that I am just trying to contribute.

Comment 4 frank 2006-09-01 10:31:53 UTC

this is an extract from the Help system regarding External Data; inserting :

You can use the same method to insert ranges defined by *name* from a Calc or
Microsoft Excel spreadsheet.

So your Spreadsheet probably does not contain any range name and therefore could
not be linked in this way. Issue 1834 solved this problem by inserting a new
Menu command 'Insert-Sheet from file'. Therefore this is a double to Issue 1834.

Sorry if I sounded harsh, but in most cases the problem is with CSV ot text
files and the external data dialog. Your case is a special case of it. And yes,
the query doesn't show up 1834 directly but a lot of duplicates and following
these you finally gets to Issue 1834..

Thanks for your contribution.


*** This issue has been marked as a duplicate of 1834 ***
Comment 5 frank 2006-09-01 10:32:15 UTC
closed double