Bug 138016 - Bad calculation with substraction (- 0.1)
Summary: Bad calculation with substraction (- 0.1)
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-11-05 14:58 UTC by Frédéric PAUT
Modified: 2020-11-05 15:31 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
LibreOffice Calc calculation error (5.56 KB, image/png)
2020-11-05 14:58 UTC, Frédéric PAUT 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Frédéric PAUT 2020-11-05 14:58:42 UTC 
Created attachment 167037 [details]
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)
Comment 2 Frédéric PAUT 2020-11-05 15:31:58 UTC 
Ok, Thanks!