Step 1 type 0.025 or any other number starting with 0.0 and two digits
This makes litterally no sense whatsover to me (its not even in the format of a date or something).
Does someone know how to enter a number in the range between 0.01 and 0.099 with two digits accuracy?
Note: The second image is a link, because new users can only put one embed into a post.
Please attach your sample file. A screenshot does not allow to know which format is applied to the cell.
Don’t use “Suggest a Solution” to answer, press on the “Comment” callout.
Mention OS name, exact LO version (as reported by Help>About LO (in Standard Toolbar, while you seem to have chosen some tabbed UI) and save format (will be evident from the attached file).
See answer by @karolus. It makes perfect sense, if LibreOffice’s locale is set to the one that uses dot as thousand separator: your input then will be “zero thousand zero hundred twenty-five”.
And yes, for the “German (Germany)” set in your file, the dot is exactly the thousand separator, and comma is the decimal one.
That would make sense indeed.
I was always thinking I was using some kind of US locale, but I dont remember setting it up.
I think I am using
~ echo $LANG
C.UTF-8
which is apparently similar to eng_US, but for computers.
This is the screen in KDE plasma:
So in the list from KDE I see that I am using numbers with a dot and not a comma
Aha, that is set to Germany. Then it totally makes sense.
Strange that it was set to that value though.
Just a guess. It could be exactly because of that “C” locale used on your system. It doesn’t allow to guess any usable locale for LibreOffice; and then, it may end up with its birthplace. Its roots are in Germany, where StarOffice was born.
And no, LibreOffice does not use the fine-tuned locale settings from system (unfortunately; see tdf#46448, tdf#48043; tdf#73242, tdf#109058 and so on), but only detects a single general-purpose language and country, searches its own locale database for settings defined for that language+country, and defaults to that. You can change to another language+country; but, again, it will be set of settings hardcoded in the internal DB for that locale.
we dont know your locale-settings … looks like you should use ,comma instead .dot?
