https://bugs.documentfoundation.org/show_bug.cgi?id=152369
Bug ID: 152369
Summary: FILTER: AutoFilter is missing values and showing
values not in the filter
Product: LibreOffice
Version: 7.4.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I tried applying AutoFilter to a spreadsheet and noticed that it is missing
many values in the filter dropdown and also displaying rows for values that I
didn't select.
In column AX (Price), the filter does not have values which appear in the
column as options, e.g. 20, 30, 50, 65, 70...
If I choose only the values 90 and 100 in the filter, for some reason it is
showing a lot more, e.g. rows with 120, 270, 300, 400, 750...
There are other problematic columns too. Column AE is only has filter options
'x' and 5000, but should have 250, 1000, 800.
I see no rhyme or reason as to what is going on here.
NB: I didn't create the spreadsheet. It is from an online source, so I'm not
sure if there is something strange in the way it was set up.
Steps to Reproduce:
1. Open the attached spreadsheet
2. Select the filter dropdown for column AX
3. Select values 90 and 100
4. Click OK
Actual Results:
There were no options to select values 50 (row 156), 60 (row 154) and rows with
values 300 (row 142), 270 (row 143), 230 (row 144), 200 (row 145) in column AX
are displayed
Expected Results:
I would expect values 50 and 60 and a lot of other values which were missing to
be displayed in the filter selection values and when I do filter to rows 90 and
100, I would expect only those rows to appear.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.4.3.2 (x64) / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 12; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
