Created attachment 139056 [details] Example document made in LO Attached simple document contains a hyperlink to a cell on the other sheet, using Excel formula syntax. The target sheet is named after an IP address. When saving the document to XLSX format the last dot in the sheet name becomes an exclamation mark, effectively breaking the link. On resaving one more dot becomes an exclamation mark. To reproduce: 1, Create a spreadsheet with two sheets. Name the second "127.0.0.1". 2, Create a hyperlink on the first sheet. Select the Document type on the left. 3, In the Target in Document section, press the Target button, in the Target in Document window, select the sheet 127.0.0.1. It is unable to set an exact cell reference, so that needs to be added manually. 4, In the Target field add a cell reference manually, so that it becomes '127.0.0.1'!C1 - I use Excel formula syntax here, to emulate real Excel-made files. With Calc syntax there would be no problem. 5, Save as XLSX then reload. The target of the hyperlink becomes '127.0.0!1'!C1 This happens on: Version: 6.1.0.0.alpha0+ Build ID: dd758f54fa5ea1ecd3d793bcea999d771010ff00 CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk2; Locale: en-US (hu_HU.UTF-8); Calc: group threaded
Created attachment 139057 [details] The example file saved from current master
Created attachment 139058 [details] The xlsx file after reloading
Yep, inspecting the hyperlink from Insert - Hyperlink after saving as xlsx shows the problem. tools - options - calc - formula: syntax Calc A1 showed the same result. In 3.3 and 3.6 the target becomes '127!0.0.1'.C1 Arch Linux 64-bit Version: 6.1.0.0.alpha0+ Build ID: c6a23023150c164a19236139fa413d43006ce21c CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on February 11th 2018 Arch Linux 64-bit LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4 Arch Linux 64-bit Version 3.6.7.2 (Build ID: e183d5b)
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/37a3af2413f9407639157caef67d7d5168230e49%5E%21 tdf#114969 XLSX export: fix 'sheet.name.with.dot'!A1-like links 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: 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-2": https://git.libreoffice.org/core/+/5c0fa3265962373f36020f3ba8ddcdbc265e0acc%5E%21 tdf#114969 XLSX export: fix 'sheet.name.with.dot'!A1-like links It will be available in 6.2.3. 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.