Summary: | External content disabled for WEBSERVICE call | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Lukasz Ciesluk <lukaszciesluk> |
Component: | framework | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | normal | CC: | 79045_79045, aron.budea, glalonde25 |
Priority: | medium | ||
Version: | 7.1.5.2 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Windows (All) | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=131516 https://bugs.documentfoundation.org/show_bug.cgi?id=144276 https://bugs.documentfoundation.org/show_bug.cgi?id=132003 |
||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108827 |
Description
Lukasz Ciesluk
2021-09-01 11:13:42 UTC
For me the WEBSERVICE function doesn't work after entering it the first time, either (I removed the REGEX part to make sure that doesn't meddle with anything), it gives #VALUE! error instead of the expected JSON output. Since this bug report seems to be about something else, I opened bug 144276 on that. As mentioned in bug 144276 I believe that is a broken server implementation maybe tied with a timing problem. curl -i 'http://data.fixer.io/api/latest?access_key=74ba35e56db252bd4737c215d4b0bf62&base=&symbols=PLN' works and advertises access-control-allow-methods: GET, HEAD, POST, PUT, PATCH, DELETE, OPTIONS but already curl -I 'http://data.fixer.io/api/latest?access_key=74ba35e56db252bd4737c215d4b0bf62&base=&symbols=PLN' (doing a HEAD request) fails with 403 Forbidden status. 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) It has been a while, but this works perfectly from Excel if I paste the exact WEBSERVICE call into a cell there, so if the problem was the webserver, then Excel would get an error returned too, but it doesn't. Also, I use the function twice in a sheet. The first retrieves the USD vs ZAR rate, whereas the second retrieves the EUR vs ZAR rate. The first use works, the second doesn't. Even if I select the field and use <F9> to recalculate it, it doesn't. |