ClassWorksheetProtectionOptions
Defines which operations users can perform on a protected worksheet, controlling row, column, cell, and filtering permissions.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.Model.Protection
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public class WorksheetProtectionOptionsInheritance: objectWorksheetProtectionOptions
Constructors
WorksheetProtectionOptions(bool, bool, bool, bool, bool, bool, bool, bool, bool)
Initializes a new WorksheetProtectionOptions with specific permission flags for each operation type.
Declaration
public WorksheetProtectionOptions(bool allowDeleteRows = false, bool allowInsertRows = false, bool allowDeleteColumns = false, bool allowInsertColumns = false, bool allowFormatCells = false, bool allowFormatColumns = false, bool allowFormatRows = false, bool allowFiltering = false, bool allowSorting = false)Parameters
allowDeleteRows
The allow delete rows.
allowInsertRows
The allow insert rows.
allowDeleteColumns
The allow delete columns.
allowInsertColumns
The allow insert columns.
allowFormatCells
The allow format cells.
allowFormatColumns
The allow format columns.
allowFormatRows
The allow format rows.
allowFiltering
The allow use autofilter.
allowSorting
The allow sorting.
Fields
Default
Default protection options that disallow all modifications (all permission flags set to false).
Declaration
public static readonly WorksheetProtectionOptions DefaultField Value
Properties
AllowDeleteColumns
Gets whether users can delete columns when the worksheet is protected.
Declaration
public bool AllowDeleteColumns { get; }Property Value
The allow delete columns.
AllowDeleteRows
Gets whether users can delete rows when the worksheet is protected.
Declaration
public bool AllowDeleteRows { get; }Property Value
The allow delete rows.
AllowFiltering
Gets whether users can apply and modify autofilters when the worksheet is protected.
Declaration
public bool AllowFiltering { get; }Property Value
The allow filtering.
AllowFormatCells
Gets whether users can format cells (fonts, colors, borders) when the worksheet is protected.
Declaration
public bool AllowFormatCells { get; }Property Value
The allow format cells.
AllowFormatColumns
Gets whether users can format columns (width, visibility, styles) when the worksheet is protected.
Declaration
public bool AllowFormatColumns { get; }Property Value
The allow format columns.
AllowFormatRows
Gets whether users can format rows (height, visibility, styles) when the worksheet is protected.
Declaration
public bool AllowFormatRows { get; }Property Value
The allow format rows.
AllowInsertColumns
Gets whether users can insert new columns when the worksheet is protected.
Declaration
public bool AllowInsertColumns { get; }Property Value
The allow insert columns.
AllowInsertRows
Gets whether users can insert new rows when the worksheet is protected.
Declaration
public bool AllowInsertRows { get; }Property Value
The allow insert rows.
AllowSorting
Gets whether users can sort cell ranges when the worksheet is protected.
Declaration
public bool AllowSorting { get; }Property Value
The allow sorting.
Methods
Clone()
Creates a copy of this protection options instance with identical permission flags.
Declaration
public WorksheetProtectionOptions Clone()Returns
The cloned instance.
Equals(object)
Compares all permission flags and returns true if all match the specified object.
GetHashCode()
Computes a hash code from all permission flags.