[Solved] CONCATENATE Problem

[Scribe_05]

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?

[erbsenzahl]

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?

[Scribe_05]

Thank you for your reply.
I thought I had tried that but I guess I must have been wrong.

[Lupp]

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/.