Issue 103976 - Autofilter and Standard Filter not intuitive
Summary: Autofilter and Standard Filter not intuitive
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO310m11
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2009-08-03 17:35 UTC by mrmaceurope
Modified: 2014-05-22 06:26 UTC (History)
3 users (show)

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

Examples on problems with Standard Filter and Autofilter (7.61 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-08-03 17:37 UTC, mrmaceurope
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description mrmaceurope 2009-08-03 17:35:51 UTC
I have started to use OpenOffice as my primary Office Suite and I'm using Calc a lot... While using the AutoFilter function (Data -> Filter -> Autofiler) I 
discovered a few bugs, which I think are related.

Scenario: (see attachment)
If you create a sheet1 with only column headers - e.g. HEADER1...HEADER3 and active Autofiler - no problems.

If you then create a sheet2 with a sheet header, e.g. 'My Budget' and then in row 2 adds HEADER1...HEADER3 as above and the turn on AutoFilter. Problems! 
First of all, the AutoFilter dialogs on sheet1 are turned off and on sheet2 your are able to choose a specific value to filter, but you can't really use the 'Standard 
Filter' function, as the headers no longer are recognized, the Standard Filter dialog shows only the ColumnA...X as field names not the column header titles.

I found, that if I add a empty Row between the sheet header, 'My Budget' and the first column header e.g. in row 3, no issues. ???
Comment 1 mrmaceurope 2009-08-03 17:37:14 UTC
Created attachment 63937 [details]
Examples on problems with Standard Filter and Autofilter
Comment 2 Rainer Bielefeld 2009-08-04 07:01:33 UTC
I checked with "Ooo 3.1.0 WIN XP multilingual version German UI activated 
[OOO310m11 (Build 9399)]" and can confirm some of the reported effects, although
I have problems to understand all details of the reported problems. 

I believe a strong recommendation in Help that a data range with column labels
should be defined for Auto Filter use would help to avoid mrmaceurope's problems. 

Of course an automatic column labels detection will have limitations, but may be
that feature can be improved?

I believe this one is a DUP of Issue 12666

Currently It seems that the report summary is "Doing things wrong does not work ;-)

For your "First of all ..." problem we already have Issue 12666 (you know, you
left a comment there ...)

And in Issue 12666 you also find the hint that defining data ranges makes auto
filter much more comfortable. 
Comment 3 mrmaceurope 2009-08-04 09:36:04 UTC
Correct, if I define a Data Range and then select it and try to use the Standard Filter... it works correctly. 
However, to me, it's a bug - If Autofilter headers can't be detected correct as I describe, users will think 
that the filter function isn't working when they are trying to use the Standard Filter function.
Comment 4 Edwin Sharp 2013-12-27 09:42:28 UTC
In sheet ERROR of attachment replace:
"The range does not contain column headers.
Do you want the first line to be used as column header?"
"Please select column headers" + Select button
Let user highlight the column headers.
Comment 5 Rainer Bielefeld 2014-05-22 06:26:35 UTC
I can't imagine what the concrete enhancement request might be here.