[Libreoffice-bugs] [Bug 145085] HYPERLINK() inserts inactive link info in second cell when part of array formula
https://bugs.documentfoundation.org/show_bug.cgi?id=145085 Eike Rathke changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | Status|NEW |ASSIGNED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145085] HYPERLINK() inserts inactive link info in second cell when part of array formula
https://bugs.documentfoundation.org/show_bug.cgi?id=145085 --- Comment #6 from Eike Rathke --- Thanks to Mike who tried. So, Excel also processes both array elements as usual (i.e. for the second formula produces URL "ac" and cell text "bc"), but for display only uses the cell text, not spilling the URL element, not even if two cells were selected (it just repeats the cell text in that case as if it was a one element array). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145085] HYPERLINK() inserts inactive link info in second cell when part of array formula
https://bugs.documentfoundation.org/show_bug.cgi?id=145085
--- Comment #5 from Eike Rathke ---
Also, same
=HYPERLINK("a";"b")
=HYPERLINK("a";"b")&"c"
what does Excel do if two cells in two rows are selected while entering the
formula and closing as array formula?
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145085] HYPERLINK() inserts inactive link info in second cell when part of array formula
https://bugs.documentfoundation.org/show_bug.cgi?id=145085
Eike Rathke 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 ---
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.
[Libreoffice-bugs] [Bug 145085] HYPERLINK() inserts inactive link info in second cell when part of array formula
https://bugs.documentfoundation.org/show_bug.cgi?id=145085 Xisco Faulí changed: What|Removed |Added CC||er...@redhat.com, ||xiscofa...@libreoffice.org --- Comment #3 from Xisco Faulí --- Hi Eike, I thought you might be interested in this issue -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145085] HYPERLINK() inserts inactive link info in second cell when part of array formula
https://bugs.documentfoundation.org/show_bug.cgi?id=145085 --- Comment #2 from Joshua Coppersmith --- (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.
[Libreoffice-bugs] [Bug 145085] HYPERLINK() inserts inactive link info in second cell when part of array formula
https://bugs.documentfoundation.org/show_bug.cgi?id=145085 Joshua Coppersmith changed: What|Removed |Added CC||joshua_coppersmith@hotmail. ||com --- Comment #1 from Joshua Coppersmith --- Created attachment 175680 --> https://bugs.documentfoundation.org/attachment.cgi?id=175680=edit 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. -- You are receiving this mail because: You are the assignee for the bug.
