Filter rows/cells with formula

This processor filters cells or rows based on the result of a formula. The row matches if the result of the formula is considered as “truish”, which includes:

• A true boolean

• A number (integer or decimal) which is not 0

• The string “true”

Action

You can select the action to perform on matching rows:

• Remove matching rows

• Keep matching rows only

• Clear the content of the matching cells

• Clear the content of the non-matching cells

Columns selection

This processor can check its matching condition on multiple columns:

• A single column

• An explicit list of columns

• All columns matching a given pattern

• All columns

You can select whether the row will be considered as matching if:

• All columns are matching

• Or, at least one column is matching