<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Calc Math error on INTEGER function"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133840#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Calc Math error on INTEGER function"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133840">bug 133840</a>
from <span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span></b>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=165422" name="attach_165422" title="test_mod_save_against_fp-rounding_errors">attachment 165422</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=165422&action=edit" title="test_mod_save_against_fp-rounding_errors">[details]</a></span>
test_mod_save_against_fp-rounding_errors
besides that i'd read somewhere that gcc has! a 'decimal' library, and thus
implementing correct decimal math shouldn't be too big an issue ...
(ok, 'performance', but plenty sheets are 'small', and most performance
problems can be thrown on hardware today, the hours and days that users and
supporters waste with irritations about fp-rounding-issues are in my opinion
much worse than a few microseconds of computing time)
... i was curious if it is possible to solve some of the FP problems with
'intelligent rounding', here is my first try, not a solution, just an attempt
of a proof of concept,
the user defined macro function 'mod_s' rounds the result acc. to the decimal
places of the values, and returns a better result for
'=INT(MOD_S(11.09,0.1)*100)' than the standard 'mod' of calc with
'=INT(MOD(11.09,0.1)*100)' does,
i'm not! sure if this works for all cases / values, i didn't even code or test
it with fractional modulators in mind, it was tricky enough to get it to work
because in calc not even 'mod' in formulas is compatible with 'mod' in basic
macros :-( , it is 'unfinished work', i just want to 'throw it to the people'
for examination and discussion ...</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>