<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 - Decimal precission fail in addition"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135103">135103</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Decimal precission fail in addition
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</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>javier.debian.bb.ar@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=163482" name="attach_163482" title="Calc failing spreadsheet">attachment 163482</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=163482&action=edit" title="Calc failing spreadsheet">[details]</a></span>
Calc failing spreadsheet
Fail in addition of the following numbers.
-33912
-30925
-25085
-23600
-20000
-9645
-9184,51
-6650
-5000
-4833,8
-4220
-4123,03
-3000
-3000
-2786
-2500
-2000
0
0
0,03
0,03
0,03
0,03
0,06
0,1
0,17
0,18
0,2
0,21
0,36
0,41
0,42
0,42
0,57
0,71
0,72
0,75
0,75
0,81
0,81
0,81
0,81
0,81
0,83
0,83
0,83
0,83
0,83
0,83
0,83
0,83
0,83
1
1,23
1,72
1,79
2,58
3,34
3,38
7,5
348,74
697,09
1049,63
1261,89
2094,46
2260
2556
2789,19
4944,24
5700
9644,91
9697,92
9800
11968,21
15150
20111,78
25225,2
31123,26
34058,33
The result given by de spreadsheet is 56,7200000000084
The result in the "SUM" total en the lower right corner is 56,7199999998993
The real result must be 56,72. It's make fail conditionals formulas.
System specifications:
# dmidecode
(...)
Processor Information
Socket Designation: Intel(R) Core(TM) i3-3240 CPU @ 3.40GHz
Type: Central Processor
Family: Core i7
Manufacturer: Intel
ID: A9 06 03 00 FF FB EB BF
Signature: Type 0, Family 6, Model 58, Stepping 9
# uname -a
Linux jap 4.19.0-9-amd64 #1 SMP Debian 4.19.118-2+deb10u1 (2020-06-07) x86_64
GNU/Linux
# dpkg -l libreoffice* | grep ii
ii libreoffice-avmedia-backend-gstreamer 1:6.1.5-3+deb10u6 amd64
GStreamer backend for LibreOffice
ii libreoffice-base 1:6.1.5-3+deb10u6 amd64 office
productivity suite -- database
ii libreoffice-base-core 1:6.1.5-3+deb10u6 amd64 office
productivity suite -- shared library
ii libreoffice-base-drivers 1:6.1.5-3+deb10u6 amd64
Database connectivity drivers for LibreOffice
ii libreoffice-calc 1:6.1.5-3+deb10u6 amd64 office
productivity suite -- spreadsheet
ii libreoffice-common 1:6.1.5-3+deb10u6 all office
productivity suite -- arch-independent files
ii libreoffice-core 1:6.1.5-3+deb10u6 amd64 office
productivity suite -- arch-dependent files
ii libreoffice-draw 1:6.1.5-3+deb10u6 amd64 office
productivity suite -- drawing
ii libreoffice-gtk3 1:6.1.5-3+deb10u6 amd64 office
productivity suite -- GTK+ 3 integration
ii libreoffice-help-common 1:6.1.5-3+deb10u6 all office
productivity suite -- common files for LibreOffice help
ii libreoffice-help-en-us 1:6.1.5-3+deb10u6 all office
productivity suite -- English_american help
ii libreoffice-help-es 1:6.1.5-3+deb10u6 all office
productivity suite -- Spanish help
ii libreoffice-impress 1:6.1.5-3+deb10u6 amd64 office
productivity suite -- presentation
ii libreoffice-java-common 1:6.1.5-3+deb10u6 all office
productivity suite -- arch-independent Java support files
ii libreoffice-l10n-es 1:6.1.5-3+deb10u6 all office
productivity suite -- Spanish language package
ii libreoffice-math 1:6.1.5-3+deb10u6 amd64 office
productivity suite -- equation editor
ii libreoffice-report-builder 1:6.1.5-3+deb10u6 all
LibreOffice component for building database reports
ii libreoffice-report-builder-bin 1:6.1.5-3+deb10u6 amd64
LibreOffice component for building database reports -- libraries
ii libreoffice-sdbc-firebird 1:6.1.5-3+deb10u6 amd64
Firebird SDBC driver for LibreOffice
ii libreoffice-sdbc-hsqldb 1:6.1.5-3+deb10u6 amd64 HSQLDB
SDBC driver for LibreOffice
ii libreoffice-sdbc-postgresql 1:6.1.5-3+deb10u6 amd64
PostgreSQL SDBC driver for LibreOffice
ii libreoffice-style-colibre 1:6.1.5-3+deb10u6 all office
productivity suite -- colibre symbol style
ii libreoffice-style-tango 1:6.1.5-3+deb10u6 all office
productivity suite -- Tango symbol style
ii libreoffice-writer</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>