Gnumeric producing odd product

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Gnumeric producing odd product

GnuMeric mailing list
According to Gnumeric, 3*0.1 = 0.30000000000000004

It has the same trouble when multiplying 0.1 by 6,7,12,14,17, and 19. Or 0.3 by 3,6,9,12, or 18.

It thinks 0.3 * 9 is  2.6999999999999997

Please help.


_______________________________________________
gnumeric-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list

Book5.gnumeric (2K) Download Attachment
Screenshot_2020-07-03_00-16-33.png (49K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Gnumeric producing odd product

Jean Brefort-2
Hi,

Morten already replied to your bug report. Same answer:
http://www.gnumeric.org/numerical-issues.html

Regards,
Jean

Le jeudi 02 juillet 2020 à 23:35 +0000, Mark Ballard via gnumeric-list
a écrit :

> According to Gnumeric, 3*0.1 = 0.30000000000000004
>
> It has the same trouble when multiplying 0.1 by 6,7,12,14,17, and 19.
> Or 0.3 by 3,6,9,12, or 18.
>
> It thinks 0.3 * 9 is  2.6999999999999997
>
> Please help.
>
> _______________________________________________
> gnumeric-list mailing list
> [hidden email]
> https://mail.gnome.org/mailman/listinfo/gnumeric-list

_______________________________________________
gnumeric-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list