https://bugs.documentfoundation.org/show_bug.cgi?id=167653
Bug ID: 167653
Summary: Subtraction operation in Calc results in inaccurate
values in column filter list
Product: LibreOffice
Version: 25.2.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Calculating decimal values using the subtraction function results in
imprecision when filtering the values in the results cells. This imprecision is
not present with an addition operation.
Steps to Reproduce:
1. Open the attached .ods document.
2. Click the filter arrow at the top of the "diff" column.
3. Observe that the filter shows imprecise result values. The filter results
are also included as a screenshot.
Actual Results:
The result column contains imprecise values. This suggests that Calc is using
float instead of decimal math for subtraction operations.
Expected Results:
The filter column should only contain 0, 0.05, 0.1, 0.15, and #VALUE!
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022
CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19045); UI render:
Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
Rounding the results to two decimal places removes the incorrect results, but
expected behavior for users is to display accurate results without a
workaround.
This bug occurred on a fresh installation of LibreOffice with no user profile
changes.
--
You are receiving this mail because:
You are the assignee for the bug.
