Skip to content

workbookworksheetprotectionoptions.md

Latest commit

 

History

History
79 lines (64 loc) · 2.44 KB

workbookworksheetprotectionoptions.md

File metadata and controls

79 lines (64 loc) · 2.44 KB
title workbookWorksheetProtectionOptions resource type
description Represents the options in sheet protection.
author lumine2008
ms.localizationpriority medium
ms.subservice excel
doc_type resourcePageType
ms.date 08/01/2024

workbookWorksheetProtectionOptions resource type

Namespace: microsoft.graph

[!INCLUDE beta-disclaimer]

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.

Relationships

None.

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
}