Bug 152547 - Simple math error when subtracting number
Summary: Simple math error when subtracting number
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-12-16 13:28 UTC by Agente 80
Modified: 2022-12-16 13:45 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Subtraction error (54.85 KB, image/jpeg)
2022-12-16 13:28 UTC, Agente 80 		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 Agente 80 2022-12-16 13:28:24 UTC 
Created attachment 184184 [details]
Subtraction error

Hi, I found a serious bug in calc, when subtracting numbers
-Open new spread sheet
-Type this formula on a cell: =85,45-87,24
-The result will show -1,79, correct.
-Increase the decimal numbers showing, and it will be: -1,78999999999 !!!!

I noticed this with a lot of simple 2 decimal numbers math! 2 decimal numbers when added or subtracted should never ever generate a periodic decimal.

I was running Calc 7.4.2, then just updated to 7.4.3.2 Windows x64 (Windows 11 here), and this keeps happening
Comment 1 Mike Kaganski 2022-12-16 13:45:17 UTC 
FAQ: https://wiki.documentfoundation.org/Faq/Calc/Accuracy