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.
Created attachment 44667 [details]
The error screenshot
[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?
Created attachment 45987 [details]
Sample Document, see Comment 1
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.
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.
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.
Set as NOTABUG.