To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75536
------- Additional comments from [EMAIL PROTECTED] Fri Mar 30 21:22:08 +0000 2007 ------- Eike, The spreadsheet implementation sign(r)==sign(d) brings funny result for rest as it happens in excel2003; if you implement his rule for the rest without taking into account the quotient you really do something wrong. Excel really put the rest of the same sign of the divisor, but doing so the condition a=qd+r is not satisfied in the example written in previous reporting. Whatever is the way you want to solve this issue, please save the math and do not follow excel2003 as -5!=5 and 5!=-5. In any case it will bring incompatibilities with excel's bugs; but the question then is: should be openoffice compatible with excel at bugs level ? Please note that gnumeric, to cut the gordian knot, doesn't seem to have a rest/remainder function. Thanks, Romolo --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
