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 ;-) Best regards. JBF -- Seuls des formats ouverts peuvent assurer la pérennité de vos documents. _______________________________________________ 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/