Issue 20945 - Filter at the Auto-filter
Summary: Filter at the Auto-filter
Status: CLOSED DUPLICATE of issue 27745
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: bettina.haberer
QA Contact: issues@sc
Keywords: oooqa
Depends on:
Reported: 2003-10-09 13:17 UTC by cyberlinux
Modified: 2013-08-07 15:12 UTC (History)
4 users (show)

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

file created from data shown in issue (6.33 KB, application/octet-stream)
2003-10-24 12:51 UTC, diane
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description cyberlinux 2003-10-09 13:17:59 UTC
Subject: Filter at the Auto-filter

I don't know if it's some configuration of "calc" , but I'd like that to filter 
the auto-filter's combo-box.
Please, take a look at the example below:


      COMPANY     NAME                     AGE
      AAAA        Zé mané                  45
      AAAA        Luiz Pereira             30
      AAAA        Carlos Coelho            22
      AAAA        Manoel da Silva          68
      AAAA        Ana Maria                30
      AAAA        Erica de Sousa           24
      AAAA        Cesar Munhos             36
      AAAA        Alexandre Pereira        38
      AAAA        Julho Muniz              29
      AAAA        Miguel Falamerda         30
      BBBB        Ricardo Borges           32
      BBBB        Bruno Henrique           30
      BBBB        Paulo Seraldo            28
      BBBB        Diego Maradona           44
      BBBB        Édison Arantes           27


If I press auto-filter and select the company: BBBB, it will bring me exactly 
what I need:


      COMPANY     NAME                     AGE
      BBBB        Ricardo Borges           32
      BBBB        Bruno Henrique           30
      BBBB        Paulo Seraldo            28
      BBBB        Diego Maradona           44
      BBBB        Édison Arantes           27


It's everyting ok so far.
But continuing with the "filter", when I press at combo AGE, it shows me every 
age of the column, including the company AAAA.
At the Microsoft Excel, it filters the "combo-box" as well.
It's very important that the correction should be done.
Comment 1 frank 2003-10-13 11:36:00 UTC

please attach a document that shows this behaviour, it makes work much

Also the prio is to high, Prio 2 is mainly for crashes. So I changed
Prio to 3.

Comment 2 diane 2003-10-24 12:51:05 UTC
Created attachment 10606 [details]
file created from data shown in issue
Comment 3 diane 2003-10-24 12:54:07 UTC
added oooqa keyword and confirmed issue. OOo1.1.0 on RH9 linux.
Comment 4 frank 2003-10-24 13:42:05 UTC
Hi Bettina,

1 4 u


PS. Enahncement because the autofilter never has this feature.

PPS. Thanks for the document Diane
Comment 5 bettina.haberer 2003-12-03 18:47:27 UTC
At auto-filtering the filterentries in the auto-filter-combobox should
be listed according the filtered result.
Hello Niklas, this feature would increase the usage-recognition for
transition from competing spreadsheet. 
Please give approval for this evaluated OO.o 2.0 flagged issue. 
If you confirm with the target OO.o 2.0, then please keep it on your
owner (or the owner of the concerning developer) for implementation.
In case you want this issue for 'OOo Later', then please reset the
target milestone. If you decline the issue finally, please set the
resolution to 'Wontfix' (but do not close). In case of 'OOo Later' or
'Wontfix' please reset it on Bettina's owner. Thank you.
Comment 6 niklas.nebel 2004-01-26 11:25:05 UTC
This is not on the list of features that we're going to do for 2.0. We need to
focus on the enhancements from the PCD document.
Comment 7 pagalmes.lists 2006-10-16 14:31:14 UTC
This is a feature many users from Excel request. Any news about that issue ?
Comment 8 ooo 2006-10-17 14:48:43 UTC
Duplicate of a more active issue.

*** This issue has been marked as a duplicate of 27745 ***
Comment 9 ooo 2006-10-17 14:49:26 UTC
Closing dup.