Issue 84516 - CONCATENATE an Array
Summary: CONCATENATE an Array
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Trivial with 8 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-12-13 06:24 UTC by claudiadzm
Modified: 2023-12-10 13:52 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

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

Note You need to log in before you can comment on or make changes to this issue.
Description claudiadzm 2007-12-13 06:24:28 UTC 
I'd like to have the possibility to write the CONCATENATE-function in this way:
=CONCATENATE(A1:C4) with an additional parameter to define if that would mean:
=CONCATENATE(A1;A2;A3;A4;B1;B2;B3;B4;C1;C2;C3;C4)
or:
=CONCATENATE(A1;B1;C1;A2;B2;C2;A3;B3;C3;A4;B4;C4)
greetings, Claudia
Comment 1 frank 2007-12-13 13:06:55 UTC 
one for the requirements team
Comment 2 gilkfir 2008-08-09 16:12:54 UTC 
Hey dear Claudia and fst,
I would be happy if this feature would be in Open Office.
It is an important one, and it does not present in excel
;-)

I think that CONCATENATE-function can be spite in to two functions; meaning
1. =CONCATENATE(A1:C4) is in effect CONCATENATE(A1;A2;A3;A4;B1;B2;B3;B4;C1;C2;C3;C4)
2. =CONCATENATE_TRANSPOSE(A1:C4) is in effect
=CONCATENATE(A1;B1;C1;A2;B2;C2;A3;B3;C3;A4;B4;C4)

What do you say?
Keep up the excellent work
Gil
Comment 3 wkhan 2009-04-13 03:48:52 UTC 
This is definitely needed.  I hope someone from the requirements team picks this
up.  I would add the following:

Specifically, if you could ALSO somehow add a common deliminator separating the
elements:  ie:  =Concatenate(A5:A60;",")
where A5...A60 could be strings:
cat
dog
mouse
lion
...
and the resulting cell would be a string:  "cat,dog,mouse,lion,..."
Comment 4 ndirons 2010-01-30 12:34:13 UTC 
Try this workaround.

Select cells, Format, Merge Cell, Yes [to move contents to first cell], Format,
Merge Cells, Select empty cells, Delete Cells [careful with the option here].

Hope that helps :)

Now how about a macro to make this a standard function?
Comment 5 oooforum (fr) 2023-12-10 13:52:04 UTC 
This function is TEXTJOIN and not available again.