<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - External content disabled for WEBSERVICE call"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144238#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - External content disabled for WEBSERVICE call"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144238">bug 144238</a>
from <span class="vcard"><a class="email" href="mailto:glalonde25@protonmail.com" title="Tandem25 <glalonde25@protonmail.com>"> <span class="fn">Tandem25</span></a>
</span></b>
<pre>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("<a href="https://maps.googleapis.com/maps/api/distancematrix/xml?origins">https://maps.googleapis.com/maps/api/distancematrix/xml?origins</a>="&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)</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>