Bug 323019 - Copy and paste changes the decimal separator ("decimal mark")
Summary: Copy and paste changes the decimal separator ("decimal mark")
Status: CONFIRMED
Alias: None
Product: calligrasheets
Classification: Applications
Component: general (show other bugs)
Version: 2.6.3
Platform: Kubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: Calligra Sheets (KSpread) Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-07-30 20:31 UTC by Ganton
Modified: 2022-12-03 12:07 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Ganton 2013-07-30 20:31:49 UTC 
Details: (Please see the "Steps to Reproduce").

Reproducible: Always

Steps to Reproduce:
Configure the system to use a locale (like Spanish) that uses a "," as a decimal separator ("decimal mark"). Open Calligra Sheets and:
            - In A1, type 
                0,1
            - In B1, type 
                =1,95-1,85
            - In A2, type 
                =IF(A1=0,1;"Ok";"THE HORROR")
            - Press Return.    
            - Go back to A2, press Ctrl+c.    
            - Go to B2, press Ctrl+v.
Actual Results:  
In B2, the formula is
=IF(B1=0.1;"Ok";"THE HORROR")

Expected Results:  
In B2, the formula should be
=IF(B1=0,1;"Ok";"THE HORROR")
That is "0,1", not "0.1".

By the way, congratulations for Calligra Sheets. If we perform those steps in Excel, in B2 we read "THE HORROR", but not in Calligra Sheets.
Comment 1 Andrew Crouthamel 2018-11-10 03:15:54 UTC 
Dear Bug Submitter,

This bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version? I am setting the status to NEEDSINFO pending your response, please change the Status back to REPORTED when you respond.

Thank you for helping us make KDE software even better for everyone!
Comment 2 Ganton 2018-11-14 17:56:43 UTC 
The same still happens using Calligra 3.1.0 under Kubuntu 18.10.
Comment 3 Justin Zobel 2022-12-03 09:01:45 UTC 
Thank you for reporting this issue in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the issue with a recent software version?

If you can reproduce the issue, please change the status to "REPORTED" when replying. Thank you!
Comment 4 Tomas Mecir 2022-12-03 12:07:12 UTC 
Confirmed in latest git version.