Muokkaa

Jaa


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
}