Re: Floating Point Arithmetics, reading 0.1066913 gives 0.10669129999999999 --> Problem only with Excel, NOT with LibreOffice

2019-10-19 Thread Andreas Reichel
Libre Office writes: 48 40 43622

Re: Floating Point Arithmetics, reading 0.1066913 gives 0.10669129999999999 --> Problem only with Excel, NOT with LibreOffice

2019-10-19 Thread Andreas Reichel
Apologies, wrong file. Correction, Excel wrote: 26 376 436

Re: Floating Point Arithmetics, reading 0.1066913 gives 0.10669129999999999

2019-10-19 Thread David Law
Hello Andreas, I think if you check the original XML of your *.xlsx, you'll find that it contains something like: 0.106691299 This value can be mapped EXACTLY to a double in Java. So that's what you're getting. In other cases you may find XML values like: 8.61688004E-2 There is

Re: Floating Point Arithmetics, reading 0.1066913 gives 0.10669129999999999

2019-10-19 Thread Andreas Reichel
Good Morning David and All, thank you so much for your time and effort! I appreciate. At this point, I believe it is only MS Excel to blame for: On Sat, 2019-10-19 at 18:45 +0200, David Law wrote: > I think if you check the original XML of your *.xlsx, > you'll find that it contains something li

Re: Floating Point Arithmetics, reading 0.1066913 gives 0.10669129999999999 --> GNUMERIC vs LibreOffice vs Excel

2019-10-19 Thread Andreas Reichel
Guys, I am sorry: just one more for the fun. Opening the file in an XML Text Editor, I get 0.106691299. Opening the file in GNUMERIC, I get 0.106691299. (Both the shown cell content as well as the editable text box). Opening the file in LibreOffice, I get 0.1066913. (Same file, I