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: libreoffice-bugs@lists.freedesktop.org Reporter: joshua_coppersm...@hotmail.com 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.