https://bugs.documentfoundation.org/show_bug.cgi?id=154950
Bug ID: 154950
Summary: Link.hypertext formula gives me a difference in the
information displayed is true and the actual link is
false
Product: LibreOffice
Version: 7.0.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: cedricq...@yahoo.fr
Description:
Formula is :
SIERREUR(LIEN.HYPERTEXTE("#data.A"&GRANDE.VALEUR(H:H;LIGNE()-2));"------")
The difference between the information displayed and the real link is made from
the second, here third line.
Steps to Reproduce:
1.Go to the Recherche tab
2.Type the words "direct adjoi" for a search in A1
3.The result is below a list with the links to the search results
Actual Results:
>From the third result line, the formula displays the correct result but the
link points to the coordinates of the next result link.
Expected Results:
>From the third result row, I expect the formula to point to the displayed link.
Reproducible: Always
User Profile Reset: No
Additional Info:
Link to Calc table :
https://www.swisstransfer.com/d/a997129c-709e-4c88-8c5f-a6721270b975
Link expires on 21/05/2023 @ 11:37
--
You are receiving this mail because:
You are the assignee for the bug.
