Description: Hello, I am using Calc to get data from some Websites, and use them for further calculations. Some links do not respond in a timely manner and the link timouts, providing no data. Then I go to related link using a web browser, and enter missing parts manually to my Calc sheet. I created a Basic macro to reload the links a few times, and it resolved some of them but not, as the reloads are also getting timeouts. As data is available to a web browser, I believe increasing the timeout value for the external data link updates will solve the Problem. Can this value be parametric? Steps to Reproduce: 1. Link calc to external data from https://quotes.wsj.com/CH/XSWX/DOKA/research-ratings 2. Select HTML_10 as the data table Actual Results: The link could not be updated. Expected Results: 5*2 table like the following (numbers to be changed) High 500 Median 425 Low 230 Average 410 Current Price 460.5 Reproducible: Sometimes User Profile Reset: No Additional Info: If the values are updated, it is by chance, try reloading and it will fail. The test can be repeated with the following examples too: https://quotes.wsj.com/CH/XSWX/FHZN/research-ratings https://quotes.wsj.com/CH/XSWX/GAM/research-ratings Discussed this subject in the forum: https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=99295 I wrote a macro to refresh the link when the values are not arrived, but even so it does not help. When I load the page from a web browser, it comes, but with a lag. So, increasing the timeout value allowed for the load would solve the problem, imho.
Please attach a sample file showing the issue.
Created attachment 154605 [details] SampleTestCase Hello, Attached a test case as requested. Regards,
[Automated Action] NeedInfo-To-Unconfirmed
Sorry I can't reproduce de issue, to do it I need to drop internet connection. I didn't find any option in the configuration to set up it. IMHO increase the time could affect e.g. loading files with no available source at the opening time. I think would be fine an option next to the time reload to keep actual data when the link no available.
You can change the UpdateTimeout value to something greater. Go to Tools - Options - Advanced - Expert Configuration and change the UpdateTimeout value. Closing as RESOLVED WONTFIX