Welcome to the forum + thanks for posting!
In my environment where I am running the latest collabora docker containe
“Latest collabora” could mean lots of things!
Could you give us a little more info?
- Exact OS
- Exact Collabora version
and since you have it working in LO, then that info too:
=NUMBERVALUE(FILTERXML(WEBSERVICE(“https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml"),"//*[local-name()=‘Cube’ and @currency=‘” & SEK & “’]/@rate”),“.”,“'”)
- Could you attach a sample ODS document that’s working in LibreOffice?
I think that might make it easier to debug this.
(Right now, I’m getting
ERR:501 in LibreOffice 7.5.3. Maybe it’s a copy/paste + forum markdown issue.)
Can you explain a little what this equation + NUMBERVALUE + FILTERXML is trying to accomplish?
Maybe there’s an alternate way of tackling this problem too.
Side Note: Looking up Error Codes in LibreOffice Calc:
it also lists
540 External content disabled: Happens if a function that requires (re)loading of external sources is encountered and the user hasn’t confirmed reloading of external sources yet.
And I got a:
501 Invalid character Character in a formula is not valid.
which makes me think I may have copied/pasted something wrong.
It seems like in LibreOffice, you may need to “Enable” this after opening a document with such a formula inside:
Unsure how Collabora handles it (or if the Docker container makes this popup never appear).
Once we get a good sample ODS though, I think that’ll help figure this out though.