Bug 47793

Summary: : Wrong calcul.
Product: LibreOffice Reporter: Artimon Esya <elfen-lied-utaite>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG QA Contact:
Severity: normal    
Priority: medium    
Version: 3.5.1 release   
Hardware: Other   
OS: All   
Whiteboard: BSA
i915 platform: i915 features:

Description Artimon Esya 2012-03-23 23:11:37 UTC
Problem description:
0,443 - 0,443 = -1,2E-014

Steps to reproduce:
1. Enter in A1: 3,559
2. Enter in A2: 0,443
3. Enter in A3: 219,869
4. Enter in A4: =A1+A3
5. Enter in A5: =A2+A4
6. Enter in A6: =A5-A4
7. Enter in A7: =A2-A6

Product:
1. LibreOffice v3.5.1.2 on Win7
2. OpenOffice v3.3 on WinXP
Comment 1 vitriol 2012-03-23 23:16:56 UTC
Classic floating-point approximations behavior. Not a bug for me...
Comment 2 Artimon Esya 2012-03-23 23:33:55 UTC
I hadn't known it, sorry.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.