Ask Your Question

AutoFilter (or any other filter) with a list of values per cell? [closed]

asked 2018-04-07 16:07:06 +0200

intelfx gravatar image

updated 2020-07-20 11:17:52 +0200

Alex Kemp gravatar image

Hello, Let's suppose I'm building a comparative table where each row describes a certain product and each column names a specific property category, and individual cells specify values of these properties for each product. Certain properties imply ranges of values (e. g., the nominal frequency range of a wireless antenna) and certain products have more than one value for certain properties (e. g. available body colors of a smartphone).

Now, I need to create a filter which would understand such cases. E. g. if I specify "Black; Gray; White" in a cell, then the basic autofilter in Calc will offer me a single option with exact same text ("Black; Gray; White"), while I need the filter to offer me three options ("Black", "Gray" and "White") each of which should select this row. Same goes for ranges.

Is it possible to create such a filter in Calc or in any other application in the LibreOffice suite?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-04-13 13:01:30.771245

1 Answer

Sort by » oldest newest most voted

answered 2018-04-09 23:13:17 +0200

erAck gravatar image

Instead of AutoFilter that offers choices of entire cell contents, use Data -> More Filters -> Standard Filter with Contains Black OR Contains Gray OR ...

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-04-07 16:07:06 +0200

Seen: 571 times

Last updated: Apr 09 '18