Bug 123811 - HYPERLINK Function includes everything written in the cell
Summary: HYPERLINK Function includes everything written in the cell
Status: CLOSED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2019-03-03 05:09 UTC by akkadaya
Modified: 2022-11-14 11:29 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshot of the actual cell and the formula (127.04 KB, image/png)
2019-03-03 05:13 UTC, akkadaya
Details
hyperlink demo (12.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-03-03 07:49 UTC, Oliver Brinzing
Details

Note You need to log in before you can comment on or make changes to this bug.
Description akkadaya 2019-03-03 05:09:56 UTC
Description:
when using HYPERLINK function within a text it includes all the cell content.


Steps to Reproduce:
1. choose any cell and start typing ="blah blah blah" & HYPERLINK("any link")
2. try to click on the link

Actual Results:
all the cell content will be considered a link

Expected Results:
only inside HYPERLINK function should be considered a link


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.2.0.3
Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU threads: 8; OS: Linux 4.20; UI render: default; VCL: gtk3; 
Flatpak
Locale: en-AU (en_AU.UTF-8); UI-Language: en-GB
Calc: threaded
Comment 1 akkadaya 2019-03-03 05:13:25 UTC
Created attachment 149687 [details]
screenshot of the actual cell and the formula

the actual cell with mouse hovering on it showing the link including the abcd text.

underneath it is the formula without quotes.
Comment 2 Oliver Brinzing 2019-03-03 07:49:16 UTC
Created attachment 149688 [details]
hyperlink demo
Comment 3 Oliver Brinzing 2019-03-03 07:49:56 UTC
already reproducible with AOO 4.1.5
Comment 4 QA Administrators 2021-09-04 04:01:40 UTC Comment hidden (obsolete)
Comment 5 Joshua Coppersmith 2021-10-12 01:24:44 UTC
Not certain this is a bug or just a limitation, possibly one worthy of a feature request. However, I confirmed the reported behavior in 7.1.6.2, specifically:

Version: 7.1.6.2 / LibreOffice Community
Build ID: 0e133318fcee89abacd6a7d077e292f1145735c3
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 6 Eike Rathke 2022-11-14 11:29:25 UTC
That is how HYPERLINK() was specified and also works in Excel. See also
https://www.openoffice.org/specs/calc/compatibility/HyperLinkFunction.sxw
Yes it's crap, blame Excel. But also, one can't make only part of a formula result clickable.
Wontfix.