Ask Your Question
1

Decimal and thousands separators in numbers and how locales apply to this?

asked 2018-10-30 08:58:51 +0200

damdim gravatar image

updated 2018-10-30 18:38:38 +0200

EasyTrieve gravatar image

Hi, I have installed libreoffice 6.1.2 on Windows 10. My language is set to Greek so the decimal separator key is "," When I type or paste 0.5 0.05 0.0005 it stays as what I typed, align left as text. But when I type 0.005 then it converts to 5 and aligns right as number. The same thing happens when I change the locale to English, but with the text 0,5 0,05 0,005 etc. Is this a bug or intended behavior?

edit retag flag offensive close merge delete

Comments

+1 for saying what your version and OS are.

EasyTrieve gravatar imageEasyTrieve ( 2018-10-30 18:37:10 +0200 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2018-10-30 09:06:31 +0200

In Greek locale, the dot is also used in numbers - as thousand separator. So, when you have the proper three digits after the ., it is recognized that you've entered the proper number (zero thousand and five), and it's treated as such. The same holds for English locale (modulo using , for thousand separator).

If you need your input to always be considered text, then just format your cells (columns?) as text prior to input.

edit flag offensive delete link more

Comments

1

Either that, or input otherwise numeric values with a leading apostrophe '0.005 which forces content to Text type; the apostrophe will not be part of the cell content.

erAck gravatar imageerAck ( 2018-10-30 11:54:09 +0200 )edit
0

answered 2018-10-30 09:38:09 +0200

damdim gravatar image

Spot on. Thank you.

edit flag offensive delete link more

Comments

@damdim, the appropriate place to put your thank you is first to check the up arrow above the Zero '0' to the left of the answer you received. ALSO, if this answered your question (the one that you typed in above), the proper thing to do is the click on the check mark below this zero, to turn it green. This lets everyone know that your question has been answered. It also rewards the person who answered your question with points, and as you yourself get more points here you will get respect.

EasyTrieve gravatar imageEasyTrieve ( 2018-10-30 18:32:57 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-10-30 08:58:51 +0200

Seen: 80 times

Last updated: Oct 30 '18