Bug 160439

Summary: rounding error
Product: LibreOffice Reporter: Antônio <ajom>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal    
Priority: medium    
Version: 7.6.5.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description Antônio 2024-03-30 22:55:05 UTC 
Description:
rounding difference of the same number, if resulting from a sum operation

Steps to Reproduce:
1.a=195,755 (two decimal places= 195,76)
2.b=44,20
3.c=239,955 (two decimal places= 239,96)
4.add a + b and format to two decimal places

Actual Results:
239,95

Expected Results:
239,96


Reproducible: Always


User Profile Reset: No

Additional Info:
no more information
Comment 1 ady 2024-03-31 03:05:41 UTC 
This should be solved for the next LO versions:
* 7.6.7
* 24.2.3
* recent 24.8 alpha.

*** This bug has been marked as a duplicate of bug 160306 ***
Comment 2 JkUsr 2024-04-25 17:33:13 UTC 
I have the same problem, with a different calculation: 
#   Formula        Display
A1  100.3          100.3
A2  =A1*0.15       15.045
A3  =A2            15.04
A4  =ROUND(A2,2)   15.05

A3 have 0.00 Format Code, other cells have General format code.