https://bugs.documentfoundation.org/show_bug.cgi?id=145085
--- Comment #2 from Joshua Coppersmith <[email protected]> --- (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.
