Bug 156608

Summary:	Cannot insert new external links into new tables. Only existing ones work
Product:	LibreOffice	Reporter:	beinvieh <beinvieh>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	beinvieh, buzea.bogdan, miguelangelrv
Priority:	medium
Version:	7.4.7.2 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	112071
Attachments:	the original file

Description beinvieh 2023-08-04 11:31:10 UTC

Description:
The link to external links via the menu table, external link, is no longer functioning.
I can edit existing links through the menu, change links to external data, but I am unable to create new links to new tables.
If I copy an existing link from a functioning table and try to create it in a new table, it still doesn't work. It only works in the existing table that I created with an older version of LibreOffice.
It doesn't work in either version 7.4.7 or version 7.5.5.2. I don't remember which version I used before, but it was not more than 4-6 months old

Steps to Reproduce:
1.Create a new table
2.insert an external link, in my case 'https://www.ariva.de/fortescue_metals_group-aktie/kurse/historische-kurse'
3.After that, there is no selection of areas, in my case, HTML_1-5." But in an existing Table it wirks to change from HTML_1 to 2.

Actual Results:
It should show the different HTML areas for selection

Expected Results:
nothing


Reproducible: Always


User Profile Reset: Yes

Additional Info:
file:///C:/Program%20Files/LibreOffice/help/de/text/scalc/01/04090000.html?System=WIN&DbPAR=CALC&HID=modules/scalc/ui/externaldata/dialog-action_area1#bm_id3150441

Comment 1 beinvieh 2023-08-04 11:33:05 UTC

Created attachment 188772 [details]
the original file

Comment 2 m_a_riosv 2023-08-05 00:35:53 UTC

Reproducible, even copying the address link from the attached file that works, doesn't work adding as new from External links. It works in Excel also, even takes a lot of time to get it.
Version: 7.6.0.1 (X86_64) / LibreOffice Community
Build ID: 776eaf34564cbf3f034a0ba1fd1d5c32ff9ccf1c
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 34387332173782498acd4998c7c665d04ebc3c7d
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded

Comment 3 BogdanB 2023-10-21 18:18:56 UTC

I changed the first version affected based on description.

Comment 4 cha_bay 2024-01-17 19:34:53 UTC

Issue still exists on version 7.6.4.1. I tried to download the website to my Download-folder and did the external link from there via file:///.... , which worked, but was a roundabout.
Since old external links via web are working and only creating of new ones (and changing old ones) via web are failing, something must block this creating procedure.

Comment 5 Andreas Säger 2024-05-06 13:54:54 UTC

Still exists in 24.2.2

Expected behaviour:
1. Sheet>"External Links..." (new menu label in 24.2)
2. Paste URL and hit Enter.
3. After a while, the list of source tables should be filled.

What happens:
After hitting the Enter key, nothing happens.

Suggestions:
1. Make the Enter key work again.
2. For the mouse aficionados, add a [Scan] button with same functionality.