Bug 109147 - FILESAVE XLSX: Replacing a hyperlink makes it invalid in Excel
Summary: FILESAVE XLSX: Replacing a hyperlink makes it invalid in Excel
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.0.1 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Hyperlink-Calc
  Show dependency treegraph
 
Reported: 2017-07-16 17:23 UTC by Gabor Kelemen (allotropia)
Modified: 2018-10-27 20:31 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file made in Excel 2013 (8.37 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-07-16 17:23 UTC, Gabor Kelemen (allotropia)
Details
Same file modified in 5.4 (5.80 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-07-16 17:26 UTC, Gabor Kelemen (allotropia)
Details
The two example files in Excel 2013 (72.66 KB, image/png)
2017-07-16 17:26 UTC, Gabor Kelemen (allotropia)
Details
Same file saved with Excel 2010 (8.28 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-07-17 10:47 UTC, Gabor Kelemen (allotropia)
Details
File from Excel 2010 modified by LO 5.4 (5.80 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-07-17 10:48 UTC, Gabor Kelemen (allotropia)
Details
The file made in Excel 2010 and its modified version in Excel 2013 (64.29 KB, image/png)
2017-07-17 10:50 UTC, Gabor Kelemen (allotropia)
Details
The file made in Excel 2013 and modified in current LO 6 master (5.43 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-09-18 07:04 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2017-07-16 17:23:45 UTC
Created attachment 134673 [details]
Example file made in Excel 2013

Attached file was created with Excel 2013 and contains a simple hyperlink in B1.

Opening it in LO 5.4RC1, replacing the hyperlink with another and saving it causes an 'unreadable content' warning when opened in Excel 2013.
Comment 1 Gabor Kelemen (allotropia) 2017-07-16 17:26:25 UTC
Created attachment 134674 [details]
Same file modified in 5.4
Comment 2 Gabor Kelemen (allotropia) 2017-07-16 17:26:43 UTC
Created attachment 134675 [details]
The two example files in Excel 2013
Comment 3 Xisco Faulí 2017-07-17 09:30:23 UTC Comment hidden (obsolete)
Comment 4 Gabor Kelemen (allotropia) 2017-07-17 10:47:47 UTC
Created attachment 134681 [details]
Same file saved with Excel 2010
Comment 5 Gabor Kelemen (allotropia) 2017-07-17 10:48:20 UTC
Created attachment 134682 [details]
File from Excel 2010 modified by LO 5.4
Comment 6 Gabor Kelemen (allotropia) 2017-07-17 10:50:09 UTC
Created attachment 134683 [details]
The file made in Excel 2010 and its modified version in Excel 2013

No obvious problem if I start with a file made in Excel 2010.
Seems to be similar to bug #109144 - and specific to Excel 2013.
Comment 7 Aron Budea 2017-09-17 04:08:33 UTC
(In reply to Gabor Kelemen from comment #6)
> No obvious problem if I start with a file made in Excel 2010.
> Seems to be similar to bug #109144 - and specific to Excel 2013.

Same result as in bug 109144:
I get no error in Excel 2013 after changing the link in the original spreadsheet using LO 6.0 daily build (2017-09-14_00:10:31, f70e0ec6b3c61a7c7caa469949b0ac8016c89854).
Comment 8 Xisco Faulí 2017-09-17 09:41:17 UTC Comment hidden (obsolete)
Comment 9 Gabor Kelemen (allotropia) 2017-09-18 07:02:44 UTC
Works fine with the current master build as of yesterday.
Thanks whoever did this :).
Comment 10 Gabor Kelemen (allotropia) 2017-09-18 07:04:56 UTC
Created attachment 136331 [details]
The file made in Excel 2013 and modified in current LO 6 master

For reference, this is the file saved from the current build. Seems to work fine in Excel 2013.