Bug 142418

Summary: 1.2 - 1.1 = 0.09 ?
Product: LibreOffice Reporter: damontripodi
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: 79045_79045, aron.budea, damontripodi, himajin100000
Priority: medium    
Version: 7.1.3.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: calc sheet demonstrating issue
screenshot of issue

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.