It would be helpful if any argument to the CONCATENATE function could be a range of cells instead of a single cell or string.
EG CONCATENATE(A1,B2," range ",C3:C10," end of range")
Hi all4bus, thanks for reporting.
Seems an useful function.
Changed the importance to enhancement.
Changed OS to all
Please in the future avoid to set the status in your reported bugs to NEW, the right way is someone else doing it.
Hi Winfried, by chance I found this old bug (last edited 2013) regarding the CONCATENATE function. Since I know that you worked on this function in recent years, you probably can tell whether this bug is still valid. Thanks.
Currently, CONCATENATE does not support ranges.
However, CONCAT does (as well as TEXTJOIN), so this enhancement request seems somewhat unnecessary.
Both CONCAT and TEXTJOIN have been added to Calc for Excel-interoperability.
CONCATENATE is defined in ODFF1.2, where the argument(s) are described as one or more text arguments.
I suppose this enhancement request has been granted with the inclusion of CONCAT and TEXTJOIN.