Hyperlink inserted to text box lost when the document is saved in XLSX format.
Steps to Reproduce:
1. Create a new document in LibreOffice Calc.
2. Choose Insert → Text Box.
3. Create a text box and type text.
4. Select the text box and choose Insert → Hyperlink.
5. Type/select the destination.
6. Save the file as XLSX.
7. Reload the file.
The hyperlink doesn’t work.
The hyperlink should work after export.
User Profile Reset: No
Created attachment 151243 [details]
Screenshot of the original and exported document side by side in Calc.
Created attachment 151244 [details]
Example ODS file from Calc.
Created attachment 151245 [details]
The original file saved as XLSX.
Confirming on Windows 10 Home 64-bit en-US with
Version: 126.96.36.199 (x64)
Build ID: aecc05fe267cc68dde00352a451aa867b3b546ac
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
The Draw TextBox is exported to OOXML .xlsx, but there is no _rels or .rels relationships file for a hyperlink associated with the drawing1.xml generated for the Draw TextBox.
Working with Word 2016, a link added to the TextBox drawing1.xml, is recorded into the OOXML "drawings" subfolder "_rels" as drawing1.xml.rels
LO Calc then correctly reads the hyperlink Excel 2016 writes for the drawing object.
So, the OOXML/MS Calc 2007-2019 Export filter of a Draw TextBox in Calc does not seem to parse the hyperlink. And it is missing on round trip. Looks like Draw shapes do get the _rels handling , but not so the Draw TextBox.
Tünde Tóth committed a patch related to this issue.
It has been pushed to "master":
tdf#125173 fix hyperlink inserted to text box
It will be available in 6.3.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Verified with LO master and fileopen in MSO. Xls was OK.