[Libreoffice-qa] fdo#80638 "Incorrect SUM with decimal numbers"

[Jean-Baptiste Faure]

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.