Issue 94416 - Big automatic fill / truncating decimal problem
Summary: Big automatic fill / truncating decimal problem
Status: CLOSED DUPLICATE of issue 69749
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-09-29 10:39 UTC by maxint
Modified: 2008-10-01 12:15 UTC (History)
1 user (show)

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

Attachments
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 maxint 2008-09-29 10:39:38 UTC 
Hi all,
I tried this experience on WindowsXp, Linux, Pentium 4 and AMD64, so I assume i
depends on the code of OpenOffice.
If you try to write a column with the following number "1.1" "1.2" "1.3" and so
on, and you use the mouse to fill all the column, something strange happen.
Around 6 or 7 number follow this: "6.0" "6.1" "6.1999999" "6.29999" "6.39999"
"6.39999" ;  
BUT whn you reach 10: "10.0" "10.1"  all return normal.
This is strange, I think there is a big problem in the code...
Comment 1 kla 2008-09-29 11:20:05 UTC 
First its not a chart problem, i change it.
Second, changed Prio to a more realistic value.
Comment 2 kla 2008-09-29 11:37:50 UTC 
double

*** This issue has been marked as a duplicate of 69749 ***
Comment 3 kla 2008-09-29 11:38:26 UTC 
closed as double
Comment 4 maxint 2008-09-29 18:10:16 UTC 
Ok, sorry for my mistakes on Prio and Component.
However I can't see why randomly change the format of the cells.
If I have a column with "1.2", why seldom Calc change to "1.199999"?
I repeat I don't use formulas, I only try to fill a column with the automatic 
fill of the mouse (that add +0.1 in my case), and some random cells change format.
Thank you
Comment 5 ooo 2008-10-01 12:15:17 UTC 
Actually this is duplicate to issue 88119, which is related to issue 69749 though.

@maxint: most decimal numbers don't have an exact representation as binary
floating point, therefor rounding errors occur when sequentially adding values.