Bug 65136

Summary: FILESAVE, FILEOPEN: XLS, XLSX partial-cell hyperlink is reloaded as full-cell hyperlink
Product: LibreOffice Reporter: dg1727 <dg1727>
Component: filters and storageAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium    
Version: 3.6.6.2 release   
Hardware: All   
OS: All   
Whiteboard:
i915 platform: i915 features:

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 3.6.6.2.
Comment 1 dg1727 2013-06-02 18:02:29 UTC
The same problem occurs when saving & reloading an XLS (Excel 97/2000/XP/2003).

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.