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

[Joel Madero]

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