Bug 116336 - HYPERLINK() used in a cell with 'Wrap text automatically' links only for the first line.
Summary: HYPERLINK() used in a cell with 'Wrap text automatically' links only for the ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function Hyperlink-Calc
  Show dependency treegraph
 
Reported: 2018-03-10 14:15 UTC by Wolfgang Jäger
Modified: 2023-01-31 11:30 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Wolfgang Jäger 2018-03-10 14:15:06 UTC
Steps to reproduce:
In a virgin sheet with standard width for the first column set the attribute 'Wrap text automatically for A1. 
Enter the formula 
=HYPERLINK("https:documentfoundation.org";"Now a few words without a meaning.") into A1.
Optimal row height should wrap the displayed text in 4 lines. Only the first line ("Now a few") will provide the link.

Expected behaviour: The complete text returned by HYPERLINK allows to use the link.
Comment 1 m_a_riosv 2018-03-11 00:10:04 UTC
Works for me.
Version: 6.0.2.1 (x64)
Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: es-ES (es_ES); Calc:
Comment 2 Wolfgang Jäger 2018-03-11 02:30:10 UTC
(In reply to m.a.riosv from comment #1)
> Works for me.
> Version: 6.0.2.1 (x64)
> Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
> CPU threads: 4; OS: Windows 10.0; UI render: default; 
> Locale: es-ES (es_ES); Calc:

Does this mean you have the link also clickable in the second and susequent lines of the wrapped cell? Could you supply a file damonstrating this? 

I cannot easily believe that this depends on language settings. 

(Mine are English (UK) for UI and locale, changing languages for documents. (For Calc I often choose Esperanto.)
Comment 3 m_a_riosv 2018-03-11 13:58:17 UTC
Sorry you are right only the first line is clickable.
Version: 6.0.2.1 (x64)
Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: es-ES (es_ES); Calc:
Comment 4 QA Administrators 2019-10-28 03:29:34 UTC Comment hidden (obsolete)
Comment 5 Wolfgang Jäger 2019-10-28 22:29:33 UTC
Tested with V 6.3.3.2  
Behaviour unchanged.
Comment 6 QA Administrators 2021-10-28 04:14:51 UTC Comment hidden (obsolete)
Comment 7 Joshua Coppersmith 2021-12-02 21:23:48 UTC
Version: 7.2.2.2 / LibreOffice Community
Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Confirmed. Hyperlinking is only applied to the first line of wrapped text within a cell. There is no hyperlinking and no tool-tip for the link when hovering over lower lines of text.