Bug 50128

Summary: Formula "=HYPERLINK()" makes not executable links
Product: LibreOffice Reporter: ossi83
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: major CC: belsonan, Christian, thomas-libo
Priority: medium    
Version: 3.5.4 RC1   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=140886
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Some example links
Shows HYPERLINK() working

Description ossi83 2012-05-19 12:43:51 UTC 
Links made by formula =HYPERLINK() are unusable. When I'm clicking it, dialog box appears:

"For security reasons, the hyperlink cannot be executed.
The stated address will not be opened."

Link made by hyperlink creator works fine but creator is not good solution in some cases.
Problem appeared in LibreOffice 3.5.3 and it still exists in 3.5.4 RC.

I was trying to fix it in security settings but there is no feature to change it.
Comment 1 Christian 2012-08-29 15:03:04 UTC 
In 3.6.0.4 (Build ID: 932b512) generating a link with =HYPERLINK() to an external file produces executable links, generating a link to a local file doesn't. 

I would like to have HYPERLINK working with local references too. If this is a security issue it might be possible to give users a choice under options-security-...
Comment 2 belsonan 2012-09-12 08:08:49 UTC 
Loffice writer;

Link made by hyperlink creator works ok when full path is given;
i.e. /home/john/Documents/report01.

When ~/Documents/report01 is entered error box appears;

   "For security reasons, the hyperlink cannot be executed.
    The stated address will not be opened."
Comment 3 Thomas Arnhold 2013-10-16 19:03:22 UTC 
Created attachment 87755 [details]
Some example links
Comment 4 Thomas Arnhold 2013-10-16 19:06:02 UTC 
NOT reproducible on Windows 7 with:

Version: 4.1.2.3
Build ID: 40b2d7fde7e8d2d7bc5a449dc65df4d08a7dd38

and NOT reproducible on ArchLinux with:

Version: 4.1.2.3
Build ID: 4.1.2.3 Arch Linux build-1

Please reopen if it still applies to you. See the test document for some examples.
Comment 5 Thomas Arnhold 2013-10-16 19:06:31 UTC 
To open the links: SHIFT + click on the link.
Comment 6 Thomas Arnhold 2013-10-16 19:07:05 UTC 
I meant CTRL, sorry.
Comment 7 mhonline 2021-03-12 14:19:56 UTC 
that function is not working
No .exe can be started 
only docs/files by using the system-settings to interpret the file-extension (like *.doc etc)

martin
Comment 8 Michael Warner 2021-04-01 16:07:45 UTC 
In the example links file, only the TEST2 link to file://C:/Users/ works as a hyperlink, the others are plain text.

At that, neither the cell nor the formula bar shows the full link for TEST2. It just shows the "file://" portion but not the "C:/Users/" portion. The full link for TEST2 does appear in the tooltip, however. 

This is reproduced in:
Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 9 Michael Warner 2021-04-01 16:15:49 UTC 
Created attachment 170902 [details]
Shows HYPERLINK() working
Comment 10 Mike Kaganski 2021-06-29 20:35:05 UTC 
Please do not reopen this old bug. The new behavior was introduced in v.6.1 (cve-2019-9847), and should be tracked in tdf#140886.