ValidationErrorinterface
Describes a validation error for a specific cell in the sheet.
Properties (7)
| Property | Type | Default | Required | Description |
|---|---|---|---|---|
| backgroundColor⚓︎ | string | x | x | The new background color for the cell. Defaults to the column color. |
| column⚓︎ | number | x | The location of the error (column 0 is the left-most column in the grid). |
|
| description⚓︎ | string | x | x | A human-readable description of the problem. This will be displayed in the cell’s comment. |
| error⚓︎ | number | x | x | An error code that defines the problem. This will be displayed in the cell’s comment. |
| foregroundColor⚓︎ | string | x | x | The new color for the cell. Defaults to the column color. |
| row⚓︎ | number | x | The location of the error (row 0 is the row containing the column headers). |
|
| text⚓︎ | string | x | x | The cell text will be replaced by this value; default is not to change the value in the cell. |