https://bugs.documentfoundation.org/show_bug.cgi?id=96406
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED CC| |[email protected] | |rg Resolution|--- |NOTABUG --- Comment #2 from m.a.riosv <[email protected]> --- I think the issue usually occurs with numbers that are periodic in binary base, so doing operations on them results on the precision problems. If you set up 15 decimal places for the all cell's format, you can see that C27 is different than B27 on the last decimals. The precision in calc is fifteen numbers plus sign, and this is a hardware limitation. https://bugs.documentfoundation.org/show_bug.cgi?id=50299 take special attention to comments 4 and 6 of Kohei, one of the most expert developers with calc. Combining the MM mentioned option with 12 decimal places, with Menu/Tools/LibreOffice calc/Calculate - Precision as Shown seems to work fine in this case. What usually for accounting purposes it's enough precision. Please if you are not agree with resolution, reopen it. -- 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
