<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - calc: funny / odd / wrong display of value in scientific format"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131312">131312</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>calc: funny / odd / wrong display of value in scientific format
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.8.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>newbie-02@gmx.de
</td>
</tr></table>
<p>
<div>
<pre>Description:
while playing around with floating point values i stumbled upon a funny display
problem, it looks as if the value is correct, but in display with 14+ decimal
places it's displayed as
10,00000000000000E+00 instead of - correct -
1,00000000000000E+00
the error dosn't survice save-load but is reproducible, just follow steps
below,
don't think over the formula etc., it's an unfinished version,
the error can be copied by ctrl-c ctrl-shift-v to other cells, copy text,
numbers, date&time,
Steps to Reproduce:
1. open attached file (if not in this description see next comment)
2. observe cell BO2, reg. save-load it'll display 1,00000000000000E+00
2a. same for cell BO4, which is two step copy of BO2
3. click on cell BO2
4. F2
5. ctrl-a
6. ctrl-c
7. ctrl-v - enter
8. observe BO2 now displaying 10,00000000000000E+00,that's 10 times too much,
8a. same for BO4
8b. BO3 not affected
9. shrink display of BO2 to 13 decimals
10. observe display now 1,0000000000000E+00
11. enrich display to 14 decimals or more
12. observe value shown as 10,00... istead of 1,00...
13. observe cell BO3, formula '=BO2', displaying 1,00000... regardless of wrong
display for BO2,
14. observe cell BO4 having the same 'illness' as BO2, wrong display up from 14
decimals,
15. play around as you like, the error occured only for specific mantissae all
zeros ending on ...110 or ...101, sometimes you don't need to paste BO2 but
it's sufficient to change the last two bits of the mantissa ... the behaviour
is a little different with a different formula, copy e.g. BO8 to BO2, have fun
...
Actual Results:
cells displayed with 10 times too high value and 'ill' formatting up from 14
decimal places,
Expected Results:
correct results,
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.2.8.2 (x64)
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win;
Locale: de-DE (de_DE); UI-Language: en-US
Calc:
actual 7.0.0.0.a0+ fails too ...</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>