https://bugs.freedesktop.org/show_bug.cgi?id=78721
Tomaz Vajngerl <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #1 from Tomaz Vajngerl <[email protected]> --- This is not a bug - it is expected because binary representation of real decimal numbers is not exact. Look at [1] and [2] for detailed explanation. Your formula also uses the result from the previous calculation, which just increases the error. Now to overcome this you have to round the result to expected number of digits. In your example you have to modify the formula to: =ROUND(C1+0,05; 2) Round to 2 decimal places.. Regards, Tomaž [1] https://bugs.freedesktop.org/show_bug.cgi?id=69807 [2] http://ask.libreoffice.org/en/question/8006/libreoffice-calc-calculation-error/ -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
