Description: Hyperlinks created by HYPERLINK function can not be clicked correctly when the cell is not edited after open an "XLSX" file. Steps to Reproduce: 1. Create a new calc file 2. Put the following function in any cell =HYPERLINK("http://www.google.com/", "GOOGLE") 3. It shows "GOOGLE" now, a browser will open "http://www.google.com/" after I click it with Ctrl key 4. Save it as an "XLSX" file and close it 5. Open this file Actual Results: 6. It shows "GOOGLE" in that cell but when you click it: "GOOGLE" is not an absolute URL that can be passed to an external application to open it. 7. Edit that cell, and it can be clicked correctly again Expected Results: 6'. It should open the link "http://www.google.com/" in the browser. Reproducible: Always User Profile Reset: No Additional Info: I'm running libreoffice 5.4.4.1 on fedora 27. Build ID: 5.4.4.1-1.fc27 Then I made a clean install on a windows 10. It reproduced. Libreoffice on Windows is version 5.4.3.2 (x64) It seems that it works fine if I save it as an "ODF" file. User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0
I can confirm with Version: 6.1.0.0.alpha0+ Build ID: aa28b54ab568fb7160095bb4a2fec338b1398b43 CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: x11; "GOOGLE" is not an absolute URL that can be passed to an external application to open it. regression *** This bug has been marked as a duplicate of bug 97805 ***