Issue 117662

Summary: Make Concatenate function accept an array as an argument
Product: Calc Reporter: wkhan <wkhan10>
Component: uiAssignee: 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)

results in B1=cat

Desired Behavior
A1=cat      B1=CONCATENATE(A1:A3)

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.

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.