Summary: | WEBSERVICE function to certain external URL results in #VALUE! error | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Aron Budea <aron.budea> |
Component: | framework | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | 79045_79045, erack, giuseppe.castagno, himajin100000 |
Priority: | medium | Keywords: | bibisected, bisected, regression |
Version: | 5.3.0.3 release | ||
Hardware: | All | ||
OS: | All | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=102499 https://bugs.documentfoundation.org/show_bug.cgi?id=108141 https://bugs.documentfoundation.org/show_bug.cgi?id=131516 https://bugs.documentfoundation.org/show_bug.cgi?id=144238 https://bugs.documentfoundation.org/show_bug.cgi?id=132003 |
||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 104742, 108827 | ||
Attachments: | Session log |
Description
Aron Budea
2021-09-03 01:19:30 UTC
Created attachment 174751 [details]
Session log
Console logs from a debug build.
Might be a timing problem of the requests issued or the web server not wanting to let have us access otherwise. Effectively we're getting a HTTP status code 403 Forbidden. Deep down at https://opengrok.libreoffice.org/xref/core/ucb/source/ucp/webdav-neon/webdavcontent.cxx?r=10d29c39#2235 the GET() call fails, or if retried already the getResourceOptions() call at https://opengrok.libreoffice.org/xref/core/ucb/source/ucp/webdav-neon/webdavcontent.cxx?r=10d29c39#2225 both with the 403. The latter for the OPTIONS() call at https://opengrok.libreoffice.org/xref/core/ucb/source/ucp/webdav-neon/webdavcontent.cxx?r=10d29c39#3928 It was successful twice when single stepping through that sequence in the debugger, which doesn't make things easier, so I believe it is some (too fast) timing problem and the server thinking bad of us thus denying with 403. Or we issue some request between that isn't on its access-control-allow-methods list, but it doesn't look like from the first glance (list with curl -i for that URL is GET, HEAD, POST, PUT, PATCH, DELETE, OPTIONS). On the other hand, using curl -I 'http://data.fixer.io/api/latest?access_key=74ba35e56db252bd4737c215d4b0bf62&base=&symbols=PLN' to issue a HEAD request I also get a 403 error. Which makes me believe the server has a broken implementation anyway. Nothing that could be solved at the Calc level and I'm not familiar with that code. Setting 'framework' component. Not even sure this is a bug, given the curl -I behaviour. Reproduced with sample formula in recent master build: Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: eef0c5d4d45ba35acfb6d8f7551fe565ca4badaa CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded |