Bug 123645

Summary: FILESAVE XLSX Hyperlink in Chart goes missing
Product: LibreOffice Reporter: NISZ LibreOffice Team <libreoffice>
Component: CalcAssignee: Tünde Tóth <tundeth>
Status: RESOLVED FIXED    
Severity: normal CC: ilmari.lauhakangas, kelemeng, nemeth
Priority: medium Keywords: filter:xlsx
Version: Inherited From OOo   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=123647
Whiteboard: target:6.3.0
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 107733    
Attachments: The original file
The saved file.
creenshot of the original and exported document side by side in Calc

Description NISZ LibreOffice Team 2019-02-22 09:57:04 UTC
Description:
MSO xlsx Hyperlink on a Chart with data goes missing after saving it in LO and reopening

Steps to Reproduce:
    1. Create a xlsx in MSO.
    2. Type in some numbers on some cells→ select them→ Insert→ Chart.
    3. Select the Chart→ Insert→ Hyperlink→ Type/select the destination.
    4. Save the file and close it.
    5. Open the file in LO, everything is working fine.
    6. Save the file as xlsx and reload.
    7. Try and Ctrl-click on the Chart

Actual Results:
The hyperlink doesn’t work.

Expected Results:
The Hyperlink shoul work even after saving it in LO


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2019-02-22 09:57:30 UTC
Created attachment 149512 [details]
The original file
Comment 2 NISZ LibreOffice Team 2019-02-22 09:57:45 UTC
Created attachment 149513 [details]
The saved file.
Comment 3 NISZ LibreOffice Team 2019-02-22 09:58:32 UTC
Created attachment 149514 [details]
creenshot of the original and exported document side by side in Calc
Comment 4 Durgapriyanka 2019-02-22 18:29:45 UTC
Thank you for reporting the bug. I can confirm the bug present in

Version: 6.3.0.0.alpha0+
Build ID: b6b28931435e44aca92b8c0e1659f701e3ed1a87
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-01-30_06:57:04
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 5 Buovjaga 2019-03-05 19:51:02 UTC
Repro with 3.3.0 and several other versions.
Comment 6 Commit Notification 2019-04-17 08:18:32 UTC
tundet committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/+/dc091e7fd952b0530db8583247c2f910d627700a%5E%21

tdf#123645 XLSX export: fix hyperlink inserted to chart

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.