Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Can you please try to use the file name without the ".CSV" as table name? 

Sorry I cannot provide more info now....

On 22. August 2014 02:35:58 MESZ, Jim Byrnes <> wrote:
On 08/21/2014 03:16 PM, Mark Bourne wrote:
Jim Byrnes wrote:
I would like to import some stock quotes from into
calc sheet.

As a test I select cell A1
Insert-->Link to External Data and I get the External Data dialog
Put in the URL box
The OK button stays greyed out
I hit ENTER and I get a Text Import dialog with a number in the

When I hit OK I am sent back to the External Data dialog, OK button
still greyed out and when I close the dialog, nothing is entered in

What do I need to do to get the stock quote entered in the cell?

I haven't used that feature before, but says:
Link to External Data
Inserts data from an HTML, Calc, or Excel file into the current
as a link. The data must be located within a named range.

The URL you're using points to a CSV file, which doesn't contain a
range (CSV is a very basic format, and doesn't support naming
Using an ODS file with a named range works; after selecting the file,
the ranges defined within the file are listed in the lower part of
"External Data" dialog, and the OK button is enabled once once is
selected (with a CSV file, there are no ranges to select so OK is
enabled). But that's clearly no use to you unless Yahoo provides the
data you want in that format...

OK I understand now.  Just seems strange that I can get the data I want

in the Import Text dialog (just as I have done many times when
csv files) but I can't get it into the spreadsheet. When I click ok in 
the Import Text dialog, focus goes to the Insert Dialog and the data is


It may be possible to pick up data from a table on an HTML page.
liable to stop working when Yahoo change the layout of the page
requiring you to go through the Insert > Link to External Data again
find the table in the new layout, but might work well enough.

Another possibility may be Insert > Sheet from File, specify that URL
rather than browsing to a local file, and select the "Link" option.
seems to be rather slow to import (maybe that's just my Internet
connection), and I'm not certain if it will actually update as
but probably worth trying. I'd suggest not modifying the imported
in case either you loose your changes when the sheet is updated or
modifying it prevents future updates. You can then reference cell A1
from another sheet, which should then pick up changes assuming the
imported sheet does update as intended.

When I try this option I don't see any place to specify the URL, all I 
see is a file selection dialog.

Yet another option may be to set up a LibreOffice Base database
connection pointing at the CSV file as its data source. (File > New >
Database > Connect to existing > Spreadsheet > Next > Enter URL >
Next >
Finish). Not sure offhand if or how you can reference that from your
spreadsheet though, and it is getting rather extreme just to get a
single number!


The whole thing is getting complex.  I just wanted to link about 10 
cells so I wouldn't have to type in the data manually.  Not a big 
problem it's just that I am always looking for ways to automate stuff.

Thanks,  Jim

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.
To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.