<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 - Surprizing result from ROUND()"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131246">131246</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Surprizing result from ROUND()
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.5.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>stasinos@konstant.gr
</td>
</tr></table>
<p>
<div>
<pre>Description:
For a particular cell, ROUND(5.5) gives 5 instead of 6. I tried seeing more
decimal digits in case the number is a 5,499999999, but it is a clear 5.5.
If I perform the same calculation in a different cell, the result is as
expected.
The file was originally created on MS Excel, and then edited and saved in
LibreOffice as an xlsx. If saved as an ods, the error disappears.
Steps to Reproduce:
Open the attahed file.
See sheet3
Actual Results:
ROUND(5.5) gives 5
Expected Results:
ROUND(5.5) should give 6.
It does give 6, except for that particular cell.
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 6.1.5.2
Build ID: 1:6.1.5-3+deb10u3
CPU threads: 6; OS: Linux 4.19; UI render: default; VCL: gtk3_kde5;
Locale: en-US (en_US.UTF-8); Calc: group threaded</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>