https://bugs.freedesktop.org/show_bug.cgi?id=50299

             Bug #: 50299
           Summary: Critical bug in LibreOffice Calc when using MOD (the
                    modulo function)
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.3 release
          Platform: Other
        OS/Version: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: [email protected]
        ReportedBy: [email protected]


There appears to be a bug in the Calc modulo function.

Here's the description from Axel Reimer's email entitled "Critical bug in
LibreOffice Calc when using mod (showstopper for 3.5.4?)"

---
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,4*100;10) in a cell 0 is displayed as result
=mod=(0,5*100;10) in a cell 0 is displayed as result
=mod=(0,6*100;10) in a cell 7,1054E-015 is displayed as result
=mod=(0,7*100;10) in a cell 0 is displayed as result
=mod=(0,8*100;10) in a cell 0 is displayed as result
=mod=(0,9*100;10) in a cell 0 is displayed as result

=mod=(30;10) in a cell 0 is displayed as result
=mod=(60;10) in a cell 0 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?

Best regards,
Axel

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to