Created attachment 136172 [details]
Sample file, save in .xls or .xlsx format and re-open in Calc. Links are missing then
I created in LibreOffice calc a spreadsheet file that contains a list of web links. When I save the .ODS file in either .XLS or .XLSX format that a number of the Hyper-links are lost.
Created attachment 136212 [details]
Sample file saved as .xlsx by MS Excel 2013
Created attachment 136214 [details]
Sample file saved into .xlsx format by LibreOffice 5.4 on Ubuntu
Unfortunately I cannot reproduce this issue on my machine.
Could you please point in attached .xlsx after export, what is current result and what is expected?
It will be much easier for me to understand and fix this problem.
Created attachment 136216 [details]
.ODS file saved from LOO as .xls file, a lot of links are missing
Created attachment 136217 [details]
ODS file saved from LOO as .xlsx file, a lot of links are missing
All files created in Windows 7 Pro, 64-bit
Thank you for looking into this problem.
Please find attached the .xls and .xlsx files that I created with LOO in Windows 7 Pro, 64 bit.
I am using a 32 bit version of LOO.
Open up the MS files in LOO and you can see the problem.
Have you been able to reproduce the issue in Windows?
When will this problem be resolved?
Please progress this issue towards a solution.
Created attachment 137504 [details]
Screenshot of the problem
Arch Linux 64-bit, KDE Plasma 5
Build ID: 64024d7c18bd114eb9958cf80eea9129e09923bd
CPU threads: 8; OS: Linux 4.13; UI render: default; VCL: kde4;
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on November 3rd 2017
Problem already in
Arch Linux 64-bit
Part of this problem is that LO allows multiple links in a cell, but Excel does not and our export behavior follows that.
Thank you, Gabor.
It would be nice if a configuration option is introduced that allows to only add one hyper-link into a Cell for a specific spread sheet file.
At the moment I use MS Excel 2016 and find that in some aspects less flexible than LO calc.
*** This bug has been marked as a duplicate of bug 65136 ***