Bug 140229 - Link to External Data - Calc not responding/very slow
Summary: Link to External Data - Calc not responding/very slow
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.3 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:7.2.0 target:7.1.3
Keywords: bibisected, bisected, regression
Depends on:
Blocks:
 
Reported: 2021-02-07 09:30 UTC by pobihel676
Modified: 2021-04-12 14:35 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample to test (38.14 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-02-08 08:22 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description pobihel676 2021-02-07 09:30:42 UTC
Hi,
the function doesn't work properly since the new version, neither direct (in Calc) or indirect (via Basic).
Tested with 7.0.4 portable version and on other systems: works fine, so it's neither my code nor the website itself (as it happens on other websites too).
What happens is that it takes up to 2-3 minutes retrieving external content while Calc is not responding.
Also tried a clean reinstall, doesn't change anything

Can you have a look?

Thanks!

Version: 7.1.0.3 (x64) / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 12; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded
Comment 1 m_a_riosv 2021-02-07 10:22:46 UTC
Please attach a sample file to test.
Comment 2 pobihel676 2021-02-07 10:48:43 UTC
Hi,
as it's same behaviour in front- and backend, try to link the following URL: https://spielraum.co.at/de/magic/kaldheim/kaldheim-magic-the-gathering-einzelkarten.aspx (use element HTML_3), result set should habe names and prices in it.
Comment 3 QA Administrators 2021-02-08 03:49:13 UTC Comment hidden (obsolete)
Comment 4 m_a_riosv 2021-02-08 08:22:11 UTC
Created attachment 169572 [details]
Sample to test

Attached a sample to test the issue.
About 10 seconds 'allow update' with 6.4.7, also with 7.0.5
About 2 minutes with 7.1.1
About 2 minutes with 
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 44b914b1e2616ca8f70e896e653a46ca93610234
CPU threads: 4; OS: Windows 10.0 Build 21296; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
Comment 5 pobihel676 2021-02-08 14:27:48 UTC
Hmm.. so something between 7.0.5 and 7.1.X+ changed.
Do you know what and/or where I might tweak something from my side (if possible)?
Comment 6 m_a_riosv 2021-02-08 20:36:12 UTC
Please take a look in https://www.libreoffice.org/community/get-involved/
Comment 7 pobihel676 2021-02-09 20:31:44 UTC
I'm not sure if I understand you correctly.
Comment 8 pobihel676 2021-02-11 18:20:38 UTC
Can you please clarify if this is a bug and will be fixed in a future release and/or if I can change something on my side to get the old "speed" back?
Comment 9 raal 2021-04-01 19:56:17 UTC
This seems to have begun at the below commit.
Adding Cc: to Jan-Marek Glogowski ; Could you possibly take a look at this one?
Thanks
 71099e0ed300dd33d10d7f893523f685bb9debea is the first bad commit
commit 71099e0ed300dd33d10d7f893523f685bb9debea
Author: Jenkins Build User <tdf@pollux.tdf>
Date:   Tue Jun 2 03:17:25 2020 +0200

    source 07379e0eb27de0c16ae3838532310aa5aec4f20f

https://gerrit.libreoffice.org/c/core/+/91070
Comment 10 Jan-Marek Glogowski 2021-04-02 00:51:14 UTC
(In reply to raal from comment #9)
> 71099e0ed300dd33d10d7f893523f685bb9debea is the first bad commit
> commit 71099e0ed300dd33d10d7f893523f685bb9debea
> Author: Jenkins Build User <tdf@pollux.tdf>
> Date:   Tue Jun 2 03:17:25 2020 +0200
> 
>     source 07379e0eb27de0c16ae3838532310aa5aec4f20f

That commit updated LO to a new version of the neon library for SharePoint "fixes" (0.31.1). No code in LO was changed. That neon version triggers a bug with https and IIS servers, according to the upstream bug report. The update to 0.31.2 fixes this for me.

Upstream bug: https://github.com/notroj/neon/issues/11

Pending Gerrit patch: : https://gerrit.libreoffice.org/c/core/+/113495
Comment 11 Commit Notification 2021-04-02 17:36:00 UTC
Jan-Marek Glogowski committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/c974b23ff78dbe11a7b23f7317fdd096ab8cb282

tdf#140229 neon: update to release 0.31.2

It will be available in 7.2.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 12 Commit Notification 2021-04-02 19:19:53 UTC
Jan-Marek Glogowski committed a patch related to this issue.
It has been pushed to "libreoffice-7-1":

https://git.libreoffice.org/core/commit/436573acb76714ae9b0ccb8e664911b9696269f4

tdf#140229 neon: update to release 0.31.2

It will be available in 7.1.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 13 pobihel676 2021-04-12 14:35:04 UTC
Can confirm that the latest build (Used the latest build to test: Win-x86_64@tb77-TDF, 2021-04-12 09:35:20) works like before.