Issue 89816

Summary: Automatic data area selection stops at empty row.
Product: Calc Reporter: ivanii <ivan.icin>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 3.0 Beta   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description ivanii 2008-05-22 23:43:22 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.
Comment 1 jm38706415 2008-07-08 05:47:52 UTC
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. 
Comment 2 clytie 2008-07-09 09:31:25 UTC
This seems to be related to issue 90920: Calc's handling of null values is non-standard.
Comment 3 ooo 2008-07-10 12:06:24 UTC
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.