https://bugs.documentfoundation.org/show_bug.cgi?id=145085
Bug ID: 145085
Summary: HYPERLINK() inserts inactive link info in second cell
when part of array formula
Product: LibreOffice
Version: 7.2.1.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 LO Calc function HYPERLINK is used within a cell that is treated as an
array formula (Ctrl+Shift+Enter) the text to display shows up in the cell as
expected but the text of the Url shows up in the cell below as part of a
two-cell array. The lower cell text does not respond to Ctrl+Click and does not
show a tool tip popup about Ctrl+Click.
Steps to Reproduce:
1.Type =HYPERLINK("#A1","Click me") into the input line (address bar)
2.Press Ctrl+Shift+Enter
Actual Results:
Click me
#A1
in two different cells auto-fixed as a two-cell array formula
Expected Results:
Click me
alone with no spill to the lower cell
Reproducible: Always
User Profile Reset: No
Additional Info:
1. Any information already in the lower cell before performing the steps above
will be deleted and replaced with no prompt or warning.
2. This is not a minor inconvenience when creating hyperlinked reports that
aggregate data using array formulas since it then requires significant
reformatting to hide alternating rows, which cannot be done automatically
without macro intervention, and is undone by any row height adjustment.
--
You are receiving this mail because:
You are the assignee for the bug.
