Grid controls in SpreadsheetWEB are managed on a column by column basis, and because of this, you need a separate “helper” column to manipulate individual rows.

The helper column must consist of Boolean fields with a TRUE or FALSE outcome. They can be static, or set by formulas dynamically. Since this is a “helper” column, you might also want to set its visibility to Never in the grid.

Set the Mask Type of this column to Boolean. Once you do that, two new options will appear: “Enable Row Visibility by Value” and “Enable Row Editability by Value”. 

  1. If you want to hide the rows based on the values in the helper column, select “Enable Row Visibility by Value” option.
  2. If you want to disable the rows based on the values in the helper column, select “Enable Row Editability by Value” option.