Hi there,
I have a Spreadsheet that updates several sheets from external HTML sources every minute. When the update cycle takes place, the Calc UI freezes. Is there any way to do the update asynchronously so the UI doesn’t freeze?
Bug tdf#147448 fixed for 7.3.1.
(and please always state the LibreOffice version and platform you use, the freeze occurred only in 7.3.0).
Sorry about that. My version and OS are as below:
Version: 7.3.1.3 (x64) / LibreOffice Community
OS: Windows 10.0 Build 19044
Ah you mean the UI freezes during the update, but the update happens and does not freeze entirely and the suite is available after? No, no remedy for that.
That’s exactly what I mean. From a user perspective, that’s rather annoying. Is there any other way I can approach this kind of external data insert that won’t interrupt the flow? I was considering a Python based script running in a separate thread on a timer. Would something like that work or is the freezing going to happen anyways when the sheet needs to be updated?
Using a script you could obtain the data in a separate thread, which may be the significant amount of time spent, but writing to the document can happen only in the main thread and you’d need some async notification to trigger that once the data is available.
Maybe an asynchronous Add-In function as matrix returning a volatile variable result would be viable, see https://wiki.documentfoundation.org/Documentation/DevGuide/Spreadsheet_Documents#Spreadsheet_Add-Ins but that might be overkill.