https://bugs.documentfoundation.org/show_bug.cgi?id=145085
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 Version|7.2.1.2 release |Inherited From OOo OS|Linux (All) |All Hardware|x86-64 (AMD64) |All Status|UNCONFIRMED |NEW --- Comment #4 from Eike Rathke <[email protected]> --- Much simpler reproducer than the attached document: =HYPERLINK("a";"b") entered as array formula results in row1 "b" and row2 "a". Problem is that HYPERLINK() actually returns an array with two elements, URL and cell text, which in array context is evaluated like any other array. We may have to distinguish if the result is final (to be displayed) or to be further evaluated. What does Excel do for this? Or an expression =HYPERLINK("a";"b")&"c" entered as array formula? -- You are receiving this mail because: You are the assignee for the bug.
