Bug 152146

Summary: HYPERTEXT() does not work with click or doubleclick.
Product: LibreOffice Reporter: MARINA-SODA <m5382607036>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INSUFFICIENTDATA    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: 7.2.3.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description MARINA-SODA 2022-11-20 23:01:22 UTC 
Description:
The formula "hypertext()" have many issue.

1.The first time if you wrote the formula is success.
2.The after of over the second time, your hyperlink will not work.

If you click or double click, you can't open the link and if you touch these cells, you can't see popup message. ---> Click to open hyperlink "c://.....".

Steps to Reproduce:
1.There is a list on another sheet. Write a function that creates a link from the contents of that list to a local folder.
2.For example, if you write in A2 of Sheet2, "Autofill" downwards.
3.Click or double click the A cells. 

Actual Results:
You cant open after A2.

Expected Results:
You can open after A2 too.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Once it happens, the cell will not allow you to open hyperlinks.

Similar to this but different. It has nothing to do with cell properties. Occurs in autofill even if it's not wrapped.
https://bugs.documentfoundation.org/show_bug.cgi?id=33951

I checked.

Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 5a1f41a0d3aab15c113651f2edc9d4137ae99063
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL threaded

Version: 7.2.3.2 (x64) / LibreOffice Community
Build ID: d166454616c1632304285822f9c83ce2e660fd92
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
Comment 1 MARINA-SODA 2022-11-20 23:04:20 UTC 
If you use Ctrl+ to open a hyperlink, this problem also occurs when you try to open a link while the next cell is selected, for example. Therefore, I set the link opening method to single click, but even autofill does not work.
Comment 2 m_a_riosv 2022-11-22 08:57:15 UTC 
Please attach a sample file showing the issue.
Comment 3 QA Administrators 2023-05-22 03:15:17 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2023-06-22 03:14:50 UTC 
Dear MARINA-SODA,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp