There is a problem with my libreoffice. I doesn't calculate cells with decimal points, possibly seeing them as text.

enter image description here

I have checked my locale settings (you can see them in the picture above) that decimal separator is dot. Also I have unticked "Using regular expression" in Tools - Options


I have no idea how to fix that and force libre to understand this is float point number.

Any help is appreciated.

  • with LibreOffice on GNU/Linux it works fine, i.e. 0.6*10 gives 6. But if I write 0,6 in A1, then I get #VALUE! of course. So the only guess we can do, it's that the cell is not seen as containing a number. You say you are sure dot is decimal separator, but have you tried 1) writing 0,6 instead, 2) taking a loot at the format of the cell? Jan 11 '14 at 23:50
  • 1
    1) yes 2) no. your suggestion directed me to check locale settings. This helped, thanks!
    – 3demax
    Jan 12 '14 at 0:17

I've figured out what it was. The error was weird and it was about cell formatting. Turns out, that locale was set, as first screenshot in question states, to "Default - English (USA)". And that exactly caused a problem. Unfortunately, I can't explain why. enter image description here Setting cell formatting locale to "English (USA)" fixed the cell. And setting "English (USA)" in settings had fixed problem to the whole file altogether.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.