Bug 307795 - Number with decimals modified when inserting cells
Summary: Number with decimals modified when inserting cells
Status: RESOLVED WORKSFORME
Alias: None
Product: calligrasheets
Classification: Applications
Component: general (show other bugs)
Version: 2.5.2
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: Calligra Sheets (KSpread) Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-10-03 20:22 UTC by Alex
Modified: 2019-01-09 02:22 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 Alex 2012-10-03 20:22:56 UTC 
I've a simple sheet with some rows with decimals on column G. The decimal separator on my system is ",".

If I insert some cells in another part of the sheet, for example in E20:F20, the decimal separator vanish and decimals on column G get converted in integers. For example 4,5 becomes 45 (!!)

Really weird bug

Reproducible: Always
Comment 1 eric 2012-10-23 12:04:30 UTC 
Still reproducable in calligrasheets-2.5.3 and kde-4.9.2.

Steps to reproduce:
1) Change in systemsettings > Locale > Numbers: Decimal separator in "," and Group separator in "."
2) Start calligrasheets
3) Enter in cell A1 "=1,0+2,0"
4) Copy & pase cell A1 to cell A2

Result:
Cell A2 shows "30" (should be "3")
The formula in cell A2 is "=1.0+2.0" (should be "=1,0+2,0")

Changing in systemsettings > Locale > Numbers: Decimal separator in "." and Group separator in "," will make calligrasheets behave correctly.
Comment 2 Andrew Crouthamel 2018-11-09 01:08:21 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 3 Andrew Crouthamel 2018-11-20 04:09:46 UTC 
Dear Bug Submitter,

This is a reminder that 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? This bug will be moved back to REPORTED Status for manual review later, which may take a while. If you are able to, please lend us a hand.

Thank you for helping us make KDE software even better for everyone!
Comment 4 Alex 2018-12-13 08:12:08 UTC 
I'm unable to reproduce it anymore
Comment 5 Christoph Feck 2019-01-09 02:22:48 UTC 
Thanks for the update; changing status.