workbookWorksheetProtectionOptions resource type
Namespace: microsoft.graph
Represents the options in sheet protection.
Properties
Property | Type | Description |
---|---|---|
allowAutoFilter | Boolean | Indicates whether the worksheet protection option to allow the use of the autofilter feature is enabled. |
allowDeleteColumns | Boolean | Indicates whether the worksheet protection option to allow deleting columns is enabled. |
allowDeleteRows | Boolean | Indicates whether the worksheet protection option to allow deleting rows is enabled. |
allowFormatCells | Boolean | Indicates whether the worksheet protection option to allow formatting cells is enabled. |
allowFormatColumns | Boolean | Indicates whether the worksheet protection option to allow formatting columns is enabled. |
allowFormatRows | Boolean | Indicates whether the worksheet protection option to allow formatting rows is enabled. |
allowInsertColumns | Boolean | Indicates whether the worksheet protection option to allow inserting columns is enabled. |
allowInsertHyperlinks | Boolean | Indicates whether the worksheet protection option to allow inserting hyperlinks is enabled. |
allowInsertRows | Boolean | Indicates whether the worksheet protection option to allow inserting rows is enabled. |
allowPivotTables | Boolean | Indicates whether the worksheet protection option to allow the use of the pivot table feature is enabled. |
allowSort | Boolean | Indicates whether the worksheet protection option to allow the use of the sort feature is enabled. |
JSON representation
The following JSON representation shows the resource type.
{
"allowAutoFilter": true,
"allowDeleteColumns": true,
"allowDeleteRows": true,
"allowFormatCells": true,
"allowFormatColumns": true,
"allowFormatRows": true,
"allowInsertColumns": true,
"allowInsertHyperlinks": true,
"allowInsertRows": true,
"allowPivotTables": true,
"allowSort": true
}