Jim Byrnes wrote
On 08/21/2014 03:16 PM, Mark Bourne wrote:Jim Byrnes wrote:Put http://finance.yahoo.com/d/quotes.csv?s=AAPL&f=a in the URL boxThe 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.
As Mark correctly pointed out this facility is for linking to other (local) spreadsheet files or (remote) HTML tables. The enhancement request to get this facility extended to include CSV is https://bugs.freedesktop.org/show_bug.cgi?id=35040 Try using this link instead: https://au.finance.yahoo.com/q?p=finance.yahoo.com&s=AAPL You will still need to select the appropriate HTML table from the page (probably HTML_2). Also note that under v184.108.40.206 and v220.127.116.11 this facility is working, but note it has had problems during the v4.0.x, v4.1.x, and 4.2.x series and under v18.104.22.168 it appears to (again) not be working. ----- Best wishes, Owen. -- View this message in context: http://nabble.documentfoundation.org/Link-to-external-data-question-tp4119778p4119827.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: firstname.lastname@example.org 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