[Libreoffice-bugs] [Bug 142979] New: UI Hyperlinks to cells of other sheets are not clickable if they are generated and there are many of them.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 142979
           Summary: UI Hyperlinks to cells of other sheets are not
                    clickable if they are generated and there are many of
                    them.
           Product: LibreOffice
           Version: 7.1.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: juan3 at yandex.com

Description:
Hyperlinks stop being clickable, when there are many of them. This is only
caused when they're created by a formula. This can be reproduced with
safe-mode. Im using german locale.

Steps to Reproduce:
1. Create a new calc document
2. Type "1" in A1 cell, and "drag it down" (generating new numbers) to around
200
3. Create a new table, (in German locale it's called "Tabelle2") do the same as
step 2, numbers may or not match
4. Go back to table 1 and on the B1 cell type the following formula
`=HYPERLINK("#Tabelle2!$A$"&VERGLEICH($A1;$Tabelle2.A:A;0);A1)`
5. This link should be clickable, it works if you ctrl-click it.
6. Drag it down for 5 or 8 numbers, it still works, all of the links are
clickable.
7. "Drag" it down to 200 and go beyond the numbers on column A.

Actual Results:
Links stop being clickable

Expected Results:
They should still allow themselves to be clicked


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.1.4.2 (x64) / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 8; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded

-- 
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/20210622/06c296a6/attachment.htm>