Apache OpenOffice (AOO) Bugzilla – Issue 89816
Automatic data area selection stops at empty row.
Last modified: 2013-02-07 22:37:21 UTC
If there is empty row the only way to include data below is to explicitly select area before applying autofilter. Even if you chose 'Select all' and then autofilter, it won't take anything below first empty row. Personally, I think that even if nothing is selected and you chose Autofilter it should take all available data, not just contiguous. Excel does it correctly.
Validating on Dev_DEV300_m21_winXP. It's a old problem. So I think it must had been submited before. And It is a pity that I can't find it by search "autofilter""filter empty" and so on in the qatracker.
This seems to be related to issue 90920: Calc's handling of null values is non-standard.
No, this issue is not related to issue 90920. This issue here is about the automatic selection of the data area if none was selected. Issue 90920 is about considering empty cells when searching for an empty string respectively the empty paragraph regular expression. Enhancement of data area selection => requirements.