Re: [libreoffice-users] Concatenate Function inCalc

On Tue, 2 Apr 2019 23:27:16 +0200
Regina Henschel <rb.henschel@t-online.de> wrote:

> Hi Michael,
>
> Michael H schrieb am 02-Apr-19 um 13:03:
> > CONCATENATE must either fail to accept ranges (with an error), or
> > accept them and provide the combination that acceptance suggests.
> > It is a bug that it accepts ranges, but returns something else.
> >   
>
> Because CONCATENATE expects a list of simple references, it performs
> an "implicit intersection", if instead of a simple reference a range
> is given.
> http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#ImpliedIntersection
>
> That is the reason, that sometimes you get the content of a single
> cell as result and sometimes an error.

That's a crazy idea that will lead to all kinds of obscure errors. Far
better to unconditionally return an error, IMHO.

> Kind regards
> Regina


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy