Bug 198670

Summary:	kspread's cell number default precision is set too high
Product:	[Applications] calligrasheets	Reporter:	greatbunzinni
Component:	general	Assignee:	Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null>
Status:	RESOLVED FIXED
Severity:	normal	CC:	harrys4you, mecirt
Priority:	NOR
Version First Reported In:	2.0
Target Milestone:	---
Platform:	Ubuntu
OS:	Unspecified
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:

Description greatbunzinni 2009-07-02 18:26:37 UTC

Version:           2.0.1 (using KDE 4.2.90)
Installed from:    Ubuntu Packages

When a formula is entered in one of kspread's cells, if that formula produces a non-integer number then that number is displayed with around 10 decimal spaces. That ends up making the spreadsheet unreadable and therefore forces the user to edit the number precision every time a new cell is edited which, as kspread is painfully slow, ends up costing quite a lot of time.

It would be nice if kspread had default values for the number precision that ended up being more manageable (around 2 or 3 decimal spaces).

Comment 1 Srihari 2010-05-05 10:57:09 UTC

I will try fixing this.

Comment 2 Andrew Crouthamel 2018-11-09 01:03:28 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:01:58 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 Justin Zobel 2022-12-31 00:24:32 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 5 Tomas Mecir 2022-12-31 17:40:11 UTC

This has been fixed earlier.