Issue 117662

Summary:	Make Concatenate function accept an array as an argument
Product:	Calc	Reporter:	wkhan <wkhan10>
Component:	ui	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Normal
Priority:	P3	CC:	elish, issues
Version:	version58
Target Milestone:	---
Hardware:	PC
OS:	Windows 7
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description wkhan 2011-04-02 14:26:25 UTC

Have the concatenate function accept an array of various texts.  The result would be a concatentation of all the elements of the array.  When I tried this under the current build, the result was just the first element.  ie:

Current Behavior:
------------------
A1=cat      B1=CONCATENATE(A1:A3)
A2=dog
A3=mouse

results in B1=cat

Desired Behavior
-----------------
A1=cat      B1=CONCATENATE(A1:A3)
A2=dog
A3=mouse

results in B1=catdogmouse

I know I could use B1=CONCATENATE(A1;A2;A3), but if you have a long list, this could get cumbersome to type out all the arguments manually.

Thanks
Will

Comment 1 Oliver-Rainer Wittmann 2012-06-13 12:16:54 UTC

getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.

Comment 2 Edwin Sharp 2013-10-25 10:31:43 UTC

Group and name A1:A3 animals and then concatenate(animals) could also be nice.