https://bugs.documentfoundation.org/show_bug.cgi?id=143772
Bug ID: 143772
Summary: Currency doesn't round properly in calculated fields
of Calc.
Product: LibreOffice
Version: 7.1.3.2 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: galdar1...@gmail.com
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
--
You are receiving this mail because:
You are the assignee for the bug.
