https://bugs.documentfoundation.org/show_bug.cgi?id=146017
Bug ID: 146017
Summary: HYPERLINK instance dies once attempts link to #N/A
result
Product: LibreOffice
Version: 7.2.2.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When the HYPERLINK function calculates (has some nested function(s)) a
hyperlink to another cell and that calculation results in #N/A the hyperlink
breaks completely even if the calculation changes to a valid link due to
changes external to the HYPERLINK() cell. Recovery requires re-edit of cell
(F2,Space,Enter) or reload of the document. Recalculate/Hard recalculate do not
avert the issue [nor does adding a recalculation trigger such as &T(RAND()*0)].
Steps to Reproduce:
1. Insert into A1: =HYPERLINK(ADDRESS(B1,C1))
2. Insert into B1: 1
3. Insert into B2: 2
4. Recalculate (F9) as needed since using indirect reference.
5. Hyperlink works as expected, to B1
6. Now insert into B2: =MATCH(-1,{1},1) //Or other throw of #N/A
7. Hyperlink shows #N/A
Actual Results:
8. Ctrl-click on hyperlink acts as 'normal' Ctrl-click multi-select instead of
hyperlink
9. Hyperlink is unusable
10. Other hyperlinks in document continue to work
11. Reverting B2 to original (Ctrl-z) value will not reactivate hyperlink, nor
will any valid value
Expected Results:
Expectation would be for the HYPERLINK() function to recover from the #N/A once
B2 was reverted back to a valid argument for ADDRESS().
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Thanks to Villeroy for double-checking and creating the original spreadsheet
that pointed out this oddity.
--
You are receiving this mail because:
You are the assignee for the bug.
