In a different thread errors caused by substituded separators were discussed. There user "John_Ha" had posted the comment quoted below to which I want to refer here since I assume specifically questioners coming to this LibreOffice subforum might be afflicted by the situation..
John_Ha wrote:AOO uses semi-colons as parameter separators.
LO uses commas and converts typed semi-colons to commas.
AOO and LO are diverging quite rapidly.
The second line is not quite correct.
LibreOffice made the
default parameter separator depending on the locale a while ago:
For locales using the point as their decimal separator, the comma is put in the role of the parameter separator. They obviously did it to be "better compatible with Excel" where still many users not fond of thinking much get their suggested formulas from. Informed users change the comma then to semicolon again via option settings.
(Less urgent:)
The separators used for inline constant arrays are a related topic. ('5.13 Inline Arrays' of OASIS documents
OpenDocument-v1.2-part2 and
OpenDocument-v1.3-cs01-part4-formula as well give the separators used when writing to the file. Original state was consistend and made the same characters mandatory for the UI. Silly localization messed it up.) In this case, however, the situation is worse: The pair of ";" and "|" is replaced by "," and ";" depening on the locale by default. Since the semicolon is used in both versions, but in different roles, this spoils everything, and makes impossible an easy way to re-enable global exchange. (Therefore I didn't include this part with my posts linked below. Inline arrays are rarely mentioned in related questions anyway.)
See this Q&A thread for more details:
https://ask.libreoffice.org/en/question/131311/.
On Windows 10: LibreOffice 7.0 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München