https://bugs.documentfoundation.org/show_bug.cgi?id=94394
Bug ID: 94394
Summary: Calculation Error: Possibly accumulation of small
floating-point errors
Product: LibreOffice
Version: 4.4.4.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: martinlbucha...@gmail.com
Created attachment 118888
--> https://bugs.documentfoundation.org/attachment.cgi?id=118888&action=edit
Personal finance tracking spreadsheet with personal info removed
Using a Calc ods spreadsheet to track personal finances, with a long series of
rows with a formula like =C59+A60-B60 (new balance = previous balance + any
money in minus any money out).
See cell C81 in the attachment re. the problem, showing that 1 minus 1 is
-2.08721928629529E-014 rather than 0.
If the spreadsheet is using floating-point, or (worse) single-precision
floating-point to represent numbers, the math needs to be done right so that
floating-point deltas (between visible numbers like 0.03 and the closest
floating-point representation) do not accumulate.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
