[Solved] CONCATENATE Problem

Discuss the spreadsheet application

[Solved] CONCATENATE Problem

Postby Scribe_05 » Mon May 04, 2020 7:52 am

The following formula to join the contents of 2 cell works fine in Libre Office Calc, but does not work in Open Office Calc.
=CONCATENATE(B2,".",C2)
Does anyone know why?
Last edited by Scribe_05 on Mon May 04, 2020 9:14 am, edited 1 time in total.
"Aut Vincere Aut Mori"
Apache OpenOffice 4.1.7
Windows 10
Scribe_05
 
Posts: 16
Joined: Fri Oct 23, 2015 3:14 am

Re: CONCATENATE Problem.

Postby erbsenzahl » Mon May 04, 2020 8:57 am

OO offline help reads:
CONCATENATE
Combines several text strings into one string.
Syntax
CONCATENATE("Text1"; ...; "Text30")
Text 1; Text 2; ... represent up to 30 text passages which are to be combined into one string.
Example
=CONCATENATE("Good ";"Morning ";"Mrs. ";"Doe") returns: Good Morning Mrs. Doe.
Use a semicolon instead of comma?
Notice: Also LO offline help demands the semicolon.

Probably there may be a difference in locale?

PS: Aut Vincere Aut Mori - isn't that a bit too harsh?
OpenOffice 4.1.8 on LinuxMint 19 or 20 Mate, rarely W7-64 pro and W10-64 pro; LibreOffice current versions 6 or 7
(author is no native speaker)
erbsenzahl
Volunteer
 
Posts: 165
Joined: Tue Apr 18, 2017 8:23 am
Location: Germany

Re: CONCATENATE Problem.

Postby Scribe_05 » Mon May 04, 2020 9:11 am

Thank you for your reply.
I thought I had tried that but I guess I must have been wrong.
"Aut Vincere Aut Mori"
Apache OpenOffice 4.1.7
Windows 10
Scribe_05
 
Posts: 16
Joined: Fri Oct 23, 2015 3:14 am

Re: [Solved] CONCATENATE Problem

Postby Lupp » Tue May 05, 2020 3:30 pm

How LibO treats the parameter separator got heavily complicated some time ago. In short: Localization spilt over and compatibility with the bad practice of Excel got too high preference. This aggravates cooperation.

You may read https://ask.libreoffice.org/en/question ... -my-sheet/.
On Windows 10: LibreOffice 7.0 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2980
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests