Created attachment 152481 [details] Example file from Excel. Hyperlinks between documents do not works in Excel if the link contains an anchor at the end when the document was saved in Calc. 1. Create a document in Microsoft Excel 2016. 2. Create a hyperlink to a location in another document. 3. Save the file as XLSX. 4. Open and save the file in Calc. 5. Open the file in Excel. 6. The hyperlink works. 7. Close the file. 8. Open and save the file in Calc. 9. Open the file in Excel. Actual Results: The hyperlink doesn’t work. Expected Results: The hyperlink should be work. LibreOffice details: Version: 6.4.0.0.alpha0+ (x64) Build ID: 08f485c6e92bd56c8c26171316b842cd213a8a09 CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; Locale: hu-HU (hu_HU); UI-Language: en-US Calc: threaded
Created attachment 152482 [details] The original file saved by Calc.
Created attachment 152483 [details] The export file saved by Calc.
Created attachment 152484 [details] Screenshot of the problem in Excel.
Confirmed with: Version: 6.4.0.0.alpha0+ (x86) Build ID: 719f4a93e46a6b397356dbb605d2867639ca3942 CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2019-06-26_00:42:52 Locale: hu-HU (hu_HU); UI-Language: en-US Calc: CL
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/3cdc1b35b9d86bcfa1277e3e94925ae7b18b8fde%5E%21 tdf#126177 XLSX export: fix hyperlinks to documents It will be available in 6.4.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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Tünde Tóth committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/+/1d6277e77c33e8f9ad2c557ffe3250243f4a1ce4%5E%21 tdf#126177 XLSX export: fix hyperlinks to documents It will be available in 6.3.0.2. 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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.