Bug 65136 - FILESAVE, FILEOPEN: XLS, XLSX partial-cell hyperlink is reloaded as full-cell hyperlink
Summary: FILESAVE, FILEOPEN: XLS, XLSX partial-cell hyperlink is reloaded as full-cell...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
(earliest affected) release
Hardware: All All
: low minor
Assignee: Not Assigned
: 92756 112325 (view as bug list)
Depends on:
Blocks: Hyperlink XLSX XLS XLSX-Hyperlink
  Show dependency treegraph
Reported: 2013-05-29 18:59 UTC by dg1727
Modified: 2019-04-04 15:19 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description dg1727 2013-05-29 18:59:54 UTC
1.  Open a new spreadsheet window (Ctrl-N).  
2.  In the first cell, type something like:  

Link to http://www.example.com

3.  Press Enter.  The text "http://www.example.com" will be highlighted as a hyperlink, but the text "Link to" won't be.  This is OK so far.  
4.  Save the file as ODS and as Excel 2007/2010 XLSX.  
5.  Close the spreadsheet window.  
6.  Reopen both files in LO Calc.  The ODS file will look the same as it did before it was saved.  The problem is that, in the XLSX file, the entire cell contents "Link to http://www.example.com", not just the URL, are now a hyperlink.  

Tested on Ubuntu Linux 32-bit with LibreOffice
Comment 1 dg1727 2013-06-02 18:02:29 UTC
The same problem occurs when saving & reloading an XLS (Excel 97/2000/XP/2003).
Comment 2 QA Administrators 2015-03-16 23:19:40 UTC Comment hidden (obsolete)
Comment 3 Jean-Baptiste Faure 2015-03-28 17:57:40 UTC
Reproducible with LibreOffice built at home under Ubuntu 14.10

Because the hyperlink is correct, only its formatting is wrong in xlsx format, set importance to low/minor.

Note: this bug report has not been confirmed independently before its status has been set to NEW. Please do not set your own bug report to new.

Best regards. JBF
Comment 4 tommy27 2016-04-16 07:27:57 UTC Comment hidden (obsolete)
Comment 5 Jean-Baptiste Faure 2016-05-06 16:07:13 UTC
Still reproducible in LO and master, both build at home under Ubuntu
16.04 x86-64.

Best regards. JBF
Comment 6 QA Administrators 2018-08-22 02:37:50 UTC Comment hidden (obsolete)
Comment 7 Jean-Baptiste Faure 2018-09-15 20:12:23 UTC
Still reproducible with LibreOffice built at home under Ubuntu 18.04

Best regards. JBF
Comment 8 Gabor Kelemen 2019-04-04 15:12:32 UTC
*** Bug 92756 has been marked as a duplicate of this bug. ***
Comment 9 Gabor Kelemen 2019-04-04 15:18:08 UTC
*** Bug 112325 has been marked as a duplicate of this bug. ***
Comment 10 Gabor Kelemen 2019-04-04 15:19:08 UTC
A sane sounding proposal from the duplicate bug #112325 :

It would be nice if a configuration option is introduced that allows to only add one hyper-link into a Cell for a specific spread sheet file.