I tried to read data from a Programmable Logic Controller via Internet Steps to reproduce: 1. open new spreadsheet, click 'A1' 2. Menu 'Insert > Link to External Data' 3. Insert "http://81.6.54.125/" into URL pane Expected: connection will be created, Some selections should be shown in "Available tables / ranges actual: nothing happens That will work with OOo1.1.4, Here I can Continue the test 11. Select "HTML_all" <OK> after a short moment, word "Start" will be inserted This also should work with LibO
This one blocks Bug 35041 - Improve 'Link to External Data' concerning CGI
Analyse: "http://81.6.54.125/" does not deliver a table or data in a database simmilary format! It is proably right that there is no "HTML_all" avaliable! It delivers only a HTML with a link to a JavaApplet that handles the full content. There is now way to extract data whitout knowhow about the programm running on the PLC. BUT! If you try: "http://www.unlogisch.ch/testscripts/test.csv" "http://www.unlogisch.ch/testscripts/readVal.exe" A similar problem shows wich is probably the same as in Bug 35041 Expectet behavior: 1. open new spreadsheet, click 'A1' 2. Menu 'Insert > Link to External Data' 3. Insert "http://www.unlogisch.ch/testscripts/test.csv" into URL pane Wait till the CSV Import function is OPEN 4. Configure the CSV Import as it is right for the Table 5. Press OK Expected: Import the CSV table into the Table. Or Jump back to select a specific cell to Import. actual: Jump back to the bervious dialog. OK Field is grayed out! No possibility to finish the Import! Summary: -HTML Table Import works -CSV, RAW Data Import is broken! -XLS NOT testet -ODF NOT testet -... NOT testet
Confirmed by Comment 2 @Kohei Please feel free to reassign if it's not your area!
It happens also with Suse 11.3, x86 and LibO 3.3.3
I can confirm this bug with latest Libreoffice 3.5.0 under Windows7 32bit
*** Bug 35041 has been marked as a duplicate of this bug. ***
This bug should is an enhancement request as not only has this facility never existed, the related Help page: https://help.libreoffice.org/Calc/Inserting_External_Data_in_Table_WebQuery ... explicitly states (and always has) that only "tables from HTML documents" are supported. Severity set to enhancement. Version set to Inherited From OOo as I have tested this under Ubuntu 10.04 x86_64 running v3.3.0.4 OOO330m19 Build: 6 and the facility does not cater for CSV files.
*** Bug 69320 has been marked as a duplicate of this bug. ***
Made summary more clear (I think). Best regards. JBF
Setting version back from "Inherited From OOo" to what it was prior (for bugs marked enhancement), for QA tracking purposes. My mistake. Apologies.
Adding self to CC if not already on
Still reproduced in LibreOffice5.0 beta1.
I'm running 5.0.3.2 Release. In order to support using LibreOffice Calc as a front-end to various web service data providers, the link to external data should accept raw XML, JSON and CSV without the requirement for those sources to have "named tables" or "named ranges". I recognize that I _can_ download the data to file, and then import it. This is far from ideal. As a user I want to be able to have two worksheets, one with data that is refreshed on-demand, without having to shell out or leave the application, and one that analyses that data via charts, formulae, conditional formatting or other spreadsheet tool. What's the likelihood this ends up on the roadmap? I understand this software is FOSS, and there's sooooo many other things to work on. Just trying to understand if it's even on a dev's radar...
It seems to be present in 6.0 beta1. I've tried to import CSV from FreeCAD to create project schedule but lack of csv-as-external-data limits usage here.
I'm surprised CSV imports don't work, but HTML ones do. The CSV format is far simpler than HTML. How did these two get prioritized?
Please, do not change the version number, it is intended to show the first version in which the bug has been observed. Best regards. JBF
Linking to CSV was implemented for bug 114995.
CSV is already supported, adapting Summary