Bug 101675 - EDITING : Calculation error (visible only if you enlarge cells)
Summary: EDITING : Calculation error (visible only if you enlarge cells)
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.0.4 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-08-22 21:11 UTC by bubu
Modified: 2016-09-22 08:43 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Calculation bug with LO 5.2.x (8.56 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-08-22 21:11 UTC, bubu 		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 bubu 2016-08-22 21:11:56 UTC 
Created attachment 126978 [details]
Calculation bug with LO 5.2.x

LibreOffice 5.2.X (Mac OS X, Windows 10)


Cell A1 : 28217.28
Cell A2 : 28409.90
Cell B2 : = A2-A1

Result displayed in B2 : 192,62.

So everything seems OK, but if you enlarge colomn B, you'll see result displayed in B2 cell is 192,620000000003 !!!!

Very strange and annoying bug.
Comment 1 Buovjaga 2016-09-22 08:43:51 UTC 
Comment from Eike on IRC: "normal floating point accuracy problem; if in doubt compare with Gnumeric"

Closing.