To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=34085
User regina changed the following:
What |Old value |New value
================================================================================
CC|'mackmoon,torte782000' |'mackmoon,regina,torte7820
| |00'
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Wed May 13 19:06:32
+0000 2009 -------
I think, that it cannot be solved inside the code of MOD, because MOD cannot
know and cannot determine, how many decimal places you use in your decimal
number. But you know it. And therefore you can round the intermediate result to
the correct amount of decimal places.
For the example =QUOTIENT( MOD( R10 * 100 ; 10 ) ; 1 ) the solution would be
=QUOTIENT( ROUND(MOD( R10 * 100 ; 10 )) ; 1 )
For the example =QUOTIENT(MOD(0,21;0,1); 0,01) the solution would be
=QUOTIENT(ROUND(MOD(0,21;0,1);2); 0,01)
The general problem with precision with binary representation is already tracked
in issue 69749.
Therefore I suggest to close this issue as WONTFIX, because there is nothing,
what can be done inside the MOD-function. [I know the code of MOD, because I
have worked on it recently (i59153) to fix an error with integral number in
denominator.]
---------------------------------------------------------------------
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]
