Bug 68815 - FEATURE REQUEST: concatenation of ranges of cells
Summary: FEATURE REQUEST: concatenation of ranges of cells
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Reported: 2013-09-01 13:36 UTC by all4bus
Modified: 2017-07-10 08:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description all4bus 2013-09-01 13:36:50 UTC
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")
Comment 1 m.a.riosv 2013-09-01 22:23:02 UTC
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.
Comment 2 Gerry 2017-07-09 10:12:06 UTC
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.
Comment 3 Winfried Donkers (retired) 2017-07-10 08:08:57 UTC
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.