I’ve written a few macros in Calc that work fine except for a delay of ~10 seconds as soffice.bin repeatedly attempts an internet connection and finally gives up. Is there a way to disable this behavior?
TIA for any help.
-----------------------------
Thank you for your comments/suggestions. Crash reports and Collect usage data had already been disabled, as had automatic updates.
The attempted connection is via https (port 443) to: “server-13-227-220-xx.ams54.r.cloudfront.net” where “xx” is a number that varies (e.g., could be “70” or “43” etc.).
My suspicion is that the cause may be a line of code that includes:
createUnoService(“com.sun.star.sheet.FunctionAccess”)
with its reference to star.sun.com (even though it’s backwards). Do you think this could be the case? And if so, might there be an alternative to relying on a “UnoService?”
A delay of an extra few seconds isn’t a matter of life and death, of course, but the majority of this type of work that I do is without an internet connection so the closer I can get to being completely stand-alone, the better.
Thanks again for your quick reply.
-----------------------------
To all who replied: your input is much appreciated!
As for the connection to a Dutch Amazon.com server, wouldn’t you know? They have their fingers in everything these days, don’t they?
In stepping through my code (F8), I found that the connection attempt is triggered at the command, “Activesheet.Paste”, as it pastes clipboard content that had been copied from a table on a Web page. It may be that I can first paste that content into a Wordpad document (force it to shed its HTML properties?), then copy and paste into the Calc sheet.
In any case, I think we can consider this closed. If the approach above doesn’t work, I can use the time to take a slug or two of my coffee before it gets cold.
Thanks again.