[Libreoffice-bugs] [Bug 144238] External content disabled for WEBSERVICE call

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144238

--- Comment #3 from Tandem25 <glalonde25 at protonmail.com> ---
I'm also getting Err:540 in cell and "External content disabled" on status bar
under Ubuntu 20.04 using LibreOffice Calc 7.2 from the formulas such as:

=WEBSERVICE("https://maps.googleapis.com/maps/api/distancematrix/xml?origins="&SUBSTITUTE(G3,"
","+")&"&destinations="&SUBSTITUTE(G4," ","+")&"+"&SUBSTITUTE(H4,"
","+")&"&mode=bicycling&key=myGoogleAPIkey")

Tried: 
a) Options > LibreOffice > Security > Macro Security > Trusted Sources >
Security Level (from High to Low)
b) Options > LibreOffice > Security > Macro Security > Trusted Sources >
Trusted File Locations
c) Options > LibreOffice Calc > General > Update links when opening (Always
selected)

The same spreadsheet with the above formula works perfectly under Windows!  In
fact, the spreadsheet and formulas also worked under Ubuntu in older version of
Calc (e.g. 5.x)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210904/8c0f17a0/attachment.htm>