Hi everyone,
I’ve been using LibreOffice Calc to manage a fairly large database for my gaming statistics, but I’ve run into a persistent issue where my custom Basic macros stop responding or return a “General Error” whenever I have other automation tools running in the background. It seems like the bridge between the UNO interface and my local system calls is getting interrupted, which is a real pain when I’m trying to log real-time data from my sessions.
I actually started looking into how different execution environments handle these kinds of background hooks after reading a guide at about optimizing script performance. I’ve been trying to see if the logic used for blox fruit scripts to maintain high-frequency data flow could be adapted to make my Calc sheets more resilient to system stutters. You can see the kind of rapid-fire script handling I’m talking about over at , but even with my “Experimental Features” enabled in LibreOffice, the spreadsheet just locks up if the external script tries to write more than 50 rows per second.
I’m also seeing a related issue where the “JRE” (Java Runtime Environment) throws a memory heap error if a background executor is active while I’m using the Base component. Has anyone else noticed if LibreOffice is particularly sensitive to third-party “executors” or script-heavy environments that hook into the same system memory? I’m trying to determine if I should be moving my data entry to a headless Python script or if there’s a specific “Expert Configuration” setting to increase the memory buffer for these types of external injections. Any advice on how to sandbox the office suite so it doesn’t get hung up by these external automation triggers would be a huge help!