Bug 139540

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.