Bug 168396 - Hyperlink() working outside of context
Summary: Hyperlink() working outside of context
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: ARM All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2025-09-13 16:32 UTC by G
Modified: 2026-01-25 14:11 UTC (History)
2 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 G 2025-09-13 16:32:52 UTC

    
Comment 1 G 2025-09-13 17:15:04 UTC
Hyperlink() working outside of context.

Correct =IF(1,HYPERLINK("T.txt","OK"),1+1)
Bug     =IF(0,HYPERLINK("T.txt","Bug"),1+1)

Correct, will try to open "T.txt"
Bug, will try to open "2", but 2 is outside of the Hyperlink() scope.
You could add any "text" after it, if is not an error, it will Try to make it work.
Just replace the "1+1" with any text, command or link.
At least it shows you what it will execute before you click.
Comment 2 raal 2025-09-17 16:24:26 UTC
Confirm Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 8ea8e254a3151f5390f3a10ff156fcaf8e7c5d5c
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)