Quotient and rest calculations

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 romoloopenoffice.org 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: issues-unsubscribesc.openoffice.org
For additional commands, e-mail: issues-helpsc.openoffice.org