Hi Winfried, On Monday, 2015-02-16 07:49:05 +0100, Winfried Donkers wrote:
I was pointed to a possible bug with Calc function LEFT() when entering an array for the text argument. In some cases it worked, in other it didn't. I created bug 89358 with an attachment showing the behaviour.Found it in http://docs.oasis-open.org/office/v1.2/cos01/OpenDocument-v1.2-cos01-part2.html#__RefHeading__1017984_715980110 Nothing wrong with the code, but help documentation lacks explanation for users.
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, I just don't know where. Eike -- LibreOffice Calc developer. Number formatter stricken i18n transpositionizer. GPG key "ID" 0x65632D3A - 2265 D7F3 A7B0 95CC 3918 630B 6A6C D5B7 6563 2D3A Better use 64-bit 0x6A6CD5B765632D3A here is why: https://evil32.com/ Care about Free Software, support the FSFE https://fsfe.org/support/?erack
Attachment:
pgp9JHgU7DNvD.pgp
Description: PGP signature