Table of Contents

Conditional Cell Read-Only

Conditional read-only rules make specific cells non-editable based on row data or Workbook state. Each rule has a Name, an optional Disabled flag, a Target expression, and a Statement expression.

Rule structure

Field Description
Target Cell-address expression — which cells to make read-only when Statement returns true
Statement Boolean Eaze expression — cells are read-only while this returns true

Examples

Make Qty read-only on rows where Amount exceeds a threshold:

Target:    @Qty[]
Statement: @Amount[] > 100

Make Qty read-only on rows already persisted to the database (PBRowIdentity is positive for saved rows):

Target:    @Qty[]
Statement: @PBRowIdentity[] != -1

Lock all cells on locked rows:

Target:    @Amount[]
Statement: IsRowLocked(GetCallContextRow())