Bug 35501 - EDITING: Improve automatic filter data range definition
Summary: EDITING: Improve automatic filter data range definition
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.1 release
Hardware: x86 (IA32) All
: medium enhancement
Assignee: Katarina Behrens
Depends on:
Reported: 2011-03-21 03:23 UTC by wywid
Modified: 2016-10-26 08:29 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:

The data file (69.14 KB, text/csv)
2011-03-21 03:23 UTC, wywid
The error screenshot (152.97 KB, image/png)
2011-03-21 03:24 UTC, wywid
Sample Document, see Comment 1 (11.53 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-04-23 02:34 UTC, Rainer Bielefeld Retired

Note You need to log in before you can comment on or make changes to this bug.
Description wywid 2011-03-21 03:23:43 UTC
Created attachment 44666 [details]
The data file

I have a problem with the autofilter feature in Calc 3.3.1.

Some lines appairs on screen also if they contains a different value than the filter one's.

Te avoid file format problem, I've attached an exemple in CSV.

Te reproduce this bug :

1. Open invitations.csv
2. Set the autofilter feature (in French version Menu Données (datas ?) -> Filtre (Filter ?) −> Autofiltre (Autofilter ?)
3. On column W try to filter the line with the «O» value.
4. As you see on the screenshot attached, some line with empty value remains !!!

As the file format is CSV it cannot be a color mistake or whatever depending on formating.

I suppose it's a problem in my cells values which are not supported by calc.

Thanks for your help.

Comment 1 wywid 2011-03-21 03:24:30 UTC
Created attachment 44667 [details]
The error screenshot
Comment 2 Rainer Bielefeld Retired 2011-04-23 01:54:15 UTC
[Reproducible] with "LibreOffice 3.4Beta2  – WIN7  Home Premium  (64bit) German UI [DEV300m103 (Build:1)]".

The problem is cuaed by the fact that the filter data range ends in the row where the last cell in the first data row contains data. MAy be creiteria is even some more sophisticated, that's only my quick test result.

I created a more simple sample document "MySampleDocument" showing the problem.

Steps to reproduce:
1. Open "MySampleDocument"
   You should see area with row 300
2. Menu 'Data > Filter > Standard Filter'
   You will see columns B,C higlighted
3. Use scroll slider to scroll down, you see highlighting ending in row 300
4. Filter "Column2" for "o"
   As expected, filter works perfect for highlighted filter range, in cells 
   below row 300 no filter works, so also cells without "o" will be shown

If you select all data before you filter, only rows containing an "o" below "Coumn2" will be shown. 

The question is filter data range will not include all data, if no range is selected. 
Same behavior with OOo-dev 3.4 and OOo3.1.1, OOo1.1.4

I see this as an enhancement request, what do you think?
Comment 3 Rainer Bielefeld Retired 2011-04-23 02:34:01 UTC
Created attachment 45987 [details]
Sample Document, see Comment 1
Comment 4 wywid 2011-04-29 06:09:30 UTC
I can reproduce the example given by Rainer

I've supposed that it is not an improvement as all the others spreadsheet programs dont work like this.

The common usage is to consider that, if nothing selected, the filter apply to the whole spreadsheet.
Comment 5 bfoman (inactive) 2013-05-16 13:10:10 UTC
This bug has not been touched by its owner for a long time. To make it clearer which bugs should be fixed by someone else please take following action:
- If you are the owner, and you are actively working on the bug, please give it an update. 
- If you are the owner, and you do not plan to work on it in the near future,
please reassign it to the default assignee and change its status to NEW.
Comment 6 Kevin Suo 2016-10-26 08:29:13 UTC
This is not a bug at all, but is an intended feature which is in line with all other spreadsheet applications. 

If the spreadsheet contains blank rows, the auto filter will only be set on the rows above the blank row, unless you select the whole range on which you want the auto filter to be set on.