https://bugs.documentfoundation.org/show_bug.cgi?id=105907
Bug ID: 105907
Summary: reading html data from internet site working in 5.2
doesn't work in 5.3
Product: LibreOffice
Version: 5.3.0.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: paolo_debort...@yahoo.com
Description:
I had a calc sheet which downloaded data from internet site (stock prices) and
inserted them in cells to make simple calculations. Data were automatically
updated every 240 seconds. When I update LO from 5.2 to 5.3, I opened the
sheet and updated data a few times. The second time I opened the same sheet,
the data were no more downloaded (or the software just downloded the first
lines), cells were empty and connections (results) showed error messages: !RIF.
When I reinstalled LO 5.2 and opened the sheet again, I had the same error
messages with empty cells. The rebuildt the sheet again in LO 5.2 and it
worked properly again.
In the meanwhile I have tried to rebuild the sheet with LO 5.3 inserting the
links to internet page. It downloaded the data correctly the first time, maybe
a second time, but then it left the cells empty and showed the error messages.
Steps to Reproduce:
1. prepare a sheet with LO 5.2 or older version. go to the menu sheet -> link
to external data.
2. insert the urls (one url per time:
http://www.borsaitaliana.it/borsa/azioni/scheda/NL0010877643.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/IT0001479374.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/IT0001479374.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/IT0001063210.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/IT0004776628.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/IT0001031084.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/NL0011585146.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/IT0005218380.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/IT0000062957.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/IT0005239360.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/IT0003828271.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/IT0003132476.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/IT0003128367.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/IT0001233417.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/IT0001250932.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/IT0004810054.html?lang=it
http://www.borsaitaliana.it/borsa/azioni/scheda/IT0004818297.html?lang=it
for each link use at least 3 lines and choose html4 and update
automatically every 240 seconds. save the sheet and close the application.
3. open the same sheet with LO 5.3 then answer 'yes' when it asks whether to
update the data. wait about 10 - 15 minutes in order to update data
automatically 2 or 3 times.
4. close application. re-open the sheet with LO 5.3. close application
without saving.
5. re-open the sheet again with a previous version of LO; in my case the
links were still not working.
Actual Results:
cells remain empty; data are not downloaded and calculations give errors.
Expected Results:
the sheet should update data correctly automatically and execute correctly
calculations.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:51.0) Gecko/20100101
Firefox/51.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
