Bug 307795

Summary:	Number with decimals modified when inserting cells
Product:	[Applications] calligrasheets	Reporter:	Alex <alex>
Component:	general	Assignee:	Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	prozac
Priority:	NOR
Version First Reported In:	2.5.2
Target Milestone:	---
Platform:	Ubuntu
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:

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.