https://bugs.documentfoundation.org/show_bug.cgi?id=115192
Bug ID: 115192
Summary: FILESAVE XLSX Hyperlinks do not work from shapes after
saving the file as XLSX
Product: LibreOffice
Version: 6.0.0.0.beta1
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 139324
--> https://bugs.documentfoundation.org/attachment.cgi?id=139324&action=edit
Example file from Excel 2013
If we create a shape with Microsoft Excel 2010/2013/2016 and we establish a
link from the shape to a workbook, the link stops working after exporting the
file as XLSX in Calc. The main problem here is the path. The target we set in
the spreadsheet (Munka2!A1) gets transformed to a full path when the file is
saved as XLSX in LibreOffice Calc:
(file:///E:/Link-to-Workbook-from-Shapes/Link-To-Workbook_LO-60.xlsx#Munka2!A1).
This issue can only be reproduced with links from shapes, internal links from
simple cells work just fine.
Steps to reproduce:
1. Create a new spreadsheet with Microsoft Excel 2010/2013/2016.
2. Click on Insert-→Shapes-→select a shape (a rectangle) and insert it to the
workbook.
3. Fill the shape with a text and create a hyperlink from the text/shape to an
another sheet’s A1 cell.
4. Save the file as XLSX.
5. Open the file with LibreOffice Calc and test the link. (It will work, if you
press the ‘CTRL’ and then click)
6. “Save as” the file *.XLSX and then reload. The link stops working.
Actual results:
After we export the XLSX file the hyperlink stops working. The target
“Munka2!A1” was fine, but, because of the file path
(file:///E:/Link-to-Workbook-from-Shapes/Link-To-Workbook_LO-60.xlsx) which was
added to the hyperlink, the link did not work.
Expected results:
The internal links from shapes should work even after saving the file as XLSX
and reloading it, just like links from cells do.
Version: 6.0.0.0.beta1+
Build ID: 29228e83df009cf76ac819ed024527be1092f065
CPU threads: 4; OS: Windows 6.1; UI render: default;
TinderBox: Win-x86@42, Branch:libreoffice-6-0, Time: 2017-12-04_23:15:34
Locale: hu-HU (hu_HU); 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
