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.
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.