Description: When are there blank rows in the file, autofilter shows only show only the cells before the first blank row. The data after the emptity row is not considered. Steps to Reproduce: 1.Create a new file; 2.In the first column and first line set a title like "Sample"; 3.In the second line type "A"; 4.In the third line type "B"; 5.Let the fourth line empty; 6.In the fifth line type "C"; 7.Apply autofilter in the first column; 8.Open the filter options; Actual Results: "C" does not appear. Expected Results: "C" should appear. Reproducible: Always User Profile Reset: No Additional Info:
Thank you for reporting the bug. it seems you're using an old version of LibreOffice. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
not reproducible with Version: 6.2.5.2 (x64) Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: de-DE (de_DE); UI-Language: en-US Calc: if the filter range contains empty rows, you need to tell LO the range: - select A1:A5 or - select column A before apply autofilter you can also use Menu Data/Define Range... to name the filter range
(In reply to Guilherme from comment #0) > 7.Apply autofilter in the first column; I guess reporter applied autofilter with cursor in cell with "A" or "B", without selecting all desired cells or column A. I confirm the behavior but set as bug not to change it, just to improve Documentation. Help https://help.libreoffice.org/7.1/en-US/text/scalc/01/12040100.html (that opens with F1 on AutoFilter menu item) says "Automatically filters the selected cell range...". It should explain what autofilter does if selected is column, cells or cell, also if range contains empty cells or if below cells are filled after filter was made. Link https://help.libreoffice.org/7.1/en-US/text/scalc/guide/autofilter.html also doesn't explain that.
While testing bug 119949 (where attachment 144970 [details] is created in this way) I noticed a nice trick: If Autofilter is defined but some rows were filled after (so they will not be included in the filter), click on Autofilter (menu command or toolbar icon) will not turn off the filter, it will keep it but with expanded selection to include also additional rows.
There's advanced way of using autofilter that I don't see explained or linked if using help with F1. Per https://bugs.documentfoundation.org/show_bug.cgi?id=119949#c21: Mark the area to which the filter should be applied. Menu Data > Define Range. Enter Name, Add, OK. Later, in case not already marked, go to Menu Data > Select Range. After the area is marked, enable Autofilter by menu Data > Autofilter. Define Range has it's own help (via F1) https://help.libreoffice.org/7.3/en-US/text/scalc/01/12010000.html but it doesn't explain or link use in filter. There's another link (how do we get there?) https://help.libreoffice.org/7.3/en-US/text/scalc/guide/database_define.html which links "Filtering Cell Ranges" at https://help.libreoffice.org/7.3/en-US/text/scalc/guide/database_filter.html.