https://bugs.documentfoundation.org/show_bug.cgi?id=114969
Bug ID: 114969
Summary: FILESAVE XLSX: Link to document cell breaks on sheet
names with dots
Product: LibreOffice
Version: 6.1.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 139056
--> https://bugs.documentfoundation.org/attachment.cgi?id=139056&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
