<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 - incorrect calculation result"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139095">139095</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>incorrect calculation result
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</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>pharmholz@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
I have a ODS file where I weekly put the recent status of my accounts and
investment portfolios. So I can check how they develop.
But when I calculate the difference of two weeks after I used the "sum"
function it shows a very small difference. Calc does not calculate correctly.
For example this week it is: 24852,02 - 24427,97 = 424,0500000000003 instead of
424,05 but I don't actually type in the numbers I refer to the cell like =
B167-B158 and within these cells I used =Summe(...:...)
As it is an overview of my bank accounts and investment portfolios I only use
two digit numbers.
I don't know where this problem comes from.
Steps to Reproduce:
1. set up two different tables with various numbers like an overview of your
accounts and you want to check how they develop
2. use the summerize function under both tables
3. calculate the difference of both sum ups
Actual Results:
424,0500000000003
Expected Results:
424,05
Reproducible: Always
User Profile Reset: No
Additional Info:
nothing</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>