Bug 173731

Summary: Don't interpret a "," as thousands separator in places it isn't one.
Product: [Applications] calligrasheets Reporter: Michael Leupold <lemma>
Component: generalAssignee: Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null>
Status: CONFIRMED ---    
Severity: normal CC: lueck
Priority: NOR    
Version First Reported In: Git   
Target Milestone: ---   
Platform: unspecified   
OS: Linux   
Latest Commit: Version Fixed/Implemented In:
Sentry Crash Report:

Description Michael Leupold 2008-10-28 06:59:01 UTC 
Version:           2.0 beta-2 (using 4.1.71 (KDE 4.1.71 (KDE 4.2 >= 20081023)), compiled sources)
Compiler:          gcc
OS:                Linux (x86_64) release 2.6.25.7quechua-0.1intelquechua-0.1intel

Steps to reproduce:
1. Open a new blank worksheet
2. Enter =1,5+2,5 into cell A1
3. Value gets displayed as 40.
=> This is for thousands separator set to ",". Reproducible with =1.5+2.5 with thousands separator set to ".".

The thousands separator should only be parsed as one in places it actually can be one. I expect the computed value to be some #ERROR. Else it's quite possible a user creates bugs in his sheet if he erroneously enters the wrong decimal point.
Comment 1 Burkhard Lück 2011-08-12 06:36:43 UTC 
Version 2.4 Alpha 3
Using KDE Development Platform 4.7.40 (4.7.40 (KDE 4.8 >= 20110623)

Systemsettings comma (,) as decimal separator

Changed behaviour:

=1.5+2.5 -> result 4
=1,5+2,5 -> result 4
Comment 2 Justin Zobel 2021-03-09 22:44:03 UTC 
Thank you for the bug report.

As this report hasn't seen any changes in 5 years or more, we ask if you can please confirm that the issue still persists.

If this bug is no longer persisting or relevant please change the status to resolved.