Excel will remove a link to a file containing spaces from an xlsx file.
Linux Mint Debian Edition
Windows 7 32 bit
LibreOfficeDev Build ID: 0a16c3dda4150008d9be6f24cbd15ac198d116d3
Steps to reproduce
1. Create a Calc Spreadsheet on a USB drive (FAT 32)
2. Insert a hyperlink by first opening the relevant menu (Ctrl-K) and go to "Document"
3. In "Path" select a file with spaces in its name on your USB drive
4. Save the file to "test.xlsx" (it has to be "Save" not "Save as" because the latter doesn't seem to convert absolute paths to relative ones)
5. Open test.xlsx using Excel 14.0.7149.5000 on Windows 7
Excel complains that the contents of the sheet are unreadable and offers to repair the document. After approving that, Excel reports that the hyperlink was removed.
Thanks in advance
I can not confirm with Version: 184.108.40.206.alpha1+
Build ID: 1a8e9dae32997bf199dbd192058fcd8f187ddc49
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-05-31_03:57:11
path: /tmp/BOOKMARK TEST.odt
Seems to be fixed, please test with newer version. Thank you
Thank you very much raal for looking into it.
I retried it with 5.1. Links with spaces inside still don't work for me in XLSX files.
I realized that the link is only removed by Excel after Calc converted the absolute path to a relative one.
This happens when I open an XLSX that contains a link with Calc, make a change such as editing some cell, and then save it.
After the path is now relative, the linked file won't open anymore in Calc and causes the described error message including the removal of the link when the XLSX is opened with Excel.
Thanks in advance,
(In reply to Matthias Braun from comment #2)
> I realized that the link is only removed by Excel after Calc converted the
> absolute path to a relative one.
> This happens when I open an XLSX that contains a link with Calc, make a
> change such as editing some cell, and then save it.
Could you attach test xlxs file?
Created attachment 116206 [details]
XLSX that links to a file with spaces
This file, when opened in Excel, causes a warning message and the link to be removed.
(In reply to Matthias Braun from comment #4)
> Created attachment 116206 [details]
> XLSX that links to a file with spaces
> This file, when opened in Excel, causes a warning message and the link to be
Confirmed in Excel.
Win 8.1 32-bit
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice
(5.1.6 or 5.2.3 https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the version of LibreOffice and
your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave
a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
Created attachment 150096 [details]
The example file saved by current Calc master
I can't reproduce the problem anymore in:
Build ID: 0faf4e5c2e98219b17e042594710f6872bf6a615
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win;
Locale: hu-HU (hu_HU); UI-Language: en-US
Also extended the original example file with a link to a custom file containing many spaces in its name, and it seems to generate the same link as Excel.