Robinson Tryon píše v Čt 24. 05. 2012 v 00:01 -0400: > On Wed, May 23, 2012 at 7:59 AM, Axel Reimer <lopar...@fpgas.de> wrote: > > in LibreOffice Calc 3.5.3 there is a critical bug in the mod function. > > ...When using > > =mod=(0,3*100;10) in a cell 3,5527E-015 is displayed as result > > > > =mod=(0,6*100;10) in a cell 7,1054E-015 is displayed as result > > > > The values for 0,3*100 and 0,6*100 are definitely wrong. > > > > This could be a showstopper if this still happens in LibreOffice 3.5.4 RC1. > > Can someone test if this occurs in 3.5.4 RC1? > > Ayup. I'm seeing the same behavior in 3.5.4.1. > > I threw together a test document based on your examples and stapled it > to a new bug here: > https://bugs.freedesktop.org/show_bug.cgi?id=50299
Thanks a lot for reporting it. It looks ugly. Though, it seems to be "only" a rounding error. It never worked better. It happens also with other spreadsheet applications. => it can't be blocker. It probably does not cause too many problems in the real life. See https://bugs.freedesktop.org/show_bug.cgi?id=50299#c3 for more details. Best Regards, Petr _______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice