[Solved] Multiple filters conflict with each other

Discuss the spreadsheet application

[Solved] Multiple filters conflict with each other

Postby SteveBros » Sun Jan 13, 2019 9:32 am

I'm trying to find out if this is a bug or something I don't understand. When I apply a filter to a single column it works fine. Then when I display the dropdown on another column I am seeing values that should not be displayed based on the first filter! If I select one of those "rouge" values, calc filters on that and overrides my first filter. I check the first filter and it is still defined but ignored. I would expect multiple filters to work together, "AND"ing all of the filters and therefore continuously narrowing the selection. Any ideas on what is going on here? Thanks!
OpenOffice 4.1.4 OS MAC High Sierra
Last edited by Hagar Delest on Mon Jan 14, 2019 9:20 am, edited 1 time in total.
Reason: tagged solved
Apache OpenOffice 4.1.1 (Build 9775)
Windows 7 Home Premium Service Pack 1 (64-bit)
SteveBros
 
Posts: 11
Joined: Sun Apr 19, 2015 1:31 am

Re: Multiple filters conflict with each other

Postby Villeroy » Sun Jan 13, 2019 1:34 pm

Remove all filters. Make everything visible. If there are still rows hidden, use menu:Format>Rows>Unhide
Select the entire list with all columns and rows, say A1:F1001 for a list with one header row, 1000 data rows and 6 columns.
Apply auto-filter buttons to this list range.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26546
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Multiple filters conflict with each other

Postby Zizi64 » Sun Jan 13, 2019 1:35 pm

Try to apply the filter in one step to all of the columns to be filtered.
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.5 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.2; AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7820
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Multiple filters conflict with each other

Postby RusselB » Sun Jan 13, 2019 7:59 pm

Personally I hate the auto-filter option. That said, based on what you have written, it sounds like the auto-filter is doing an OR rather than an AND.
I'm going to suggest following Villeroy's suggestion, with the exception of the last step, where I'm going to suggest you use the Standard filter option.
Unless you have a lot of filters, you should have little problem with the Standard filter, and that filter gives you the ability to apply multiple filter conditions, which can be ANDed and/or OR'd (both AND and OR conjunctions can be implemented and even intermixed)
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4920
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Multiple filters conflict with each other

Postby SteveBros » Sun Jan 13, 2019 9:24 pm

Thanks everyone for the suggestions! The standard filter seems to work consistently. Choices in subsequent dropdowns don't take previous AND's into consideration, but the results are correct. I like auto-filter because, when working correctly, the dropdowns give you only choices that are valid for the other filters applied. I was able to get it working using Villeroy's suggestion but not consistently. It seems that adding a standard filter, then removing it, might clear up the problem but I can't be sure without hours of testing. I finally decided to create a new file and copy my data into it. So far, the new spreadsheet auto-filters are behaving as expected. Thanks again!
Apache OpenOffice 4.1.1 (Build 9775)
Windows 7 Home Premium Service Pack 1 (64-bit)
SteveBros
 
Posts: 11
Joined: Sun Apr 19, 2015 1:31 am


Return to Calc

Who is online

Users browsing this forum: eremmel, MrProgrammer and 21 guests