Bug 128533

Summary: EDITING, FORMATTING: Accept any decimal separator
Product: LibreOffice Reporter: Anton Tsyganenko <anton-tsyganenko>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WONTFIX    
Severity: enhancement CC: alterne, anton-tsyganenko, libreoffice-ux-advise, xiscofauli
Priority: medium Keywords: needsUXEval
Version: 6.3.2.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description Anton Tsyganenko 2019-11-01 14:09:58 UTC 
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
Comment 1 Diego 2019-11-02 09:38:07 UTC 
Confirmed, LO 6.3.2.2 on Majaro
Comment 2 Xisco Faulí 2019-12-12 12:40:41 UTC 
How would you know what's a decimal and a thousands separator then ?
Comment 3 Anton Tsyganenko 2019-12-17 05:30:35 UTC 
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.
Comment 4 Buovjaga 2020-04-27 18:26:29 UTC 
Very niche request, would close as wontfix and suggest to create a 3rd party extension instead. Let's confirm with UX.
Comment 5 Gilward Kukel 2020-04-27 18:32:42 UTC 
I think the key on the numeric keypad always makes the correct decimal separator.
Comment 6 Anton Tsyganenko 2020-04-28 05:27:34 UTC 
(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.
Comment 7 Heiko Tietze 2020-04-28 06:32:28 UTC 
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!