Hi All, On 06/30/2014 01:49 PM, Jean-Baptiste Faure wrote: > Hi, > > Le 30/06/2014 02:13, m.a.riosv a écrit : >> Hi, >> >> maybe could be of interest comments #4 and #6 of Kohei in bug >> >> MOD shows not existing small remainder with calculated Dividend >> <https://bugs.freedesktop.org/show_bug.cgi?id=50299#c4> > Indeed, but in some particular cases, rounding errors may have > disastrous effects. > For example, again on MOD() function: > https://bugs.freedesktop.org/show_bug.cgi?id=80732 > > Rounding errors are acceptable if they remain (very) small. If they are > not, something should be done. > > Another very clear case is the following: > - type 0.1 in A1 > - in A2 type =A1*11-1 > - propagate the formula to A30 > Enjoy ;-) This is indeed well known and Kohei has explained why it happens (quite a few times). The logic is beyond my comprehension but I trust his judgment 110% and he has said it is really unfixable. I believe we have closed at least 5 similar bugs in the past year.
Best, Joel _______________________________________________ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
