Bug 124527

Summary: Display of calculation results incorrect for "Number" or "Scientific" format cells, but correct for "Text" format cells
Product: [Applications] calligrasheets Reporter: Robert Knight <robertknight>
Component: generalAssignee: Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: lambdae2, mecirt
Priority: NOR    
Version First Reported In: unspecified   
Target Milestone: ---   
Platform: Ubuntu   
OS: Linux   
Latest Commit: Version Fixed/Implemented In:
Sentry Crash Report:

Description Robert Knight 2006-03-30 00:09:24 UTC 
Version:           1.5rc1 (using KDE KDE 3.5.1)
Installed from:    Ubuntu Packages

Hi,

Whilst looking at this report comparing accuracy in Gnumeric and Excel: http://www.csdassn.org/software_reports/gnumeric.pdf , I decided to try some of the tests in KSpread.

Sometimes KSpread calculates the correct result, but shows it incorrectly if the number format is set to "Number" or "Scientific" but correctly if set to "Text" format.

eg:  "=POISSON(0;200;0)" should give "1.38e-87" but displays 0 in KSpread with number or scientific format, but gives a correct result in text format.

My guess is that the threshold for rounding results up/down to 0 is a little too high?
Comment 1 Elián Hanisch 2008-11-02 19:41:59 UTC 
I can confirm in svn trunk
Comment 2 Tomas Mecir 2008-11-15 15:43:06 UTC 
SVN commit 884606 by mecir:

Do not display small values as 0. Use scientific format if abs(value) <
1e-10.

BUG: 124527


 M  +8 -5      ValueFormatter.cpp  


WebSVN link: http://websvn.kde.org/?view=rev&revision=884606