https://bugs.documentfoundation.org/show_bug.cgi?id=161457
Bug ID: 161457
Summary: Autofilter result is wrong when cells contain
formatted rounded values
Product: LibreOffice
Version: 24.8.0.0 alpha1+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: bibisectRequest, regression
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 194587
--> https://bugs.documentfoundation.org/attachment.cgi?id=194587&action=edit
test doc
THIS IS DEVASTATOR! Autofilter is useless for my daily work with this bug, it
makes autofilter unreliable at all!
Steps to Reproduce:
1. Open the attached test document.
2. In column "COGS Account", deselect "R&D Expenditure" in the autofilter
dropdown.
3. In column "Period", select "2021-01" only (i.e. deselect "2021-03").
4. Click the autofilter dropdown in column "Ending Value".
Expected Result:
The filtered result contains a "1.00" and a "0.00", thus both "1.00" and "0.00"
should appear in the autofilter dropdown list.
Current Result:
Only "1.00" shows up in the dropdown. "0.00" is inactive and deselected.
This works in Version: 7.4.7 (when the "show inactive/hidden autofilter
entries" feature was not added), but broken on master, build ID
b860aea9d6f8ac46f6d2575ead25337495ec9a88. Also broken in version 7.6.7.
--
You are receiving this mail because:
You are the assignee for the bug.
