Cannot import data using WebQuery. Steps to reproduce: 1. choose Insert->Link to external data... 2. write or copy-paste the url 3. nothing comes
Could you please attach a sample data file that worked with older LO versions? I am unable to get this working even in older LO releases. It seems that the file has to have a special format. The help page is not much helpful :-(
Could you please provide more detailed description how to reproduce this problem? Could you please paste here the URL that you tried? Could you please attach a document with a sample data? We are not able to move forward if we are not able to reproduce the problem. I am not able to reproduce the problem. The reported does not respond. Such bug could not block the 4.0.2 release => reducing the severity a bit.
If the query contains non RFC-compliant characters then this bug may be a duplicate of bug #42377, however without further information from the OP it is impossible to tell. Bug #49043 also contains a query that was having intermittent problems, although it is possible than appears to be resolved now.
Currently I use 4.0.3 and here it works. Steps to reproduce: 1. Open LibreOffice Calc 2. Open web browser and go to address http://www.x-rates.com/table/?from=EUR&amount=1.00 <-- an example address I searched 3. copy the URL above 4. Open Insert->Link to external data... 5. paste the URL to the first field 6. click to the pull down menu arrow once and just close it 7. wait for few moments and then "Import options" dialog box appears 8. additional dialog box appears and asks, which language I would use when importing tables. I chose "automatic" and then press "OK" 9. Then it shows available tables/ranges, which can be imported and I chose HTML_tables and press OK. You can choose also HTML_1, HTML_2 if there are several tables. 10. tables were imported If connection is lost or other problem (e.g. HTML_all did not succeed), then it announces "The link could not be updated", otherwise tables will be appear into Calc. I tried also with addresses: https://www.swedbank.ee/private/home/more/pricesrates/rates?language=ENG https://www.swedbank.ee/private/home/more/pricesrates/rates?language=EST ... all succeeded So - in version LibreOffice Version 4.0.3.3 (Build ID: 0eaa50a932c8f2199a615e1eb30f7ac74279539) it seems to work. I use 64-bit Ubuntu 12.04 LTS with all current updates + latest stable kernel (currently 3.9.3).
... 4. Open Insert->Link to external data... ... I meaned this in LibreOffice Calc - choose pull down menu "Insert" and from there the choice "Link to external data..." Just for clarification - I forgot to mention before and this environment does not allow to correct comments - so I provide new one.
As a result of comment #4 by the bug reporter I am changing the status to RESOLVED as FIXED. I just want to note that bug #49043 that I linked to above as appearing to be similar, also seemed to have some success with v4.0.3.3 (as here) but the problem appears to have come back in v4.1.0.0 beta. Hopefully that won't be the case here.
I can confirm, that with LibreOffice 4.2.5.2 (64-bit DEB) it works.