Bug 121070 - calc's "concatenate" function is unable to catenate a range of cells with text
Summary: calc's "concatenate" function is unable to catenate a range of cells with text
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86 (IA32) Linux (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-10-31 02:21 UTC by marc
Modified: 2018-10-31 11:58 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
concatenate improvement (128.24 KB, image/png)
2018-10-31 02:22 UTC, marc 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description marc 2018-10-31 02:21:40 UTC 
Description:
calc's "concatenate" function is unable to catenate a range of cells with text

Steps to Reproduce:
1.see pic attached
2.
3.

Actual Results:
see pic attached

Expected Results:
catenate the darn range's contents.... :(


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
catenate the darn range's contents.... :(
Comment 1 marc 2018-10-31 02:22:50 UTC 
Created attachment 146182 [details]
concatenate improvement

catenate the darn range's contents.... :(
Comment 3 Regina Henschel 2018-10-31 11:58:35 UTC 
You use the wrong function for that purpose. =CONCAT(B4:B27) works fine.