<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: funny / odd / wrong display of value in scientific format"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131312">bug 131312</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;">Version</td>
<td>6.2.8.2 release
</td>
<td>Inherited From OOo
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - calc: funny / odd / wrong display of value in scientific format"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131312#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - calc: funny / odd / wrong display of value in scientific format"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131312">bug 131312</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>@Regina: yeah, thanks, i think it's the same bug,
an old bug again :-(
still unresolved in AOO?
already buggy in LO 4.1.6.2, setting to 'inherited from OOo',
could someone check in linux please?
looks as if
correct display 'til:
1-7,21644966006352E-016,
wrong display starting with:
1-7,21644966006351E-016,
wrong display 'til:
1-6,10622663543837E-016,
display correct again starting with:
1-6,10622663543836E-016
in IEEE 754 notation (sign(1) - exp(11) - mantissa(52)):
0 0 1111111110 11 1111111111 1111111111 1111111111 1111111111 1111111001 holds,
0 0 1111111110 11 1111111111 1111111111 1111111111 1111111111 1111111010 fails,
0 0 1111111110 11 1111111111 1111111111 1111111111 1111111111 1111111011 holds,
same for negative values,
1 0 1111111110 11 1111111111 1111111111 1111111111 1111111111 1111111010 fails,
binary formula to construct affected value: '=(1+(1-2^-52)-2^-50-2^-52)*2^-1'
wrong display occuring in a range of +/- 2^-53 around this value,
sometimes values are shown correct after load of file (despite 'recalc on load'
not! being set), but become wrong after re-entering the formula,
sorry for assumptions, it's not sure to be a LO bug, might also result from:
- intel (hardware),
- intel (software / library),
- gnu c++,
- gnu c++ compiler options (i've seen a site saying that performance options
have evil affect on fp precision ...)
[we have two of ~ 1,843*10^19 values producing a misrepresentation, and i have
to stumble upon one of them ... who has given me this 'talent'? and why?]</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>