Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetSheetProtectionOptions.AllowSort Property

Specifies if an end-user can sort unlocked cells in a protected worksheet.

#Declaration

Delphi
property AllowSort: Boolean index 11 read; write; default False;

#Property Value

Type Default
Boolean False

#Remarks

This property corresponds to the Sort checkbox in the Protect Sheet dialog:

The Protect Sheet Dialog

Set the AllowSort property to false to forbid an end-user to sort unlocked cells (by executing the SortAscending and/or SortDescending commands) in a protected worksheet.

To identify if an end-user is currently able to sort unlocked cells, use the ActualAllowSort property.

The default value of the AllowSort property is True.

See Also