[Solved] Standard filter multiple condtitions

[marcihun]

Is there a way using standard filter the way like this: coumn A = 1 AND (coumn B = 'x' OR column B = 'y').

[Alex1]

Welcome to the forum!

It doesn't seem to work in whatever order I specify the criteria. Parentheses cannot be used; AND has a higher priority than OR. If you use LibreOffice it's easy to achieve using the autofilter.

[marcihun]

Thank you Alex! I've just changed to LibreOffice, and you were right, it has the function I was looking for.

[keme]

You can do it in OpenOffice Calc too.

In the Standard Filter dialog, click the More options button and tick regular expressions.
Condition:

Code: Select all

    A = 1
AND B = x|y

[marcihun]

If I ckeck the option regular expression, nothing happens, so there is not any input field I could type in.

[marcihun]

OK. I found it, I have to use the dropdown field.
It is a little strange and not a common way of using a dropdown anyway. So, I can click on this field, and insted of picking an option from the drop down list (options related to that column) I can directly type in this field. Thanks, it works too, so now I can go back to OpenOffice Calc as well.

[Villeroy]

The database component Base can do this easily, even with spreadsheet data.

[Villeroy]

One more thing: You can merge arbitrarily complex criteria in a calculated field and filter that, e.g.
=AND($A2=1 ; OR($B2="x" ; $B2="y"))