[Libreoffice-bugs] [Bug 135103] New: Decimal precission fail in addition

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=135103

            Bug ID: 135103
           Summary: Decimal precission fail in addition
           Product: LibreOffice
           Version: unspecified
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: javier.debian.bb.ar at gmail.com

Created attachment 163482
  --> https://bugs.documentfoundation.org/attachment.cgi?id=163482&action=edit
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200724/2a984604/attachment.htm>