Libre Office 24.8 Online Help

[Teaman]

Seems someone changed their mind re function formats

Eg
Online Help: Uses the semi-colon as a separator
=AND(Logical 1 [; Logical 2 [; … [; Logical 255]]])

The logical values of entries 12<13; 14>12, and 7<6 are to be checked:

=AND(12<13;14>12;7<6) returns FALSE.

=AND(FALSE();TRUE()) returns FALSE.

The reality is that the comma is used as a separator.

Any more tail chasing gems ?

[EarnestAl]

The semi colon is accepted as a function separator for all locales.

• For those countries that use a comma as the decimal separator, then the semi colon is always shown in the formula.
• For some countries that use a point as the decimal separator, by default, the semi colon is converted to a comma to ease the way for those users coming from Microsoft Excel.

To avoid ambiguity, the semi colon is always shown in LibreOffice Help and documentation.
.
If you would like to disable the conversion of semi colon to comma and enforce the semi colon in your locale there is a setting in Tools > Options > LibreOffice Calc > Formula

[fpy]

@EarnestAl

documentation

https://community.documentfoundation.org/t/separator-of-calc-function-arguments/12112/6