Re: Rounding??

[Morten Welinder <terra diku dk>]

   Gnumeric seems to do all sorts of things I cant quite figure out.

   The _important_ thing is to have _consistent_ behaviour.  

   At the moment

   3.15, 3.25, 3.35, 3.45, 3.55, 3.65, 3.75, 3.85, 3.95, 4.05, 4.15 
   gives me
   3.1,  3.2,  3.3,  3.5,  3.5,  3.6,  3.7,  3.8,  4.0,  4.0,  4.2

   which just seems confusing.  Why are 3.4 and 3.9 missed?? 


Think binary.

Gnumeric does not know what 3.45 is.  It has some approximation, which
may be ever so slightly bigger or ever so slightly smaller.  (Well,
it's more like "i386" than "gnumeric" that does this, but all other
processors in common use these days also use a binary representation.)

Morten