Bug 68815 - FEATURE REQUEST: concatenation of ranges of cells
Summary: FEATURE REQUEST: concatenation of ranges of cells
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
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:

Attachments
Add an attachment (proposed patch, testcase, etc.)

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