<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Sum Total ignoring changes in client cells if they are formatted to hide decimals."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116918">bug 116918</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Sum Total ignoring changes in client cells if they are formatted to hide decimals."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116918#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Sum Total ignoring changes in client cells if they are formatted to hide decimals."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116918">bug 116918</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>So, as you show on your screenshot, the "Precision as shown" is indeed
selected. Thus, Calc uses numbers *as displayed in cells* for further
calculations. If you show a subtotal as a whole number, and then use it in
calculations of total, it's expected to behave as you describe. Unselect the
option to resolve the issue. In general, I'd not use it. If you need some
values to have limited precision, use ROUND.
Closing NOTABUG.</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>