Apache OpenOffice (AOO) Bugzilla – Issue 38128
Hyperlink function is not working in Array formulae
Last modified: 2013-08-07 15:12:27 UTC
- Open a spreadsheet and enter numbers: 1, 0, 45 in cells B7 to B9 - Click on cell C7 and insert the following: {=IF(B7:B9>0;HYPERLINK ("http://www.example.org");0)} through "Insert/Function/Logical/If/...." with 'array' option selected. NOTE: instead of normal option for TRUE condition, we have inserted a HYPERLINK function - => cells C7 to C9 display the contents as shown in attachment: hyper_array1 - Also, clicking on link in cell C7 is not connected to the desired URL. - Now, if a similar array formula is inserted in cells F7 to F9 in the same way, but instead of HYPERLINK function we insert ABS function, the desired result is obtained. (attachment: hyper_array2)
Created attachment 19903 [details] Snapshots of spreadsheets
I can't re-create this using the Formula Input Line or Insert->Function. Can you attach a failing spreadsheet document which displays this. thanks.
The attached presentation may help you in recreating it. Thank you
Created attachment 19906 [details] Presentation showing work flow
ok - I can see it now :) .
accept
Lowering the priority on this. The problem is that the hyperlink() itself returns an array and thus it is not possible for the array formula to return an array of arrays. I don't see it as significant bug but will look later to see if there is a solution. It does not look like Excel handles this too well either.
Created attachment 72357
Created attachment 73430
Reset assignee on issues not touched by assignee in more than 2000 days.