Even if we aren’t interested in generic language services/tools (check spelling?), there is the little disadvantage that the assumed “default date format” depends on this language setting. These formats are bad for en-gb and for de-de as well - but in different ways. In fact they are very bad for next to all locales.
The only pair of language settings I know being different concerning the decimal separators, but having both ISO 8601 extended
set as the default date format in recent versions of LibreOffice Calc
are en-ca(1.5 : 2023-12-14) and fr-ca(0,5 : 2023-12-14). In addition fr-ca is the only locale I know not using one of the deprecated Thousands Separators
.
(This may not be due to superior intelligence, but is supposed to be standardized due to the permanent problem of serious misunderstandings in data exchange between Canada and the USA. Surely Canada would also prefer bad formats otherwise - as “they all” do.)
From the attached example you can learn that things get easy with Canadian settings. I’m using them since they were availablke this way despite being a German and living in Germany.
disask87639numberFormatSuggestionPermanent.ods (31.2 KB)