=WEBSERVICE() neither updated automatically nor updated manually

User Support Calc
5

@dec0de Thanks for the test ODS.

Because of your info… I think I found this exact same issue mentioned back in March 2021:

Looks like @bearon + @mmeeks mentioned a few advanced config settings/options, but I don’t see any final update/solution mentioned in there.

A few other users were trying to:

Side Note: For future knowledge, I’m keeping my initial debugging + post below.

First, sorry missing out on informaion and for the formula not being correct, this is a working one in libre office:

Thanks!

Here’s the full formula with a little better formatting (hopefully that makes it easier to copy/paste):

  • =NUMBERVALUE(FILTERXML(WEBSERVICE("https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml"),"//*[local-name()='Cube' and @currency='" & "SEK" & "']/@rate"),".","'")

Okay, in LibreOffice 7.5.3, I get a:

  • ERR:540

and a popup saying:

  • Security Warning: Automatic update of external links has been disabled.

After enabling, the cell turns into:

  • 11.6255

In Collabora Online, if I:

  1. Open the ODS:
  • ERR:540

There is no popup, but… in the Status Bar, I see a:

  • “External content disabled: undefined”

If you instead:

  1. Create a new Spreadsheet.
  • Copy/Paste the formula into it.

The formula works.

If you Refresh the page though, back to Err:540.