<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - calc: calculation: statusbar, auto-sum irrit. results, different from sheet reg. rounding and ordering of operands | was: Statusbar sum and average calculation with decimal values equivalent to zero sometimes shows incorrect negative exponential value"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109189">bug 109189</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;">Summary</td>
<td>Statusbar sum and average calculation with decimal values equivalent to zero sometimes shows incorrect negative exponential value
</td>
<td>calc: calculation: statusbar, auto-sum irrit. results, different from sheet reg. rounding and ordering of operands | was: Statusbar sum and average calculation with decimal values equivalent to zero sometimes shows incorrect negative exponential value
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - calc: calculation: statusbar, auto-sum irrit. results, different from sheet reg. rounding and ordering of operands | was: Statusbar sum and average calculation with decimal values equivalent to zero sometimes shows incorrect negative exponential value"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109189#c9">Comment # 9</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - calc: calculation: statusbar, auto-sum irrit. results, different from sheet reg. rounding and ordering of operands | was: Statusbar sum and average calculation with decimal values equivalent to zero sometimes shows incorrect negative exponential value"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109189">bug 109189</a>
from <span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span></b>
<pre>the effects are neither limited to
'decimal values equivalent to zero'
nor to
'incorrect negative exponential value'
changing subject,
proof:
1,797693134862315500E+308
-1,797693134862315500E+308
3,995840309534720000E+291
summed in a sheet results in
0,000000000000000000E+000 (cancellation) while the statusbar shows
3,995840309534720000E+291 (different ordering of operands, no cancellation),
putting the small value above the others changes results between sheet and
statusbar,
keying
-2,9937604643020793E+292 in a cell shows
-2,9937604643020800E+292 (rough rounding), keying
2,9937604643020800E+292 in a cell beneath and summing up results in
0,0000000000000000E+000 in the sheet, and
8,8633114604817800E+276 in the statusbar</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>