# Editable

The "Editable" property defines if the cells of a widget are editable.

#### Value

The Editable property is defined by boolean values. If the Editable formula returns true, the cell is editable, if it returns false, it is not editable.

#### Remarks

* This property is only applied in Live mode. In Edit mode, all cells of a widget are always editable.
* For table widgets, a range of boolean values can be used to define the Editable property for each cell. In that case,
  * if a single cell is used, it defines the Editable properties of all cells
  * if a row is used, the values define the Editable property for each according column
  * if a column is used, the values define the Editable property for each according row
  * if a range is used, the values define the Editable property for each according cell

#### Examples

The selected cell is editable, because the Editable formula returns *<mark style="color:red;">true</mark>* as value.

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-648c76ad510ec1ccecf7b6f83348cf02486b2ce1%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

In this example, only the numbers of the continents should be editable, not the total number. Please note that instead of boolean value (true or false), the numbers 1 and 0 can be used instead.

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-0c4b625799c9c72ff2b091a371631e7fcd5fb60f%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

The column "isEditable2" defines that all cells in the rows of the continents are editable, but not the cells in the "Total" row.

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-00b67b22130173d6efb733dd53894ec4ecfeba26%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

The row "isEditable3" defines that all cells in the continent column are not editable, but the values in the other columns.

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-2ae1f787b9f7fd5d944988c095f88ee5e8de115c%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

The range "isEditable4" defines that only the values of the continents are editable.

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-7739d8415b2ebae39fc20933e9376f56564953e3%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>