https://bugs.freedesktop.org/show_bug.cgi?id=70251

          Priority: medium
            Bug ID: 70251
          Assignee: [email protected]
           Summary: Calculation: extra decimals added on simple
                    addition/subtraction
          Severity: major
    Classification: Unclassified
                OS: Windows (All)
          Reporter: [email protected]
          Hardware: x86-64 (AMD64)
            Status: UNCONFIRMED
           Version: unspecified
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 87253
  --> https://bugs.freedesktop.org/attachment.cgi?id=87253&action=edit
As per description cell D21 with value 1580= wrong result but OK with 1580,99

While doing simple addition and subtraction of numbers (all directly entered
via keyboard with maximun two decimal digits), the spreadsheet suddenly reports
results with active decimal digits in the 8th position. This while doing simple
additions and subtractions.

In the attached file if you place the value 1580 in cell D21 the result of the
addition in cell J21 contains 0,000000068..... On the other hand if you use
1580,99 in cell D21 the resulting calculation is correct! Same thing in row 29.

LibreOffice in Italian: Versione 4.0.5.2 (Build ID:
5464147a081647a250913f19c0715bca595af2f)

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to