Bug 69807 - LO Calc - Floating point substraction error while propagating cell values
Summary: LO Calc - Floating point substraction error while propagating cell values
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.2.2 release
Hardware: x86 (IA32) Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 91342 (view as bug list)
Depends on:
Blocks:
 
Reported: 2013-09-25 11:11 UTC by Marcin
Modified: 2020-10-08 15:24 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
a sample of better results, see comments in sheet (26.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-10-08 15:24 UTC, b.
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Marcin 2013-09-25 11:11:18 UTC
1) Reproduce error:
Write 1 in cell A1.
Write 0,9 in cell A2.
Select two previously filled cells, hover the cursor over the cell's lower right corner and drag down.

2) Error:
In cell where should be zero, will be value other than zero (here 2,22044604925031E-016).
Comment 1 m_a_riosv 2013-09-25 22:01:36 UTC
I think you can find an accurate explanation here:
http://en.wikipedia.org/wiki/Floating_point#Accuracy_problems
Comment 2 Joel Madero 2013-11-15 22:02:47 UTC
Yes this has been reported a lot of times and all of our expert developers say it's not a bug. Closing as NOTABUG
Comment 3 Buovjaga 2015-04-22 14:01:07 UTC
*** Bug 68448 has been marked as a duplicate of this bug. ***
Comment 4 Buovjaga 2015-05-19 11:23:30 UTC
*** Bug 91342 has been marked as a duplicate of this bug. ***
Comment 5 b. 2020-10-08 15:24:55 UTC
Created attachment 166198 [details]
a sample of better results, see comments in sheet

something is changed, in ver 7.1 '0' displays '0', but other values have small inaccuracies ... 

as mathematically incorrect and as better results are! possible - see attachement - i'd say bug.