Bug 124527 - Display of calculation results incorrect for "Number" or "Scientific" format cells, but correct for "Text" format cells
Summary: Display of calculation results incorrect for "Number" or "Scientific" format ...
Status: RESOLVED FIXED
Alias: None
Product: calligrasheets
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: Calligra Sheets (KSpread) Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-03-30 00:09 UTC by Robert Knight
Modified: 2008-11-15 15:43 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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