The link path from an xlsx sheet to external data of another xlsx document gets always doubled after closing and reopening the xlsx document, even after having it saved correctly.
This problem does not exist in version 5.3.7 in Linux from the distro repos.
Version 6.0.7 and 6.1.3 i downloaded from Libreoffice site and installed it only in my home directory.
Steps to Reproduce:
1. Create a calc sheet with LibreOffice 6.0.7 with a link in it to some data of another calc sheet and save them both in xlsx.
2. The link to the external data in the first xlsx sheet is correct and everything works fine.
3. Close the xlsx document and reopen it, then the path to the external data ist doubled.
The external link after closing and reopening the document:
The external link before closing the document when everything is fine:
User Profile Reset: No
The calc sheet should keep the link like saved and not change it after closing the document.
Additional info: the Windows version of 6.0.7 keeps the links as they should be.
Additional info: Both calc sheets are in the same folder.
Thank you for reporting the bug.
it seems you're using an old version of LibreOffice.
Could you please try to reproduce it with the latest version of LibreOffice
from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Hi, this bug is still reproducible in the latest version 6.1.4
Bug is still valid in 6.1.5
For the company work Libreoffice is not usable anymore like this, because there is no way to save the calc sheet so other poeple can open it without problems. Please fix this. Thanks!
Sorry, for company work in mixed environments (Windows, Linux) and with external links in the calc sheets the version 6.x.x is unusable.
I'll go back to 5.x.x, everything works fine there.
Please attach a sample document, as this makes it easier for us to verify the bug.
(Please note that the attachment will be public, remove any sensitive information before attaching it.
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Created attachment 150146 [details]
Examples of xlsx documents with external links not working
This is a zip file containing 5 documents:
main-document.ods (working fine)
main-document-to-ods-source.xlsx (with doubled links after saving)
main-document-to-xlsx-source.xlsx (with doubled links after saving)
This bug is still valid in version 6.2.3
Still valid in 6.2.4
Is this really such a big deal? ...
Still stuck in the company with LO 547 because of this bug (also in v. 625) ...
Bug still present in LO 6.2.6 and 6.3.0 ...
Not sure if it makes any sense to report bugs here ...
However, bug still present in v6.3.2
So, still forced to use v5.4.7 because of this ...
Thanks for reporting the bug, I've tried with Version: 184.108.40.206.alpha1+
Build ID: eeae2032476e8c8645ab438fbb379f3151c8e472
CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: kf5;
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-11-13_06:44:02
the link is doubled
Created attachment 156115 [details]
test files odf and xlsx to show path error after closing and reopening
Problem continues in:
LibreOffice Version: 220.127.116.11
Build ID: a64200df03143b798afd1ec74a12ab50359878ed
I have tested with two sets of 2 spreadsheets each - all 4 files were created NEW and saved to /home/user/Documents
while the ODF files show no problems at all, the XL files always double the path so the reference to the correct path is obviously lost.
I am uploading both sets here. The ODF shows how the path reference should be and the excel file shows what happens to the path after closing and reopening the file.
test 1.odf / test 1.xlsx is the file with static data
test 2.odf / test 2.xlsx is the file that references test 1