Issue 91607 - Link To External Data Fails On External CSV Data
Summary: Link To External Data Fails On External CSV Data
Status: CLOSED DUPLICATE of issue 1834
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.4.1
Hardware: HP (PA-RISC) Windows Vista
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2008-07-12 22:42 UTC by nrulnyocto
Modified: 2016-07-03 01:59 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 nrulnyocto 2008-07-12 22:42:31 UTC
I try to link to the following external data,, using Insert
- Link To External Data.  The OK button never becomes enabled.

I read through the entire disposition of, and this resolution,
treating CSV data as an "IMPORT" is just not the correct way to handle this.

Linking to External CSV data needs to work exactly as linking to HTML table data
does.  For example:

Linking to the link below functions just fine:
By just fine, I mean I can link to it and update the data in my spreadsheet
every day from the link.

However, linking to the CSV data, again at the below link for example, doesn't
I can only Import this into a new sheet.  It's a one time deal.  This needs to
work like the HTML table link.  I need to be able to link to this data and
update the data in my spreadsheet from the link.
Comment 1 andybrandt 2008-09-17 16:51:39 UTC
I have the same problem, what I want to access is a currency exchange rates that
are made available by my bank as a csv file
( When I try to use "Link To
External Data" and use URL above I do get an import window with a proper
recognition of columns (after all it is csv), but when I click OK the button for
adding the data source is still grayed out. "Solution" proposed by some to open
files doesn't apply here - I'd have to manually download this csv every hour and
re-open it in my spreadsheets which is purely idiotic. Please fix this!
Comment 2 frank 2008-09-17 17:26:02 UTC

what's wrong with Insert Sheet from file.
Paste the URL into the file open dialog
Click Ok
tag the Link box
and insert the file this way.

If you want an update just go to Edit-Links an update it. You may place a button
on your sheet to shorten the way it works, but this Issue here is a double to
Issue 1834 and therefore closed as such.


*** This issue has been marked as a duplicate of 1834 ***
Comment 3 frank 2008-09-17 17:26:43 UTC
you may have to switch to the dialogs under tools options.
Comment 4 andybrandt 2008-09-17 20:12:47 UTC
As replied in the 1834:

To answer comment in issue #91607 - what's wrong with doing it via "Insert sheet
from file..."? Everything is wrong with it:
- it is illogical - no one would ever think of using it to connect to a clearly
external resource, that is refreshed periodically just made available as a .csv
not .html,
- there is even no mention in the file dialog that you could even type URL-s
there! It wouldn't have occurred to me, and I'm in IT since 1989.

This is a crude workaround at best. I don't know why this resistance to making
OO's UI smoother and working better by allowing all kinds of external resources
to be properly inserted from their proper menu entry. Why don't make it easier
for users?
Comment 5 andybrandt 2008-09-17 20:13:26 UTC
Please, re-open this issue - it is not fixed! The fact that a crude workaround
exists doesn't fix it.
Comment 6 andybrandt 2008-09-17 20:17:12 UTC
Oh, and BTW - this method does not allow automatic refreshing of the data.
Inserted file is downloaded and inserted once, no link appears in Edit->Links,
no way to refresh it other than manually. 
Comment 7 nohavecd 2010-02-12 23:08:54 UTC
I agree that Insert Sheet from File... does not work well.  I typically use 
sheets that have partial cells imported from external files, and other parts 
that are static, non-changing cells and formulas.  When you update the sheet, 
it basically wipes out the entire sheet and imports the external one...

It needs to function like Excel where just a range of cells are linked to the 
external data.