Apache OpenOffice (AOO) Bugzilla – Issue 117662
Make Concatenate function accept an array as an argument
Last modified: 2013-10-25 10:31:43 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
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used.
Group and name A1:A3 animals and then concatenate(animals) could also be nice.