SpreadsheetGroupBehaviorOptions.CollapseExpandOnProtectedSheet Property

Gets or sets the document’s capability to collapse or expand groups located on a protected worksheet. This is a dependency property.

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v19.2.dll

Declaration

C#

public DocumentCapability CollapseExpandOnProtectedSheet { get; set; }

VB.NET

Public Property CollapseExpandOnProtectedSheet As DocumentCapability

Property Value

Type	Description
DocumentCapability	A DocumentCapability enumeration value specifying the document’s capability to perform an operation.

Available values:

Name	Description
Default	The value is determined by the current setting. The default value is automatically set if it is not explicitly specified.
Disabled	The feature is not allowed and the corresponding commands are shown disabled.
Enabled	The feature is available and the corresponding commands are shown enabled.
Hidden	The feature is not available and the corresponding commands are hidden.

Property Paths

You can access this nested property as listed below:

Object Type	Path to CollapseExpandOnProtectedSheet
SpreadsheetBehaviorOptions	.Group.CollapseExpandOnProtectedSheet

Remarks

The DocumentCapability.Default property value for the CollapseExpandOnProtectedSheet is equal to the DocumentCapability.Disabled, so that collapsing or expanding groups in a protected worksheet is unavailable for the Spreadsheet document by default.