Bug 160439 - rounding error
Summary: rounding error
Status: RESOLVED DUPLICATE of bug 160306
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-03-30 22:55 UTC by Antônio
Modified: 2024-04-25 17:33 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
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 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.