Hi :) Changing the file-ending doesn't change the format of the data itself within the file.
I tried editing the url address to replace csv with ods and a file did get downloaded but it wasn't really an ods - just some sort of text file which Calc correctly identified as being like a csv and gave me the usual options (which Jim already covered). It would be handy to go back to the web-page the file came from and try to see if there are any other formats available. One day people might even start putting Ods files up so that everyone can read them. At the moment they seem to use XlsX too often (which no-one can read properly unless they get lucky) and thus 'have to' provide a Pdf too, which is also difficult to import or copy&paste from. Some wiser places do provide files in the older MS formats (so that's Xls without the X at the end) as the non-OOXML format is easily read by everyone at the moment. So, Jim, is it possible to give a link to the page that you downloaded the file from? Then we can try to see if there is a better format for downloading. My guess is that because it's Yahoo they are a bit clueless about IT issues and don't give good formats. Regards from Tom :) On 22 August 2014 06:24, Florian Reisinger <[email protected]> wrote: > Hi, > 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 <[email protected]> > wrote: > >On 08/21/2014 03:16 PM, Mark Bourne wrote: > >> Jim Byrnes wrote: > >>> I would like to import some stock quotes from finance.yahoo.com into > >a > >>> calc sheet. > >>> > >>> As a test I select cell A1 > >>> Insert-->Link to External Data and I get the External Data dialog > >>> Put http://finance.yahoo.com/d/quotes.csv?s=AAPL&f=a 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 > >Fields > >>> section > >>> > >>> 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 > >A1. > >>> > >>> What do I need to do to get the stock quote entered in the cell? > >> > >> I haven't used that feature before, but > >> https://help.libreoffice.org/Calc/Link_to_External_Data says: > >>> Link to External Data > >>> Inserts data from an HTML, Calc, or Excel file into the current > >sheet > >>> 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 > >named > >> range (CSV is a very basic format, and doesn't support naming > >ranges). > >> 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 > >the > >> "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 > >never > >> 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 > >importing > >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 > > > >lost. > > > >> It may be possible to pick up data from a table on an HTML page. > >That's > >> liable to stop working when Yahoo change the layout of the page > >though, > >> requiring you to go through the Insert > Link to External Data again > >to > >> 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. > >It > >> 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 > >intended, > >> but probably worth trying. I'd suggest not modifying the imported > >sheet, > >> 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! > >> > >> Mark. > >> > > > >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: [email protected] > >Problems? > >http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > >Posting guidelines + more: > >http://wiki.documentfoundation.org/Netiquette > >List archive: http://listarchives.libreoffice.org/global/users/ > >All messages sent to this list will be publicly archived and cannot be > >deleted > > -- > Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail > gesendet. > -- > To unsubscribe e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
