https://bugs.documentfoundation.org/show_bug.cgi?id=158190
Bug ID: 158190
Summary: Calc ROUND() function issue in specific range
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
For math formula in ROUND() function:
1. If the integer is below 15 (inclusive) or above 25 (inclusive),
the result will be correct regardless of the decimal.
2. The integer part falls between 16 and 24. As long as the first
decimal is 3 or 8, the ROUND() function will not round.
But if ROUND a number but not formula, we can get correct result.
Steps to Reproduce:
1. Insert a number in a cell like description above (for example, 16.83 or
16.33)
2. Insert a number (that can be multiplied with step 1 to X.5) in another cell
3. Insert =ROUND(A1*B1,0) in another cell (multiply step 1 and step 2 number
and ROUND it)
Actual Results:
It seems to be rounding down (for example, ROUND(16.33*650) shows 10614)
Expected Results:
It should be rounding (for example, ROUND(16.33*650) should be 10615)
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 60(Build:1)
CPU threads: 8; OS: Linux 6.6; UI render: default; VCL: kf5 (cairo+xcb)
Locale: zh-TW (zh_TW.UTF-8); UI: zh-TW
7.6.2-3
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
