workbookWorksheetProtectionOptions resource type
Namespace: microsoft.graph
Important
APIs under the /beta
version in Microsoft Graph are subject to change. Use of these APIs in production applications is not supported. To determine whether an API is available in v1.0, use the Version selector.
Represents the options in sheet protection.
Properties
Property | Type | Description |
---|---|---|
allowAutoFilter | Boolean | Represents the worksheet protection option of allowing using auto filter feature. |
allowDeleteColumns | Boolean | Represents the worksheet protection option of allowing deleting columns. |
allowDeleteRows | Boolean | Represents the worksheet protection option of allowing deleting rows. |
allowFormatCells | Boolean | Represents the worksheet protection option of allowing formatting cells. |
allowFormatColumns | Boolean | Represents the worksheet protection option of allowing formatting columns. |
allowFormatRows | Boolean | Represents the worksheet protection option of allowing formatting rows. |
allowInsertColumns | Boolean | Represents the worksheet protection option of allowing inserting columns. |
allowInsertHyperlinks | Boolean | Represents the worksheet protection option of allowing inserting hyperlinks. |
allowInsertRows | Boolean | Represents the worksheet protection option of allowing inserting rows. |
allowPivotTables | Boolean | Represents the worksheet protection option of allowing using pivot table feature. |
allowSort | Boolean | Represents the worksheet protection option of allowing using sort feature. |
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
}