<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type"/>
</head>
<body>
<p style="margin: 0pt;">
<span>
<span></span>
</span>
</p>
<p>Hello,</p>
<p> </p>
<p>in LibreOffice Calc 3.5.3 there is a critical bug in the mod function.</p>
<p> </p>
<p>When using</p>
<p>=mod=(0,3*100;10) in a cell 3,5527E-015 is displayed as result</p>
<p>=mod=(0,4*100;10) in a cell 0 is displayed as result</p>
<p>=mod=(0,5*100;10) in a cell 0 is displayed as result</p>
<p>=mod=(0,6*100;10) in a cell 7,1054E-015 is displayed as result</p>
<p>=mod=(0,7*100;10) in a cell 0 is displayed as result</p>
<p>=mod=(0,8*100;10) in a cell 0 is displayed as result</p>
<p>=mod=(0,9*100;10) in a cell 0 is displayed as result</p>
<p> </p>
<p>=mod=(30;10) in a cell 0 is displayed as result</p>
<p>=mod=(60;10) in a cell 0 is displayed as result</p>
<p> </p>
<p> </p>
<p>The values for 0,3*100 and 0,6*100 are definitely wrong.</p>
<p> </p>
<p>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?</p>
<p> </p>
<p>Best regards,</p>
<p>Axel </p>
</body>
</html>