Bug 142418 - 1.2 - 1.1 = 0.09 ?
Summary: 1.2 - 1.1 = 0.09 ?
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-05-22 03:22 UTC by damontripodi
Modified: 2021-07-16 14:27 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
calc sheet demonstrating issue (10.81 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-05-22 03:23 UTC, damontripodi 		Details
screenshot of issue (46.49 KB, image/png)
2021-05-22 03:31 UTC, damontripodi 		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 damontripodi 2021-05-22 03:22:41 UTC 
Description:
1.2 - 1.1 = 0.09 ?



Steps to Reproduce:
1. enter  1.2
2. enter -1.1
3. sum above

Actual Results:
0.09

Expected Results:
0.1


Reproducible: Always


User Profile Reset: No



Additional Info:
does not occur with 0.2 - 0.1
Comment 1 damontripodi 2021-05-22 03:23:51 UTC 
Created attachment 172240 [details]
calc sheet demonstrating issue
Comment 2 damontripodi 2021-05-22 03:31:21 UTC 
Created attachment 172241 [details]
screenshot of issue
Comment 3 Roman Kuznetsov 2021-05-22 07:45:54 UTC 
no repro in

Version: 7.1.1.2 (x64) / LibreOffice Community
Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL


nor in

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: dbd4110cc36011042c98549d997daa79e8065aba
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL
Comment 4 Roman Kuznetsov 2021-05-22 07:52:50 UTC 
(In reply to Roman Kuznetsov from comment #3)
> no repro in
> 

ah, you wrote one description, but in your files we have other numbers

It's known problem, for example we tried solve it in bug 137679 and in bug 142307
Comment 5 Aron Budea 2021-07-15 23:01:29 UTC 
This inherently comes from using floating point numbers, please refer to this FAQ: https://wiki.documentfoundation.org/Faq/Calc/Accuracy
Comment 6 damontripodi 2021-07-16 01:33:25 UTC 
Inherently wrong is still wrong
Comment 7 Aron Budea 2021-07-16 14:27:06 UTC 
You can use the ROUND function, or set the number of decimal places to be displayed to something small.