In LO calc, can the coma be changed to the period in spreadsheet like in the old version?
In the old verson when entering a number it look like this 100.00, in the new version its like this 100,00
Thank you.
- Select menu item Tools - Options
- In the left pane, expand branch Language settings and select Language
- For Locale, make sure that the correct setting is made according to the language of your data (language where period character is decimal separator, e.g. most varieties of English).
-
If the normal decimal separator for that locale is comma:untick Decimal character … Same as locale setting (,).
Huh - why? What is this suggestion for, and what it its expected result?
That option affects only the decimal key on the numeric pad of a standard keyboard. If the locale is a comma locale, the num pad should send a comma. In case of a decimal point locale it should always be a point. I have no idea why anybody could want to toggle this. IMHO, this is one of these options that shoul not exist.
I tend to agree; and during all these years, I don’t remember a situation where this option proved helpful to any task. (I realize that I might miss some use case, but… … - well, maybe just to someone who types texts only, and wants the key to put dot to their texts, because they find that key more cute?)
Anyway: if you believe it needs to vanish, the only way to do that is … tada … file a report 
I thought I had used it for this purpose, but you are quite right @Villeroy and @mikekaganski , the setting does nothing to display output.
Correcting my answer.
My misunderstanding probably comes from (or at least is supported by) this dialog entry’s Norwegian translation to “desimaltegn” which means “decimal character”, not “decimal key”. No excuse for not testing the suggestion before posting it, I know. Sometimes I cut corners…
Because in some regions the used keyboards’ numeric key pad decimal separator key does not match the locale’s separator. Similar if you prefer to work on an English keyboard but use a locale that has a , comma decimal separator. Doesn’t matter with most notebook keyboards as they don’t have a numeric keypad (other than some hand twisting Fn key assignment), but does with full keyboards or data typist keypads.
1 Like
IIUC, @Villeroy (and definitely myself) mean that the enabled state (use the decimal separator of the configured locale) makes ~universal sense, not disabled state (which is for “use whatever driver sends”).