When I try to input a dot in formulas in Calc, it is automatically changes to an apostrophe.
For example, I tried to input below formula.
However, it is automatically changed to below formula and results in an error, Err 509.
It seems it is related to the decimal separator key because this computer is located in Belgium and comma is typical decimal separator key in this country. However, I set the system language as English, the locale format as English (US), the location as US, the keyboard default language as English. And Libreoffice’s option > Language settings are all set to English (US) as below.
User interface : Default English (USA)
Locale setting : English (USA)
Decimal separator key: Same as locale setting (.) (checked)
This problem is frustrating. This problem does not occur in my other laptop with Windows 10, but it only occurs on my laptop with Windows 7.
How can I solve this problem?
My system and libreoffice’s version information is as below.
Version: 188.8.131.52 (x64)
Build ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16
CPU threads: 4; OS: Windows 6.1; UI render: default;
Locale: en-US (en_US); Calc: group
Thank you in advance.