Issue 103337 - wrong display of 999999999999998 and 999999999999999
Summary: wrong display of 999999999999998 and 999999999999999
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: DEV300m50
Hardware: PC Windows XP
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-07-05 18:00 UTC by Regina Henschel
Modified: 2013-01-29 21:44 UTC (History)
5 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
wrong display of large integral numbers (12.74 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-07-05 18:01 UTC, Regina Henschel 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Regina Henschel 2009-07-05 18:00:48 UTC 
Open the attached file and notice the cells B8 and B9.
The values 999999999999998 and 999999999999999 are displayed as
1000000000000000, but treated with their correct value as you can see in the
other columns.

When OOo supports 15 decimal digits, the values should be shown as
999999999999998 and 999999999999999. Larger values should be shown in scientific
notation to indicate, that they might have rounding errors and the user cannot
trust, that they are integral numbers. (Although there are internally still
integral numbers as the calculation in the column E shows.)
Comment 1 Regina Henschel 2009-07-05 18:01:38 UTC 
Created attachment 63373 [details]
wrong display of large integral numbers
Comment 2 Rainer Bielefeld 2009-07-06 06:23:03 UTC 
I checked with "Ooo 3.1.0 WIN XP multilingual version German UI activated 
[OOO310m11 (Build 9399)]" and can confirm the reported effect with I checked
with "Ooo 3.1.0 WIN XP multilingual version German UI activated  [OOO310m11
(Build 9399)]" and can confirm the reported effect with "largest integrals wrong
displayed.ods" and own documents. And I agree that it is worrying. 
But I can't decide whether 1,00E+15 starting with "999999999999997" really is a
progress.
Comment 3 kpalagin 2009-07-11 12:57:49 UTC 
Confirming with 3.1 on WinXP - as described.
Related to 69749?
Comment 4 Regina Henschel 2009-07-11 13:09:03 UTC 
Not related to 69749, that issue is about decimal numbers, this is about
integral numbers.