[Libreoffice-bugs] [Bug 112462] New: Writer formula bar ignores locale

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112462

            Bug ID: 112462
           Summary: Writer formula bar ignores locale
           Product: LibreOffice
           Version: 5.4.1.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Writer
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: sergio.callegari at gmail.com

Description:
On systems with LibO set to use the comma (,) as a decimal separator, the
formula bar in writer insists that numbers are entered using the dot (.) as a
decimal separator 

Steps to Reproduce:
1. Open writer, assure that the locale is set so as to use the comma as a
decimal separator
2. Create a table
3. Write a number with decimal digits into a cell using the comma as the
decimal separator (e.g. 67,20)
4. Use the Table->Number format function to assure that the number is correctly
interpreted as such, with the correct magnitude
5. Now, go to another cell. Enter "=" or "F2" so that the formula bar opens
6. Enter the same number as above with the same formatting (e.g., 67,20)
7. Now, go to another cell. Enter "=" or "F2" so that the formula bar opens
8. Enter the same number as above, now using the dot as the decimal separator
(e.g., 67.20)
3.

Actual Results:  
Libreoffice writer at point 6 interpretes the number as if there were no
decimal separator (e.g., 6720). At point 8 it interprets the number correctly

Expected Results:
At 6 Writer should have interpreted the number considering the decimal
separator. At 8 it should not have.

Incidentally, note that the formula bar in calc works as expected, differently
from the one in writer.


Reproducible: Always

User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: TextDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes

Note that the automatically included information above is incorrect. If I go to
the LibO Tools->Options->Language Settings->Languages, then I have en-US as the
user interface setting, but Italian as the Locale.
Builds ID: LibreOffice 5.4.2.1


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:55.0) Gecko/20100101
Firefox/55.0

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170918/065b36ab/attachment.html>