Bug 144528

Summary:	EDITING: simple substraction formula is leading to a strange result
Product:	LibreOffice	Reporter:	casimir374
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal
Priority:	medium
Version:	7.2.0.4 release
Hardware:	x86 (IA32)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description casimir374 2021-09-16 06:46:11 UTC

Description:
I tried to  perform following  formula:
=16.068-16.366
expected result
-0.298
Result received
-0,297999999999998



Steps to Reproduce:
1. enter formular =16.068-16.366
2. add decimal 
3.

Actual Results:
-0,297999999999998

Expected Results:
-0.298000000000000


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
calculate exactly

Comment 1 Mike Kaganski 2021-09-16 07:06:09 UTC

This is not a bug. Please see FAQ:

https://wiki.documentfoundation.org/Faq/Calc/Accuracy

Thanks for filing! No matter how the report is closed, it is useful.