Bug 68815

Summary:	FEATURE REQUEST: concatenation of ranges of cells
Product:	LibreOffice	Reporter:	all4bus
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	enhancement	CC:	miguelangelrv, winfrieddonkers
Priority:	medium
Version:	unspecified
Hardware:	Other
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

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