Critical bug in LibreOffice Calc when using mod (showstopper for 3.5.4?)

[Petr Mladek]

Robinson Tryon píše v Čt 24. 05. 2012 v 00:01 -0400:
> On Wed, May 23, 2012 at 7:59 AM, Axel Reimer <loparity at 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