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