<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#c3">Comment # 3</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:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> <pre>(In reply to Michael Warner from <a href="show_bug.cgi?id=135103#c2">comment #2</a>) > 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 is over-simplification. So for this formula: > = <cell with 1> + <cell with 10> ^ <cell with -5> all cells are shown with default formatting; all are whole numbers. Are you telling we need to show "1" instead of "1.00001"? It's very difficult to come with a reasonable default precision (and analyzing the formula, taking into account display format, with its optional digits "#", display of multiples of 1000, scientific notation, percents, etc, may be very expensive and error-prone); IIRC Eike ~recently changed the default to "show as many as fit in column", but I may be wrong.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>