I’m having the same issue; it just works fine when I created a new calc file and added the WEBSERVICE function to get some currency exchange data from an API. But if I closed the document and opened it again, I’m getting the same error "Err:540"
Also, I can see The status bar at the bottom indicates External content disabled .
If I created a new spreadsheet and added the function: =REGEX(WEBSERVICE("http://data.fixer.io/api/latest?access_key=XXXX&base=&symbols=USD"),"\d{1,2}[\,\.]{1}\d{1,5}")
It just works fine(1), but if I closed the file and opened it again it’s not working anymore(2). The problem is here(3).
There seems to be more complication to that. There are two settings needed for this.
The first is Calc’s General / ‘Update links when opening’ setting, which needs to be set to ‘Always (from trusted locations)’.
The config entry in loolkitconfig.xcu for this would be: <item oor:path="/org.openoffice.Office.Calc/Content/Update"><prop oor:name="Link" oor:op="fuse"><value>0</value></prop></item>
Then the other is setting the trusted location, which would go something like this (the setting in an LO desktop build is under general config / Security / Macro Security… / Trusted Sources / Trusted File Locations): <item oor:path="/org.openoffice.Office.Common/Security/Scripting"><prop oor:name="SecureURL" oor:op="fuse"><value><it>/here/is/some/location</it></value></prop></item>
The problem in this case is that the place where the document is stored in the jail is dynamic, eg. right now when I’m testing it, it’s /tmp/user/docs/P96dUx7eJivp05zA/ in this particular session, but that will change in the next one.
Hmm - I suspect that those paths are only for local macro files and not for remote internet URLs. It is possible that we’re not getting the dialog prompting the user to update links for some reason hmm; needs more research & code reading here.
thanks for clarifying the topic.
Do you have any idea, when the dialog for updating links might be fixed?
I have now upgraded to the latest version: collabora/code:22.05.10.8.1
and added <item oor:path="/org.openoffice.Office.Calc/Content/Update"><prop oor:name="Link" oor:op="fuse"><value>0</value></prop></item> as @bearon suggested.