Issue 117662 - Make Concatenate function accept an array as an argument
Summary: Make Concatenate function accept an array as an argument
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: version58
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-04-02 14:26 UTC by wkhan
Modified: 2013-10-25 10:31 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 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.