Bug 162908 - External links are lost after saving file in XLSX
Summary: External links are lost after saving file in XLSX
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.0.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-External-Datalink
  Show dependency tree / graph
 
Reported: 2024-09-10 20:09 UTC by arnouxguillaume54@hotmail.fr
Modified: 2024-09-24 13:21 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
link in ods version (12.70 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-09-13 17:16 UTC, arnouxguillaume54@hotmail.fr 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description arnouxguillaume54@hotmail.fr 2024-09-10 20:09:58 UTC 
Description:
Hi,
as the subject https://ask.libreoffice.org/t/link-to-external-data-is-lost-after-file-close/55872 2,
i notice that the external links (to another sheet, local or online) are lost after saving and reopening.
this behavior only occurs on xlsx files. saving links works on ods.

Steps to Reproduce:
1.Create a new Calc document
2.Insert external data from URL (local or http)
3.Save file in XLSX

Actual Results:
External links are lost after reopening the file, section is empty

Expected Results:
External links should be conserverd


Reproducible: Always


User Profile Reset: No

Additional Info:

Version: 24.8.0.3 (X86_64) / LibreOffice Community
Build ID: 480(Build:3)
CPU threads: 12; OS: Linux 6.10; UI render: default; VCL: kf6 (cairo+wayland)
Locale: fr-FR (C.UTF-8); UI: en-US
24.8.0-3
Calc: threaded
Comment 1 m_a_riosv 2024-09-10 22:28:52 UTC 
Please attach a sample file, in ODS format to test saving as XLSX.
Comment 2 arnouxguillaume54@hotmail.fr 2024-09-13 17:16:25 UTC 
Created attachment 196431 [details]
link in ods version
Comment 3 arnouxguillaume54@hotmail.fr 2024-09-13 17:16:52 UTC 
i confirm that links are preserved in ods but not in xlsx after reopening
Comment 4 m_a_riosv 2024-09-13 23:20:40 UTC 
Reproducible

Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 22d3de16dc65b0708cf260205f6e94637f39859c
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

The option on Menu/Sheets/External links, for CSV was implemented with Ver 6.1.
Seems export to XLSX was never implemented. Maybe it is not compatible with XLSX.
https://bugs.documentfoundation.org/show_bug.cgi?id=114995
Comment 5 arnouxguillaume54@hotmail.fr 2024-09-24 07:31:51 UTC 
ok thanks. can opening this bug change something or should I look elsewhere? I would really like this feature to be implemented

regards
Comment 6 m_a_riosv 2024-09-24 13:21:53 UTC 
You can connect with formulas to a CSV as if it was an spreadsheet.

Open your file, open the CSV, copy the first cell in the CSV, past in the file, as link using Paste Special [Ctrl+Shift+V], copy the link into the cells that you need.