Description: I have no stable habit to use a specific decimal separator, so I may put both dots and commas. But LibreOffice forces me to use one that is specified by my locale settings, and it is very annoying when I type "5.12" (when decimal separator is comma) and LO thinks that it is text, not a number. Steps to Reproduce: 1. Check your locale settings to know your decimal separator 2. Insert some numbers in cells, putting the other separator 3. Try to find a sum of the cells 4. Find a free cell and put there a formula =1.1+0,3 Actual Results: the sum appears to be 0. The formula gives "#NAME?" error. Expected Results: LO finds the actual sum, and the result of the formula is 1.4 (or 1,4, depending on the settings). Reproducible: Always User Profile Reset: No Additional Info: Version: 6.3.2.2 Build ID: 6.3.2-2 CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: gtk3; Locale: ru-RU (en_US.UTF-8); UI-Language: en-US Calc: threaded
Confirmed, LO 6.3.2.2 on Majaro
How would you know what's a decimal and a thousands separator then ?
There are many possible ways: 1) Assume that the input does not contain thousands separator, assume both dot and comma to be decimal separator, raise error if a number contains more then one dot or comma. 2) If number contains one dot or comma, assume it to be a decimal separator, if more then one, then use the current algorithm (decimal and thousands separator based on locale settings). 3) If thousands separator in the locale is not dot or comma (for example, a space), then assume both dot and comma to be decimal separator, otherwise use current algorithm. 4) Allow user to choose between the current behavior and variants 1-3 in settings.
Very niche request, would close as wontfix and suggest to create a 3rd party extension instead. Let's confirm with UX.
I think the key on the numeric keypad always makes the correct decimal separator.
(In reply to Gilward Kukel from comment #5) > I think the key on the numeric keypad always makes the correct decimal > separator. No, it makes the separator depending on the current keyboard layout. When latin (en_US) layout is active, it makes a dot, that does not work as a decimal separator.
Agree with buovjaga's comment 4. Although I run into the same trouble every time, it's a special situation that could be solved per macro. Depending on the document locale you need either dots or commas and maybe it has to depend on the type, currency vs. numeric. We have an awesome macro support team that happily support this. Please share when done!