https://bugs.documentfoundation.org/show_bug.cgi?id=157856
--- Comment #8 from Mike Kaganski <mikekagan...@hotmail.com> --- Created attachment 190352 --> https://bugs.documentfoundation.org/attachment.cgi?id=190352&action=edit Excel doing the same (In reply to cppjohn from comment #7) > Nonetheless, it should be said that > 0.95000000000000006661338147750939242541790008544921875 > nor > 0.9499999999999999555910790149937383830547332763671875 > equals 0.95, but that 0.95 less 0.9 does. > > In my mind, it should interpret 0.95 as 0.95, not > 0.9499999999999999555910790149937383830547332763671875. Please read the FAQ. The number 0.95 is *not* representable in the binary numbers used in Calc (and Excel, and Gnumeric...). It is state of the industry. It is something one must be prepared to. No amount of imagining what it should, can change the current hardware imitations. -- You are receiving this mail because: You are the assignee for the bug.
