Description: Hyperlink to another sheet don't works in Excel. Tested LO Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a) and 7.3dev. Steps to Reproduce: 1.Insert hyperlink to other sheets (Insert > Hyperlink > document > Target in document > Sheet2 2. Save as xlsx 3.open in excel Actual Results: link doesn't works. Error message Reference is not valid. Expected Results: link works Reproducible: Always User Profile Reset: No Additional Info: When you compare files from LO and excel, you can see where is the difference: export from LO: <hyperlinks><hyperlink display="#Sheet2" location="Sheet2" ref="A1"/></hyperlinks> export from excel: <hyperlinks><hyperlink ref="A1" location="Sheet2!A1" display="Sheet2!A1"/></hyperlinks> parameter should be location="Sheet2!A1"
Created attachment 173522 [details] Example file with internal links pointing to other sheets
Created attachment 173523 [details] The example file saved as xlsx With yesterdays nightly: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 0fc020fb73c86a20608e8dff12af607e60327379 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: CL The links in this one surprisingly work fine in Calc.
Created attachment 173524 [details] The xlsx version of the example in Excel but Excel says "Invalid reference".
@Tünde maybe one for you?
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/3c3b9ad8886da916027f0fb940a2df822d63d4d7 tdf#143220 XLSX export: fix hyperlink to sheet target It will be available in 7.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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: d1f1f546b212ecd651146addeb328806bb270d5f CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded
Tünde Tóth committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/a5812749820d5118c3bb4297e5f785635c75f07a tdf#143220 XLSX export: fix hyperlink to sheet target It will be available in 7.2.1. 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.