[Libreoffice-bugs] [Bug 144276] New: WEBSERVICE function to certain external URL results in #VALUE! error

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144276
           Summary: WEBSERVICE function to certain external URL results in
                    #VALUE! error
           Product: LibreOffice
           Version: 5.3.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: bibisected, bisected, regression
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: baron at caesar.elte.hu
                CC: erack at redhat.com, giuseppe.castagno at acca-esse.eu
            Blocks: 112071

Taking the sample function from bug 144238:
=WEBSERVICE("http://data.fixer.io/api/latest?access_key=74ba35e56db252bd4737c215d4b0bf62&base=&symbols=PLN")

This results in a #VALUE! error when entered in a cell in Calc, while opening
the link itself gives correct JSON:
http://data.fixer.io/api/latest?access_key=74ba35e56db252bd4737c215d4b0bf62&base=&symbols=PLN

Sample result:
{"success":true,"timestamp":1630625596,"base":"EUR","date":"2021-09-02","rates":{"PLN":4.51215}}

This is a regression from the following commit, bibisected using
ibisect-linux-64-5.3. It also looks like a reproducible case of bug 108141.
Adding CC: to Giuseppe Castagno.

https://cgit.freedesktop.org/libreoffice/core/commit/?id=16df731a30917a426df81d751a0bfd0ae5fcdd45
author          Giuseppe Castagno <giuseppe.castagno at acca-esse.eu>     
2016-09-12 20:59:09 +0200
committer       Giuseppe Castagno <giuseppe.castagno at acca-esse.eu>     
2016-10-11 06:06:12 +0000

"tdf#102499 (5): Deal with HTTP unofficial response status codes"

Eike, I see you commented on bug 108141, let me CC you here as well.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=112071
[Bug 112071] [META] Linked external data issues
-- 
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/20210903/d60ffded/attachment-0001.htm>