Bug 119314 - A dot is automatically changed to an apostrophe in formulas in Calc
Summary: A dot is automatically changed to an apostrophe in formulas in Calc
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-08-16 13:26 UTC by snowboard975
Modified: 2019-05-08 20:44 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description snowboard975 2018-08-16 13:26:39 UTC
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/
Comment 1 m_a_riosv 2018-08-16 23:38:13 UTC
Have you tested with Menu/Help/Restart on safe mode.
Comment 2 QA Administrators 2019-03-21 11:11:11 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2019-05-08 20:44:12 UTC
Dear snowboard975,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp