The help in /help/source/text/scalc/01/04060107.xhp
says in section "Using Inline Array Constants in Formulas"
The column separator (separating elements in one row) and the row separator are language and locale dependent. But in this help content, the ';' semicolon and '|' pipe symbol are used to indicate the column and row separators, respectively. For example, in the English locale, the ',' comma is used as the column separator, while the ';' semicolon is used as the row separator.
But the help does not mention, where the user can find the actual setting for his version. And the help is missing, that the user can alter this setting.
I suggest (in content, not literally)
The row and column separator can be seen and altered in Tools > Options > Calc > Formula > Separators.
Such information in the help might prevent bug reports like bug 42947 or bug 108087.
*** Bug 112400 has been marked as a duplicate of this bug. ***
(In reply to Cor Nouws from comment #2)
> *** Bug 112400 has been marked as a duplicate of this bug. ***
Sure - allow me to change the summary here ;)
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":
tdf#108090 Clarify array separators in help pages