http://openoffice.org/bugzilla/show_bug.cgi?id=117662
Issue Type: ENHANCEMENT
Summary: Make Concatenate function accept an array as an
argument
Classification: Application
Product: Spreadsheet
Version: version58
Platform: PC
OS/Version: Windows 7
Status: UNCONFIRMED
Severity: enhancement
Priority: P3
Component: ui
AssignedTo: [email protected]
ReportedBy: [email protected]
QAContact: [email protected]
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
--
Configure bugmail: http://openoffice.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification
from Bugzilla. Please log into the website and enter your comments.
---------------------------------------------------------------------
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
