Skip to main content

TdxSpreadSheetSheetProtectionOptions.AllowSort Property

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

Declaration

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