Bug 144528 - EDITING: simple substraction formula is leading to a strange result
Summary: EDITING: simple substraction formula is leading to a strange result
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.0.4 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-16 06:46 UTC by casimir374
Modified: 2021-09-16 07:06 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.