In OpenOffice 4.1 I can use the DDE() function to import data from ODS or CSV via HTTP. Example: =DDE("soffice","http://www.trentinoagricoltura.it/content/download/3069/23052/version/4/file/elenco_agritur.csv","Sheet1.A2") This will get the CSV from the internet and import the second row in my document. It does not work with any of the versions of Libreoffice I tried (4.1, 4.2 and 4.4).
Can confirm that it doesn't work. It has never worked so it is not a regression (tested with 3.5.0). AOO might have implemented it on their own. Thus it can be copied from AOO. Setting to enhancement request. Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+ Build ID: 698b344fdf42cc9738d5e91cd27876ce1ff39daf TinderBox: Win-x86@39, Branch:master, Time: 2015-06-10_02:24:19 Locale: fi-FI (fi_FI) Ubuntu 15.04 64-bit LibreOffice 3.5.0rc3 Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
Now working in Version: 24.2.1.1 (X86_64) / LibreOffice Community Build ID: 359ef544e625d2ffbfced462ab37bd593ca85fa7 CPU threads: 16; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
(In reply to BogdanB from comment #2) > Now working in > Version: 24.2.1.1 (X86_64) / LibreOffice Community > Build ID: 359ef544e625d2ffbfced462ab37bd593ca85fa7 > CPU threads: 16; OS: Linux 6.5; UI render: default; VCL: gtk3 > Locale: ro-RO (ro_RO.UTF-8); UI: en-US > Calc: threaded How did you test? I uploaded a CSV to my server and I could not get the example to work. With a debug build I get this in the console: warn:ucb.ucp.webdav:4255:4255:ucb/source/ucp/webdav-curl/webdavcontent.cxx:4152: OPTIONS - SC_NOT_IMPLEMENTED or SC_METHOD_NOT_ALLOWED for URL <https://mysite/test.csv>, HTTP error: 405, ' OPTIONS => HTTP/1.1 405 Method Not Allowed' warn:unotools.misc:4255:4255:unotools/source/misc/mediadescriptor.cxx:418: url: 'https://mysite/test.csv' com.sun.star.ucb.CommandFailedException message: "at /home/user/libreoffice/ucbhelper/source/provider/cancelcommandexecution.cxx:58" Reason: com.sun.star.ucb.UnsupportedDataSinkException message: "at /home/user/libreoffice/ucb/source/ucp/webdav-curl/webdavcontent.cxx:2300" context: http_dav_ucp::Content warn:legacy.tools:4255:4255:sfx2/source/appl/appuno.cxx:454: invalid type for Stream
Sorry, was Not working. I get an error. Was a typo.