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
Created attachment 183985 [details] Problem spreadsheet - ODS converted from the old Excel format
I found a completely blank line in the middle of the data (row 141) that seemed to be causing the issue. Maybe user error... I suppose you can keep this open or close as you see fit.
closing this per user comments. this seems more to be a user error rather than actual issue. hence closing as "RESOLVED" - "NOTABUG"