[Libreoffice-bugs] [Bug 129322] New: MacOS Calc Error on Hyperlink- File is not an absolute URL that can be passed to an external application to open it

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 129322
           Summary: MacOS Calc Error on Hyperlink- File is not an absolute
                    URL that can be passed to an external application to
                    open it
           Product: LibreOffice
           Version: 6.2.8.2 release
          Hardware: x86 (IA32)
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: guillermo_alv at hotmail.com

Description:
Example:
(MacOS) New Calc File (saved File as "Error-Hyperlink.xls")

on Cell A1 (or any other) input formula:
=HYPERLINK("X/PIC.JPG","PIC.JPG")

Error:
"file:///Users/a/Desktop/Tst-Hyperlink/X/PIC.JPG" is not an absolute URL that
can be passed to an external application to open it.

Important Data:
Error is on MacOs, tested on MacOS 10.15.2
LibreOffice Version 6.2.8.2
If you create the same file in Win X, it Does Work well
I have tested this error only on MacOS.

Steps to Reproduce:
1. MacOS computer
2. Create Calc File (in this case only tested as .xls file"
3. insert formula: '=HYPERLINK("X/PIC.JPG","PIC.JPG")'
4. Command+Click on formula to follow Hyperlink

Actual Results:
"file:///Users/a/Desktop/Tst-Hyperlink/X/PIC.JPG" is not an absolute URL that
can be passed to an external application to open it.

Expected Results:
Open File. If you create a file called "Pic.JPG" inside a sub-folder "X", it
should open it. 

The same formula Works in Windows X, in MacOS it does not.


Reproducible: Always


User Profile Reset: Yes



Additional Info:

The only comment that I found is by Mike Kaganski 

Exactly because of the localhost issue. So no, we cannot ignore the localhost
issue.

file:///volume/my documents/testfile.txt is a bad URL for Windows: Windows
doesn't have a root (unlike Unix-like systems), so nothing like path /volume/my
documents/testfile.txt (starting from the forward-slash). Initially, the URL
looks correct: file://localhost/volume/my documents/testfile.txt - which should
convert to UNC path \\localhost\volume\my documents/testfile.txt, which refers
to a network share attached to your box, but since the localhost part gets
stripped away, it ends up in that invalid thing.

On the other hand, file:///c:/volume/my documents/testfile.txt gives correct
path, and isn't affected by the bug.

Can be found in
https://ask.libreoffice.org/en/question/203841/hyperlink-in-spreadsheet-works-in-excel-fails-in-libreoffice/

-- 
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/20191211/4c185aba/attachment.htm>