https://bugs.documentfoundation.org/show_bug.cgi?id=119949
Timur <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|NEW |RESOLVED --- Comment #22 from Timur <[email protected]> --- NotABug - meaning explained that it behaves as it should. Dan, please do not open again. It was multiple times explained why, additional text added after filter was created, Comments 2, 4, 8, 17, 18. So title is wrong "Filter broken by blank line", rather "Rows filled after Autofilter is created are not included". MSO behaves similarly. You found your workaround in Comment 20. But autofilter on another column not needed. Just press Autofilter once, it will expand selection. Nice trick. Or longer, not really needed: press once more tou turn off and turn on autofilter on Column A - that will include "shouldn’t be displayed". -- You are receiving this mail because: You are the assignee for the bug.
