https://bugs.documentfoundation.org/show_bug.cgi?id=145085
--- Comment #2 from Joshua Coppersmith <joshua_coppersm...@hotmail.com> ---
(In reply to Joshua Coppersmith from comment #1)
> Created attachment 175680 [details]
> Example ODS showing HYPERLINK array formula bug
>
> This attachment shows a "floating report" that suffers from significant
> complications because of the HYPERLINK behavior when used in an array
> formula.
Does not contain the following macro required to see operation:
Function SheetName(sheetIndex As Integer)
SheetName=ThisComponent.Sheets(sheetIndex).getName
End Function
Please quickly add this to the workbook macros with:
Tools:Macros:Edit Macros...
then in the IDE
Click on the workbook name (SimplePlannerBugReport.ods) then:
Tools:Organize Macros:Basic...
Click on the workbook name again then:
Click on New button
Type SheetName (literally that text)
Click on Ok button
Replace macro stub with function given above by marking then pasting, etc.
Click Save arrow in IDE
Exit IDE...
--
You are receiving this mail because:
You are the assignee for the bug.
