[Libreoffice-bugs] [Bug 138016] New: Bad calculation with substraction (- 0.1)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138016
           Summary: Bad calculation with substraction (- 0.1)
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: fpaut at free.fr

Created attachment 167037
  --> https://bugs.documentfoundation.org/attachment.cgi?id=167037&action=edit
LibreOffice Calc calculation error

In the first Cell (A1) enter '2'
in cell A2, enter "=A1-0.1"
Drag A2 to estimate A3, A4, A5... and so on

Result:
A21=-6,38378239159465E-16 instead of 0

(Reproducible with Microsoft Excel)

-- 
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/20201105/7814f5e2/attachment-0001.htm>