[Libreoffice-bugs] [Bug 119314] New: A dot is automatically changed to an apostrophe in formulas in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 119314
           Summary: A dot is automatically changed to an apostrophe in
                    formulas in Calc
           Product: LibreOffice
           Version: unspecified
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: snowboard975 at gmail.com

When I try to input a dot in formulas in Calc, it is automatically changes to
an apostrophe. For example, I tried to input below formula.

=2.03*2

However, it is automatically changed to below formula and results in an error,
Err 509.

=2'03*2

It seems it is related to the decimal separator key because this computer is
located in Belgium and comma is typical decimal separator key in this country.
However, I set the system language as English, the locale format as English
(US), the location as US, the keyboard default language as English. And
Libreoffice's option > Language settings are all set to English (US) as below.

User interface : Default English (USA) Locale setting : English (USA) Decimal
separator key: Same as locale setting (.) (checked)



This problem is frustrating. This problem does not occur in my another laptop
with Windows 10, but it only occurs on one of laptop with Windows 7. Strangely
enough, my another desktop PC with Windows 7 does not have this problem. 

My system and libreoffice's version information on which the laptop that has
the problem is as below.

Version: 6.0.5.2 (x64) Build ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16 CPU
threads: 4; OS: Windows 6.1; UI render: default; Locale: en-US (en_US); Calc:
group

Thank you in advance.

PS: There is a related post where you can see another user who experience the
same problem as below:
https://ask.libreoffice.org/en/question/161402/a-dot-is-automatically-changed-to-an-apostrophe-in-formulas-in-calc/

-- 
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/20180816/2ddf91be/attachment.html>