A dot is automatically changed to an apostrophe in formulas in Calc

snowboard975 · July 23, 2018, 5:29pm

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 other laptop with Windows 10, but it only occurs on my laptop with Windows 7.

How can I solve this problem?

My system and libreoffice’s version information 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.

erAck · July 23, 2018, 6:49pm

That’s odd… can you enter such number into a cell and it is recognized as numeric number? For example in A1 enter 2.03 and in A2 =SUM(A1) should result in 2.03 not 0.

snowboard975 · July 25, 2018, 7:10pm

Yes, I can enter 2.03 in cell A1 and =sum(a1) in cell A2, and cell A2 shows correct answer 2.03.
My problem only occurs in a formula, not just a number. If I enter =2.03 in cell A1, cell A2 shows an error, Err:509 because cell A1’s content was automatically changed to =2’03

Jpgrah · August 12, 2018, 3:48pm

Does the same thing for me in 6.1.0. This error is a show stopper. already went back to 6.0.6.

erAck · August 15, 2018, 11:29am

Please report a bug at http://bugs.documentfoundation.org/

Hopefully someone can reproduce and nail down the circumstances under which it occurs so that it could be fixed.

snowboard975 · August 16, 2018, 1:30pm

Thank you for the answers. I have filed a bug report as below.

erAck · August 16, 2018, 2:17pm

Thanks a lot!

Fwiw, it’s tdf#119314

erAck · July 25, 2018, 8:12pm

Might be some weird AutoCorrect feature is hitting… try menu Tools → AutoCorrect Options… → Options, uncheck Use replacement table and see if that changes anything. If then good please check Format → Cells… → Font, the Language setting, and if you can spot a replacement in Tools → AutoCorrect Options… → Replace for that language which could cause this behaviour. If there is any please report back. Thanks.

snowboard975 · July 27, 2018, 1:27pm

Tools->AutoCorrect Options … → Options : Use replacement table has already been (i mean “has been” as “was” and also “is”) unchecked.
Format → Cells … → Font: Language has been set as English (USA).
Tools-> AutoCorrect Options … → Replace : Language has been set as English (USA). I looked carefully at the list of replacement rules. There is no entry that changes dot to apostrophe in the list. They are just default rules that I did not add or modify anything.