Bug 161840 - Subtraction result wrong
Summary: Subtraction result wrong
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.0.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-06-29 19:46 UTC by kapikapitosca
Modified: 2024-06-29 20:12 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Example of the described (9.62 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-06-29 19:50 UTC, kapikapitosca 		Details
png of the error (13.80 KB, image/png)
2024-06-29 19:51 UTC, kapikapitosca 		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 kapikapitosca 2024-06-29 19:46:41 UTC 
Description:
if i make a subtraction of =7507.65-7149.39 
the result is 358.259999999999
This happens when no formatting is present as when in number or coin format the subtraction is done correctly

Steps to Reproduce:
1.Remove all formatting from cell
2.insert =7507.65-7149.39
3.observe the incorrect result of 358.259999999999

Actual Results:
I observed the subtraction done incorrectly.

Expected Results:
the expected result would be 358.26


Reproducible: Always


User Profile Reset: No

Additional Info:
It should just work...
Comment 1 kapikapitosca 2024-06-29 19:50:21 UTC 
Created attachment 195050 [details]
Example of the described
Comment 2 kapikapitosca 2024-06-29 19:51:50 UTC 
Created attachment 195051 [details]
png of the error
Comment 3 Mike Kaganski 2024-06-29 20:12:45 UTC 
FAQ: https://wiki.documentfoundation.org/Faq/Calc/Accuracy