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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144238
           Summary: External content disabled for WEBSERVICE call
           Product: LibreOffice
           Version: 7.1.5.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: lukaszciesluk at gmail.com

Description:
Using below script works fine at the first usage

=REGEX(WEBSERVICE("http://data.fixer.io/api/latest?access_key=74ba35e56db252bd4737c215d4b0bf62&base=&symbols=PLN"),"\d{1,2}[\,\.]{1}\d{1,5}")

but when spreadsheet is closed and opened once again I got error 540 - External
content disabled.

After changing a setting of 

Tool > Options > LibreOffice > Security > Macro Security > changed from "High"
(the default) to "Medium" (confirmation required before executing macros from
untrusted sources"

and reopening spreadsheet , it asks "Automatic update of external links has
been disabled". After clicking on "Allow updating", nothing is refreshed in the
cell using above formula as it gives the same error of 540.


Steps to Reproduce:
1.
=REGEX(WEBSERVICE("http://data.fixer.io/api/latest?access_key=74ba35e56db252bd4737c215d4b0bf62&base=&symbols=PLN"),"\d{1,2}[\,\.]{1}\d{1,5}")
2. Close spreadsheet and open it once again
3. Check if value is updated in the cell by above script

Actual Results:
Values is not updated in the cell by above script

Expected Results:
Values is updated in the cell by above script


Reproducible: Always


User Profile Reset: No



Additional Info:
Sometime ago I started using
=com.github.binnarywolf.libreofficegetrestplugin.get("http://data.fixer.io/api/latest?access_key=74ba35e56db252bd4737c215d4b0bf62&base=EUR&symbols=GBP"),
it used to work for a long time but I would say that starting from April/May
2021 it stopped working. The same thing applies to WEBSERVICE

-- 
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/20210901/35bd82d3/attachment.htm>