Bug 173731 - Don't interpret a "," as thousands separator in places it isn't one.
Summary: Don't interpret a "," as thousands separator in places it isn't one.
Status: CONFIRMED
Alias: None
Product: calligrasheets
Classification: Applications
Component: general (show other bugs)
Version: Git
Platform: unspecified Linux
: NOR normal
Target Milestone: ---
Assignee: Calligra Sheets (KSpread) Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-10-28 06:59 UTC by Michael Leupold
Modified: 2021-03-09 22:44 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.