[Libreoffice-bugs] [Bug 114453] New: hyperlinks created by HYPERLINK function can not be clicked correctly

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=114453

            Bug ID: 114453
           Summary: hyperlinks created by HYPERLINK function can not be
                    clicked correctly
           Product: LibreOffice
           Version: unspecified
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: maybeonly at gmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171214/17df07b7/attachment.html>