[solved] ScInterpreter::GetString() with svDoubleRef type of argument

[Eike Rathke]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 819 bytes
Desc: not available
URL: <http://lists.freedesktop.org/archives/libreoffice/attachments/20150216/335ef5a9/attachment.sig>