[Libreoffice-bugs] [Bug 139540] New: Function HYPERLINK used in formula creates hyperlink independent from conditional evaluation

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139540

            Bug ID: 139540
           Summary: Function HYPERLINK used in formula creates hyperlink
                    independent from conditional evaluation
           Product: LibreOffice
           Version: 6.4.7.2 release
          Hardware: x86-64 (AMD64)
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: uwe at franke-auer.de

Description:
Use Case:
Create a hyperlink using function HYPERLINK() based on the content of other
cells. If a reference cell contains a special value (or satisfies any other
condition like "textual content starts with 'http'") create an hyperlink,
otherwise show the content of another cell (or the content of the reference
cell itself).

Problem Description (see also attachment)
The use case is implement through formula =IF(C2=TRUE();HYPERLINK(D2;E2);F2).
While the IF statement correctly evaluates to FALSE in case of cell C2 is set
to FALSE  the formula creates a (pointless) hyperlink to value in cell F2. 


Steps to Reproduce:
1. Open a LibreOffice Calc file
2. Define a refence cell C2 allowing TRUE,FALSE 
3. Enter a valid URL address into cell D2 (e.g. "https://libreoffice.org")
4. Enter some Text describing the URL into E2 (e.g. "LibreOffice Website")
5. Enter some Text alternate Text into F2 (e.g. "False Evaluation of IF")
6. Add to A2 formula =IF(C2=TRUE();HYPERLINK(D2;E2);F2)
7. Set C2 to FALSE
8. Hover mouse over text in cell A2 


Actual Results:
When hovering mouse pointer over text in cell A2, which correctly shows the
text of FALSE evaluation, there is a (pointless) clickable hyperlink to that
text (which of course results in an error if being clicked using CTRL+Click).


Expected Results:
Cell A2 is expected to show the pure text from cell F2 without being clickable
(i.e. without being hyperlinked).



Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Tested on:

Version: 6.4.7.2, Build-ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU-Threads: 8; BS: Linux 5.3; UI-Render: GL; VCL: kf5; 
Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE,Calc: threaded

Version: 7.0.4.2 (x86), Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 1; OS: Windows 10.0 Build 19042; UI render: default; VCL: win
Locale: de-DE (en_DE); UI: en-US, Calc: threaded

Additional Information

The problem also appears if using IFS() function. From a users perspective the
issue looks like the hyperlink is being created during parsing phase (or
whatever it might be called) of the formula and not awaiting the evaluation of
conditional expression.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210111/3b0900ba/attachment.htm>