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