<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <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#c3">Comment # 3</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 <a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> b.</a> <pre>there is an easier way to reproduce: the value which is erroneously presented is: '1' that's what the mantissa values should - nearly - add up to, minus '2^-52' (for the missing terms 2^-53, 2^-54, 2^-55 ... of the mantissa, in infinite they should add up to 2^-52), minus '2^-51', that's the bit not set in the sample, thus '1 - 2^-52 - 2^-51' should be the same value, and might show the same weakness when displayed in scientific format, and, voila, it does. easy reproducer: copy and paste '=1 - 2^-52 - 2^-51' in a cell, without the quotes, and then set the format to 'scientific' with 14 or more decimal places. fault: with ver. 6.2.8.2 and 7.0.0.0.a0+ : display of 10,00000000000000E+00 (my assumption - sorry @Eike - somewhere a '< vs. <=' or '> vs. >=' error ... in the code to format the display) i saw some other issues with bits from the mantissa having no effect on the fraction or final value, i'll ask for that in 'ask' first. reg. b.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>