Apache OpenOffice (AOO) Bugzilla – Issue 20945
Filter at the Auto-filter
Last modified: 2013-08-07 15:12:27 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.
Hi, please attach a document that shows this behaviour, it makes work much easier. Also the prio is to high, Prio 2 is mainly for crashes. So I changed Prio to 3. Frank
Created attachment 10606 [details] file created from data shown in issue
added oooqa keyword and confirmed issue. OOo1.1.0 on RH9 linux.
Hi Bettina, 1 4 u Frank PS. Enahncement because the autofilter never has this feature. PPS. Thanks for the document Diane
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.
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.
This is a feature many users from Excel request. Any news about that issue ?
Duplicate of a more active issue. *** This issue has been marked as a duplicate of 27745 ***
Closing dup.