<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Decimal precision fail in addition" href="https://bugs.documentfoundation.org/show_bug.cgi?id=135103#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Decimal precision fail in addition" href="https://bugs.documentfoundation.org/show_bug.cgi?id=135103">bug 135103</a> from <a class="email" href="mailto:javier.debian.bb.ar@gmail.com" title="Javier <javier.debian.bb.ar@gmail.com>"> Javier</a> <pre>(In reply to Michael Warner from <a href="show_bug.cgi?id=135103#c2">comment #2</a>) > (In reply to Mike Kaganski from <a href="show_bug.cgi?id=135103#c1">comment #1</a>) > > <a href="https://wiki.documentfoundation.org/Faq/Calc/Accuracy">https://wiki.documentfoundation.org/Faq/Calc/Accuracy</a> > > I understand the limitations of IEEE754, and why this is a frequently asked > question. That said, one could argue that it would be more user friendly if > the formatting of a cell containing an equation (and the sum in the corner) > defaulted to the number of decimal places shown to the minimum (or maximum) > number of decimal places entered in any referenced cell containing a number. > In the example provided, it just doesn't make sense to display a result to > 14 places when at most 2 are provided. That's one of the problems. If your boss see this, probably he doubt about yours skills. The other problem, every conditional must be formated before each calculation, like =IF( ROUND( (<cell with 31000.99> - <cell with 32000.12>;2) = ROUND( <cell with -999.13>;2); "OK"; "FAIL" ) ); That's a very heavy issue, a lot of time, memory, CPU resource, bugs, etc.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>