<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><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#c6">Comment # 6</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 <span class="vcard"><a class="email" href="mailto:michael.warner.ut+libreoffice@gmail.com" title="Michael Warner <michael.warner.ut+libreoffice@gmail.com>"> <span class="fn">Michael Warner</span></a>
</span></b>
<pre>(In reply to Mike Kaganski from <a href="show_bug.cgi?id=135103#c3">comment #3</a>)
<span class="quote">> (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"?</span >
I'm not telling you you "need" to do anything. I can't tell you what to do.
<span class="quote">>
> 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.</span >
Difficult to get it right in all cases, but we might be able to get 80% of them
right for 20% of the effort. I don't know, it was just a thought. Ignore it if
you don't like it, I think I'm done with this thread.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>