Off late, I have had to use OpenOffice.org's Calc quite regularly. While it generally works quite well, it has a lot of wonky little bugs that can be quite frustrating. One of these has to do with the autofilter.
When using the autofilter, you will, on occasion find that once you are done using it and try to remove it, a number of rows, usually empty, will be missing post-removal. The following are steps/tools that might help you recover these rows: