Ask Your Question

LibreOffice Calc - Filtered Validity

asked 2020-06-26 12:49:41 +0100

AlessandroITA gravatar image

Hi to all, I'd like to create a dropdown list with the Validity function filtering the cell: I've in the A column the product name and in the E column the quantity; i'd like to have only the row where quantity is greather than zero. (in a database I'll do something like this with SELECT A FROM TABLE WHERE E>0) Is there a way to do it?


edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-06-26 13:37:19 +0100

JohnSUN gravatar image

Try this formula

IF([rangeQTY] > 0; [rangeProducts]; "")

and set on "Sort entries..." Valid Filter

edit flag offensive delete link more


It works like a charm!

AlessandroITA gravatar imageAlessandroITA ( 2020-06-29 11:39:41 +0100 )edit

answered 2020-06-26 13:26:03 +0100

LeroyG gravatar image

updated 2020-06-26 13:27:04 +0100


Pulse the arrow in the column E header, select Standard Filter…, then in Field name select column E, in Condition select >, and in Value type 0, OK.

If you want to add more information, you can edit your question, or comment an answer. Do not use Answer to comment.

Mark the circle to the left of the answer that solves your question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-06-26 12:49:41 +0100

Seen: 89 times

Last updated: Jun 26