Issue 38128 - Hyperlink function is not working in Array formulae
Summary: Hyperlink function is not working in Array formulae
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.0
Hardware: PC Windows 2000
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-11-30 09:17 UTC by crissly
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Snapshots of spreadsheets (88.46 KB, application/x-compressed)
2004-11-30 09:18 UTC, crissly
no flags Details
Presentation showing work flow (520.50 KB, application/
2004-11-30 10:45 UTC, crissly
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description crissly 2004-11-30 09:17:19 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
("");0)} through "Insert/Function/Logical/If/...." 
with 'array' option selected.  
NOTE: instead of normal option for TRUE condition, we have inserted a HYPERLINK 
- => 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)
Comment 1 crissly 2004-11-30 09:18:34 UTC
Created attachment 19903 [details]
Snapshots of spreadsheets
Comment 2 john.marmion 2004-11-30 10:14:08 UTC
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.
Comment 3 crissly 2004-11-30 10:43:57 UTC
The attached presentation may help you in recreating it.  Thank you
Comment 4 crissly 2004-11-30 10:45:45 UTC
Created attachment 19906 [details]
Presentation showing work flow
Comment 5 john.marmion 2004-11-30 16:07:27 UTC
ok - I can see it now :) .
Comment 6 john.marmion 2004-11-30 16:08:01 UTC
Comment 7 john.marmion 2004-12-08 16:02:33 UTC
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. 
Comment 8 Unknown 2010-10-23 06:50:07 UTC
Created attachment 72357
Comment 9 misbirdcemu 2010-11-10 17:16:12 UTC
Created attachment 73430
Comment 10 Rob Weir 2013-07-30 02:24:27 UTC
Reset assignee on issues not touched by assignee in more than 2000 days.