A sheet can be filled with external data from the web: https://help.libreoffice.org/4.0/Calc/Inserting_External_Data_in_Table_WebQuery Obviously, data is expected to be an html table, because that works. It would be nice, if CSV was supported too! The dialog can already handle csv/text import (hitting enter in the URL input brings up the properties box), yet the "OK" button to make the connection live stays dim. Kind regards Peter
How it works if you type the url of the csv file in the field "Load URL" in the standard toolbar? Perhaps you need to activate this "button" to try it. I do not have such an url to test myself. Best regards. JBF
For you to test, a link http://dish.myzel.net/lotest.csv Insert fails, because there are no ranges created in the other box in the dialogue to select from, after the import wizard is done. The same data as html http://dish.myzel.net/lotest.html shows ranges and only selecting one of those activates the OK button.
Created attachment 89373 [details] screencopy showing that we can open a csv file provided by an http website (In reply to comment #2) > For you to test, a link http://dish.myzel.net/lotest.csv > It works for me if I copy-paste this url in the Load url combobox in the standard toolbar of Calc. Tested on version 4.1.4.0.0+ under Ubuntu 13.10 x86-64. After having copied-pasted the url, hit the Enter key and wait until the csv dialog import opens. Do the appropriate choices (comma as separator in the case of your example) and validate, you get the same thing as me in the screencopy. Best regards. JBF
I found the "Load URL" combobox - I had to add it there first. Still, this is not the same, that is just like opening a local file. "External Data" though remembers the source, and creates a "Links" item in the "Edit" menu, where a refresh can be made. Again, I suppose the "external data" wizard fails, because csv does not have "ranges". Kind regards Peter
You are right. In the case of a csv file you need to use Insert > Sheet From File... and check the checkbox "Link" in the "Insert Sheet" dialog. Best regards. JBF
Merci bien Jean-Baptiste for your helpful comments, I am learning new things about libre office every time. Yet, again, this too is something different from what this issue is about, a proposed enhancement for reading data from the web. PS: I am in control of the web service that data comes from, so I just changed the rendering to make LO able to use it. I just stumbled upon the "missing" feature -- If there is a business case, I do not know though; maybe CSV is dead and html tables rule the game nowadays, ms-excel also only can slurp those… Still, it probably is very cheap to achieve, maybe just have the csv filter populate some internal structure that is left empty now and others, that are not as fortunate as I am, might be helped with it.
*** This bug has been marked as a duplicate of bug 35040 ***
*** This bug has been marked as a duplicate of bug 114995 ***