<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 - When a column's width is increased, the subraction-result in it is off by a little."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126882">126882</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>When a column's width is increased, the subraction-result in it is off by a little.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.5.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>IA64 (Itanium)
</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>multipartite@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=153345" name="attach_153345" title="A spreadsheet with a selection of subtractions showing the problem.">attachment 153345</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=153345&action=edit" title="A spreadsheet with a selection of subtractions showing the problem.">[details]</a></span>
A spreadsheet with a selection of subtractions showing the problem.
To reproduce:
Make a new spreadsheet.
In A1, put '121.1'
In B1, put '120.3'
In C1, put '=A1-B1'
Increase C1's column width to 3.23cm.
C1 now displays 0.799999999999997, which it should not.
Decrease C1's column width to 3.22cm.
C1 now displays 0.8, which it should.
If 'Format Cells' is used to set the number of decimal places to 15 or greater,
the tenths-place will never show an 8.</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>