Issue 16766 - Applying autofilterfilter and standard filter should not be sequence-dependent. Current behaviour: apply standard filter, then autofilter => works OK, but applying first the autofilter, then standard filter, => applied autofilter gets lost.
Summary: Applying autofilterfilter and standard filter should not be sequence-dependen...
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: 605
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: bettina.haberer
QA Contact: issues@sc
URL:
Keywords: oooqa, rfe_eval_ok, usability
Depends on:
Blocks:
 
Reported: 2003-07-13 03:09 UTC by philmperry
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
bug in autofilter of spreadsheet (5.97 KB, application/vnd.sun.xml.writer)
2004-02-23 11:47 UTC, gmolleda 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description philmperry 2003-07-13 03:09:17 UTC 
Set up a database with at least 3 columns. With Data>Filter>Autofilter do a
select on one of the columns, to reduce the number of rows shown. Next, add a
"standard"
("custom" in Excel) filter to, say, display only rows with a field value greater
than some cutoff. When the standard filter is applied, the autofilter defined
before is lost (all the rows are available for the standard filter). You can
redefine the autofilter now and it will work, further reducing the number of
rows displayed. However, its behavior should not be sequence-dependent
(standard, then autofilter works OK, but autofilter, then standard, doesn't).
Comment 1 oc 2003-08-08 15:25:30 UTC 
Hi Bettina, one4you
Comment 2 bettina.haberer 2004-01-29 18:18:31 UTC 
Summary: Applying autofilterfilter and standard filter should not be
sequence-dependent. Current behaviour: apply standard filter, then autofilter =>
works OK, but applying first the autofilter, then standard filter, => applied
autofilter gets lost.
This feature is considered for OO.o later.
Comment 3 gmolleda 2004-02-23 11:47:23 UTC 
Created attachment 13358 [details]
bug in autofilter of spreadsheet
Comment 4 gmolleda 2004-02-23 12:01:36 UTC 
I suposse that is the same problem (view attached file):
If you have a spreedsheet with a filter over it (A4:E10), and use the standard 
filter, the autofilter autocalc self, so is impossible apply the filter to 
column of "Final Points" (C4:C10) in my example.

Thanks you to allbody. A great work is done with OpenOffice.org.
Comment 5 erwin.tenhumberg 2004-11-09 14:50:24 UTC 
enhanced summary, set keywords and reassigned issue according to RFE process

The dialogs in Excel and Calc for applying the custom/standard filter look
slightly different, but this should not be a serious issue. In Excel on selects
the custom filter from the autofilter arrows/drop down lists. In OpenOffice.org
one can either choose a standard filter from the autofilter arrows/drop down
list or the "Data - Filter" menue. However, the OpenOffice.org standard filter
dialog includes the current autofilter settings in the dialog, so that setting a
standard filter only overrides the autofilter if someone explicitly changes the
autofilter settings in the standard filter dialog.
Comment 6 ace_dent 2008-05-17 21:10:17 UTC 
The Issue you raised has been marked as 'Resolved' and not updated within the
last 1 year+. I am therefore setting this issue to 'Verified' as the first step
towards Closing it. If you feel this is incorrect, please re-open the issue and
add any comments.

Many thanks,
Andrew
 
Cleaning-up and Closing old Issues
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html
Comment 7 ace_dent 2008-05-17 23:12:25 UTC 
As per previous posting: Verified -> Closed.
A Closed Issue is a Happy Issue (TM).

Regards,
Andrew