Description:
When I do some major calculations involving currency, the stated currency is correct, however, when adding two cells together based upon a formula, it used the non-currency amount to add them which results in a penny difference. If I used the ROUNDUP function, it gives the correct result.

Steps to Reproduce:
1. Calculated value that is $1.46 is added to a calculated value of $4809.69.
2. Actual decimal value of $1.46 is $1.45506815
3. Actual decimal value of $4809.69 is $4809.68880000
4. Resulting addition should be $4,811.14386815.
5. Limiting the decimal places to both values to 2 places as in standard currency gives the values $1.46 and $4809.69 respectively, which is the correct rounding.
6. However, in adding the two values, it calculate them to $4811.14 off of the NON-truncated 2 decimal place currency value, when it should calculate them to $4811.15.
7. If I use the ROUNDUP function on the calculated value, it displays correct, but as currency values, the decimal places allowed should be the amounts summed, not the non-truncated values.

Actual Results:
$1.46 + $4809.69 = $4811.14 when it should be $4811.15.

Expected Results:
$1.46 + $4809.69 = $4811.14 when it should be $4811.15.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.3.2 (x64) / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded