Well, the question is basically already in the title. Why do format codes depend on the language that LibreOffice is set to? Is this (just) for Microsoft-compatibility? Is there a way to always use the English format codes, or a way to recognise format codes of all languages?
At my workplace I recently had to use an Excel sheet from the admin department that was formatted in the local language, while at my workplace computer I have set LibreOffice to English (UK). Needless to say, the whole document was messed up, until I realised that it was a language issue (and that took quite some time…). Now I am forced to switch language whenever I need to use that document. Today it was the other way round. I opened an English (US) Excel spreadsheet on my private computer which has LibreOffice set to the local language, and formatting was messed up again.
Is there any good reason for that behaviour? I really can’t see any advantages here.
Additionally, is it possible to avoid that behaviour? Can you set LibreOffice to always use English formatting codes, or to recognise formatting codes of all supported languages?
I’m sorry if this question was already answered, but my searches turned up nothing.