https://bugs.documentfoundation.org/show_bug.cgi?id=89358
--- Comment #7 from Winfried Donkers <[email protected]> --- Extract from messages on the dev-mailinglist: [ erack: Something is hidden in the help for "Array Functions": | Using Array Formulas in LibreOfficeDev Calc You can also create a | "normal" formula in which the reference range, such as parameters, | indicate an array formula. The result is obtained from the | intersection of the reference range and the rows or columns in which | the formula is found. If there is no intersection or if the range at | the intersection covers several rows or columns, a #VALUE! error | message appears. The following example illustrates this concept: And then follows a description of how to create array formulas, which is exactly _not_ about intersections.. While the hint about the non-array "normal" formula mode is helpful there to outline the difference, the actual "what happens in an intersection and when and why ..." should (also?) be covered at a more prominent place ] [ kohei: FYI, this is also known as "implicit intersection" in Excel terminology. If you google the phrase "excel implicit intersection" you'll get quite a few hits along with some interesting narratives. ] -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
