Date: prev next · Thread: first prev next last
2019 Archives by date, by thread · List index


Howdy,

I believe that the difference is in where the function hails from:
CONCATENATE is defined in the ODF standard.
CONCAT comes by way of Excel support.

I think you have a point about how the system should respond when
erroneously using ranges for the ODF function (not supported) and could be
worth opening an issue.

Best wishes,

Drew

On Tue, Apr 2, 2019 at 10:31 AM Michael H <cmahte@gmail.com> wrote:

Why are we defending invalid output of a function?

When I send invalid data like range to a function, say ABS(c1:c4), I expect
it to return an error (#VALUE! comes up in linux).

In linux on LO 6.0.7, I'm getting the 2nd value in the range as a valid
output of the function CONCATENATE(C1:C4).  That is erroneous. broken.
should-not-happen.

This thread is about CONCATENATE being disfunctional in that it accepts
ranges, but does not act on them correctly. Please stop referring to CONCAT
as the reason that CONCATENATE is broken.

However, in regard to CONCAT, I see zero reason for the CONCATENATE
function to be separate from CONCAT.  CONCATENATE  should be replaced with
an alias or redirect to CONCAT. But thats not a bug, just poor design.

On Tue, Apr 2, 2019 at 9:13 AM Robert Großkopf <robert@familiegrosskopf.de

wrote:

Hi Michael,

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.

Have opened Calc and looking for fuction CONCATENATE. Help in the dialog
says: "Combines several text items into one."
Then looked for CONCAT. Help in the dialog says: "Combines several text
items into one, accepts cell ranges as arguments."

I don't see in the help CONCATENATE accepts cell ranges.

Regards

Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


--
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


--
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


-- 
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.