Bug 164316 - Formula-generated hyperlink not clickable due to some formatting/styling
Summary: Formula-generated hyperlink not clickable due to some formatting/styling
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Hyperlink-Calc
  Show dependency tree / graph
 
Reported: 2024-12-13 11:55 UTC by Eyal Rozenberg
Modified: 2025-01-26 01:09 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Spreadsheet with unclickable link (9.40 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-12-13 11:55 UTC, Eyal Rozenberg 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Eyal Rozenberg 2024-12-13 11:55:30 UTC 
Created attachment 198099 [details]
Spreadsheet with unclickable link

Open the attached document. Ctrl+click'ing the link does't work. But - if you Clear Direct Formatting - it does work. Well, for me.

Reproduced with:

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 33b2abf2cd31ef75b9d8a17e021489159b4cfa3c
CPU threads: 4; OS: Linux 6.6; UI render: default; VCL: gtk3
Locale: en-IL (en_IL); UI: en-US
Calc: threaded

and with:

Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 4; OS: Linux 6.6; UI render: default; VCL: gtk3
Locale: en-IL (en_IL); UI: en-US
Calc: threaded

May be related to bug 163690.
Comment 1 Regina Henschel 2024-12-13 17:14:34 UTC 
The bug happens, when the cell option "Text Wrap" is enabled and the vertical alignment is set to "Align Bottom". Thus a workaround is to disable "Text Wrap" or to use "Align Top" or "Center Vertically".

It was OK in Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: b5c3a7502f7ff6ccf0f829c1f3a2ba50b8584c41
CPU threads: 32; OS: Windows 10.0 Build 26100; UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: threaded

It is broken in Version: 24.8.1.2 (X86_64) / LibreOffice Community
Build ID: 87fa9aec1a63e70835390b81c40bb8993f1d4ff6
CPU threads: 32; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: threaded
Comment 2 Saburo 2025-01-18 08:05:11 UTC 
I did bibisect, is it correct?
https://git.libreoffice.org/core/+/f91a411340ae204ce1e6997f22e0352a4c6a8355%5E%21

OK
Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: ee3885777aa7032db5a9b65deec9457448a91162
CPU threads: 12; OS: Windows 10.0 Build 26100; UI render: Skia/Vulkan; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL threaded

NG
Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002
CPU threads: 12; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: en-US
Calc: CL threaded
Comment 3 Aron Budea 2025-01-26 01:09:24 UTC 
Yes, that seems correct. Let's add commit details. Adding CC: to Noel Grandin.

https://cgit.freedesktop.org/libreoffice/core/commit/?id=f91a411340ae204ce1e6997f22e0352a4c6a8355
author		Noel Grandin <noelgrandin@gmail.com>	2024-05-23 15:09:52 +0200
committer	Noel Grandin <noel.grandin@collabora.co.uk>	2024-05-23 19:46:32 +0200

reduce cost of calc column height calculation