That's right. But We will always can decide in favor of rounding or truncate decimal number. And, I also think the could be implemented the feature: Give the user the power to decide what kind of operations (s)he prefer: Rounding or Truncating
Carlos Alberto
COELCE/DPRON-Departamento de Projetos e Obras Norte
Fone: 677- 2228
e-mail: calves coelce com br
(___)
< o o >
\ ^ /
(")
-----Original Message-----
From: Morten Welinder [mailto:terra diku dk]
Sent: Tuesday, June 12, 2001 6:38 PM
To: nj lee plumtree co nz
Cc: gnumeric-list gnome org
Subject: Re: Rounding??
Certainly but when you provide a mapping from one space (binary) to the
display space (decimal) is important that the display understands its
(numeric) context.
Users expect it, but it is not possible.
An accountant will want "0.365" rounded to "0.36". A mathematician
will want "0.37". Someone is not going to like the result. The
mathematician also wants "=sin(pi/4)-cos(pi/4)" to yield zero. Don't
count on it.
Right now we are consistent in the best-approximation sense[*], I
hope. And no-one is happy, because -- as you say -- people generally
do not think in binary.
See the 0.62 release notes in your NEWS file for more information.
Morten
[*] The value of every subexpression is "rounded" to nearest valid
binary representable value.
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list