So I’ve seen in forums you have to format cells to change decimal symbol. So the default is . and i tried to make it , . Pressed OK of course, tried to switch system decimal symbol and the error is still there even after saving, restarting libre office etc. What do I do wrong?
Answer depends heavily on OS. Which is yours? What’s your locale? Also LO version may be useful.
You have selected an explicit language for your cell (Greek). That makes the decimal separator to be what is hardcoded in LO for that locale. You should either select another language that uses the separator you need (e.g., French), of use Default-XXX (which means that the locale settings would be defined by higher-level settings, possibly OS).
This seems to be still messed up by hard coded assumptions. Here we are hard coded to use “,” as the decimal separator, but nobody here uses “,”. We use “.” and “,” as a thousands separator. This means I have three choices, convince libreoffice to allow changing he decimal separator, change to a different language, or convince everyone in South Africa to behave according to Libreoffice assumptions. Workarounds and dirty hacks are no fun.
If you believe that LibreOffice settings don’t match a given country’s actual proper values, please file a bug report, since that would be a bug. Thanks.
In “Tools - Options - Language Settings - Languages” set Locale setting to Greek. Then you will have to correct the formula, I think.