<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 - UI: numerical string in formula bar (input line) and cell editing truncated (to 20 digits)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139306">139306</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>UI: numerical string in formula bar (input line) and cell editing truncated (to 20 digits)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.1.0.0.alpha0+
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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:
keying in '6,74316406210E-11' in a cell produces appr. display, but the input
line shows '0,00000000006743164062' omitting the last digit '1',
affecting plenty other figures in that range as well, only down from x,yE-15
the format for input line and cell edit change to scientific format and present
all digits for editing,
(assumption: somehow related to the number format limited to 16 significant
digits and 4 fake zeroes, but in the past it was a 'relative' restriction and
figures as '6,7431640621000E-12' could be handeled and edited starting with the
'real value', now it's an 'absolute' limit and everything behind the 20th
decimal digit is chopped for the input line, for cell edit and e.g. copy and
paste to other versions of calc, pasting to e.g. notepad works with more
digits)
Steps to Reproduce:
1. key '6,74316406210E-11' into a cell,
2. hit enter
3. observe input line showing truncated / rounded value,
4. start editing the cell with 'F2',
5. observe presented value for edit being truncated / rounded as well,
Actual Results:
truncated / rounded string used,
Expected Results:
full string or 'E-format'-string with all digits presented and editable,
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.2.0.0.alpha0+ (x64)
Build ID: 35e471bb4d1388cf5afcdcee214cf5111edf44e3
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc:</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>