If I try to insert an external data, after inserting the link the "Import Option" window not appears. I've done some tests and the just released Libreoffice 3.5.3RC1 still have that problem, while using Libreoffice 3.4.6 it imports perfectly.
Steps to reproduce:
1. open new spreadsheet, click 'A1'
2. Menu 'Insert > Link to External Data'
3. Insert "http://www.milanofinanza.it/quotazioni/dettaglio_quotazioni.asp?StockCodeRt=43dd&codiceStrumento=d23d&selettore=&refresh_cens" into the URL panel
Current behavior: nothing happens
Expected behavior: the Import Option windows should appear and than something should be shown in "Available tables/ranges"
Platform (if different from the browser):
Browser: Mozilla/5.0 (Windows NT 6.0; rv:14.0) Gecko/20120420 Firefox/14.0a1
Whatever version I use but 3.3.4, nothing happens.
The link you gave want to define several cookies: did you try with a website which does not that?
Best regards. JBF
(In reply to comment #1)
> Whatever version I use but 3.3.4, nothing happens.
> The link you gave want to define several cookies: did you try with a website
> which does not that?
> Best regards. JBF
Other links works good, but query links are more "simple". If you try that link with Libreoffice 3.4.6 using Windows or Linux, in both cases it works perfectly: appears the Import Option window, than the list of available tables to choose and the infos are correctly imported. Libreoffrice 3.5.2 and 3.5.3RC1 instead surely have problems with that link. If it's a cookies problem, it's a "restriction" introduced with the new 3.5.x versions. (As 3.5.0 and 3.5.1 versions are nomore available, I've not been able to test if that versions had that problem too or if it's a more recent "problem"). I've indicated that link because that's my primary source for such datas and if I try to insert a new external link source, passing from working perfectly to nothing working .. that means something happened in the meanwhile).
I've just installed the new Libreoffice 3.5.3RC2 and the problem is solved.
I've just tested the new libreoffice 3.5.4RC1 and the problem is back again.
I think i've the same probleme on Version 18.104.22.168 (Build ID: da8c1e6)
Step to reproduce :
1. Create simple calc document with random data; save on desktop
2. Create another calc document.
3. Menu Insert > Link to external data
4. In first field, browse to select the first calc document
5. Then nothing happen. No sheet to be selected in the list, Ok button grayed.
On MacOS 10.7
(In reply to comment #5)
> I think i've the same probleme on Version 22.214.171.124 (Build ID: da8c1e6)
> Step to reproduce :
> 1. Create simple calc document with random data; save on desktop
> 2. Create another calc document.
> 3. Menu Insert > Link to external data
> 4. In first field, browse to select the first calc document
> 5. Then nothing happen. No sheet to be selected in the list, Ok button
> On MacOS 10.7
To do that you can use: "Insert --> Sheet From File" (it's a clone of "Insert --> Sheet": they have the same choice window appearing, the unique difference is that it's marked "From file" instead of "New Sheet").
I've tested that solution on Windows and Linux versions, it works good, you'll see it works on MacOS too. Let me know.
Effectively the "Link to External Data" writing, "Enter the URL to the source document in the local file system or Internet here.", is not properly correct as using local hard disk documents it not works. It'd be better to write: "Enter the Internet URL to the source document here."
Created attachment 79780 [details]
Example dialog screenshots showing working query.
Nicola, I just tried the query provided in the description here under GNU/Linux with v126.96.36.199 (Build ID: 0eaa50a932c8f2199a615e1eb30f7ac74279539) without issue. I have attached some screenshots of the dialogs showing the data. I have no idea if what I am seeing is correct in terms of the data, but the process appears to work for me.
(In reply to comment #7)
> Created attachment 79780 [details]
> Example dialog screenshots showing working query.
> Nicola, I just tried the query provided in the description here under
> GNU/Linux with v188.8.131.52 (Build ID: 0eaa50a932c8f2199a615e1eb30f7ac74279539)
> without issue. I have attached some screenshots of the dialogs showing the
> data. I have no idea if what I am seeing is correct in terms of the data,
> but the process appears to work for me.
Hi Owen, thanks for screenshots.
That problem nomore affect all recent stable v4.* versions.
It happened that 3.* rc versions had that problem while the stable versions had no problems (so unusual).
For Libreoffice v4.* I've not checked if rc versions still continue to have that problem, I just checked stable released ones .. but I'll test next rc to check that error presence.
LO 184.108.40.206 beta is out. Could you give that a try?
Created attachment 79801 [details]
Hi James, I noticed the new 220.127.116.11 beta and immediately downloaded and installed it to test. I tried to add this link http://www.milanofinanza.it/quotazioni/dettaglio_quotazioni.asp?StockCodeRt=0ac5&selettore=&codiceStrumento=d23e&refresh_cens
As you can see from the screenshot, Libreoffice remains locked, "Not answering". unique solution: brutally kill the application.
Created attachment 79804 [details]
.. instead, as you can see from attached screenshots, that same link works perfectly using Libreoffice 4.0.3
Has the site / links provided in the original description and comment 11 been altered or changed recently? I mean the source site and not the links in this bug. I ask because when I look at the returned HTML code now, the data is no longer enclosed by a <table> element. There is one all-inclusive <table> element (tablehome) that covers the entire body of the page, but the data (the smaller table of statistics) is instead encapsulated by <div> elements. I suppose it is possible that this may cause a problem in this instance, as I indicate in my comment here: https://bugs.freedesktop.org/show_bug.cgi?id=54533#c2
An example of a link that returns a series of HTML <table> elements enclosing data (e.g., Asset Allocation) can be found in bug #63407:
This link does take a while to respond for me, but eventually returns under v18.104.22.168 with a list of tables that are subsequently inserted as expected. Under v22.214.171.124 however the initial External Data dialog does not respond with a list of tables.
Exactly what all this means for this particular bug I am uncertain. Is the HTML returned by the links in the description and comment 11 less-than-ideal? Does the data need to be (more) directly enclosed in a <table> element? Could Nicola or others confirm if my assessment of the links is correct? Nicola, could you also confirm that the returned HTML is what you would expect?
Hi Owen, I've to check if I still have an old saved copy of the page indicated in Comment11 .. I'll check it and let you know. Anyway, I've done some "homeworks": I don't think the structure of the page creates problems. I've just tried to import datas from link in Comment11, I've done a copy/paste of that link, and it worked perfectly using LO-4.0.4 (tested windows and linux versions) and LO-126.96.36.199 (tested windows and linux versions). The problems are if I pass to use the stable LO4.1.0 and the newer LO-188.8.131.52 (for both versions I've checked just the windows version).
For past versions as you can read from messages, the same link worked perfectly with stable versions but not with rc versions (and that not worried me really a lot as rc versions are development versions). Now I see that stable LO-4.1.0 has that problem too ..
I check if I've an old copy of that webpage to see if they changed something and let you know.
PS: now I'm using LO-184.108.40.206 and I've read your answers to bug #54533. If I try to import datas, as you suggested in Comment 2, .. nothing happens: the table structure remains empty. Following your test I tried to cut parts of my problematic link .. just bad news.
with Libreoffice 220.127.116.11 it worked good. I've just tested Libreoffice 18.104.22.168 and .. the same problem is back.
I have been corresponding with Nicola (reporter) about this problem and after testing thoroughly versions 22.214.171.124, 126.96.36.199, 188.8.131.52, and 184.108.40.206 under Crunchbang 11 linux DEB x86_64 build (by me) and the Windows build (by Nicola) it would appear the problem is resolved. We both managed to get the occasional erroneous result without any consistency in session or LO version e.g., no response or the "Text Import" dialog instead of the usual "Import Options" dialog. Therefore it is not clear whether these occasional problems are protocol, website, server, or LO related. All the above testing was done using the link provided in the description and comment #11.
I have now re-tested v220.127.116.11 and v18.104.22.168 (under both Ubuntu v10.04 x86_64 and Crunchbang 11 x86_64) using the link in comment #13 and in both instances it responds as expected i.e., data is inserted OK.
I think this bug can be RESOLVED as either FIXED or WORKSFORME. I will leave it for Nicola or QA/developer to perform this action.
As Owen reported, looking at recent versions of LO, this bug can be considered as fixed.
In this case WorksForMe seems a more accurate choice.
Thank you very much for all the tests done.
Best regards. JBF
(In reply to comment #13)
Using the indicated link it appears there is a regression in handling under v22.214.171.124.
(In reply to comment #16)
> I have been corresponding with Nicola (reporter) about this problem and
> after testing thoroughly versions 126.96.36.199, 188.8.131.52, 184.108.40.206, and 220.127.116.11
> under Crunchbang 11 linux DEB x86_64 build
Under GNU/Linux using these versions the link works as expected:
- v18.104.22.168 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a
- v22.214.171.124 Build ID: 185f2ce4dcc34af9bd97dec29e6d42c39557298f
- v126.96.36.199.alpha0+ Build ID: e379401618268ed7f7f5885a36b90e1f4f6cd4af TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-08-18_05:51:03
... but using v188.8.131.52 Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0 the link does not return with the expected confirmation or list of HTML tables. Status set to REOPENED. "Regression" keyword added to Whiteboard.
For me it works in LO 184.108.40.206.0+ (Build ID: c8964193051a9ef543a50c7d87c78da99f253fbd)
and in master.
Note: it works if, after having pasted the url into the url field, I hit the Enter key. Only pasting the url does nothing.
Best regards. JBF
(In reply to comment #20)
> Note: it works if, after having pasted the url into the url field, I hit the
> Enter key. Only pasting the url does nothing.
Yes, I have been pressing ENTER after pasting the link. It appears to have been a minor regression as now under GNU/Linux using:
- v220.127.116.11 Build ID: 958349dc3b25111dbca392fbc281a05559ef6848
- v18.104.22.168.alpha0+ Build ID: 652b807658a54cd2ccd04ebc6900d2cf1ce85015 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-09-05_01:32:46
... it is working again. Reading back over this bug this facility seems to often break early in each series and then get fixed at a later point. Status set back to RESOLVED as WORKSFORME. I think this is likely the same problem described in bug 57675. Thanks JBF for the v4.3.2 test.
Migrating Whiteboard tags to Keywords: (Regression)