Issue 89816 - Automatic data area selection stops at empty row.
Summary: Automatic data area selection stops at empty row.
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 3.0 Beta
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-05-22 23:43 UTC by ivanii
Modified: 2013-02-07 22:37 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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.