On Mon, 2015-02-16 at 21:20 +0100, Eike Rathke wrote: > 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.
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. Kohei _______________________________________________ LibreOffice mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice
