skip navigation
  • Product Bundles

    DevCraft

    All Telerik .NET tools and Kendo UI JavaScript components in one package. Now enhanced with:

    • NEW: Design Kits for Figma
    • Online Training
    • Document Processing Library
    • Embedded Reporting for web and desktop

    Web

    Kendo UI UI for jQuery UI for Angular UI for React UI for Vue UI for Blazor UI for ASP.NET Core UI for ASP.NET MVC UI for ASP.NET AJAX

    Mobile

    UI for .NET MAUI

    Document Management

    Telerik Document Processing

    Desktop

    UI for .NET MAUI UI for WinUI UI for WinForms UI for WPF

    Reporting

    Telerik Reporting Telerik Report Server

    Testing & Mocking

    Test Studio Test Studio Dev Edition Telerik JustMock

    CMS

    Sitefinity

    UI/UX Tools

    ThemeBuilder Design System Kit Templates and Building Blocks

    Debugging

    Fiddler Fiddler Everywhere Fiddler Classic Fiddler Everywhere Reporter FiddlerCore

    Free Tools

    VB.NET to C# Converter Testing Framework
    View all products
  • Overview
  • Demos
  • Docs & Support
  • Pricing
  • Shopping cart
    • Account Overview
    • Your Licenses
    • Downloads
    • Support Center
    • Forum Profile
    • Payment Methods
    • Edit Profile
    • Log out
  • Login
  • Contact Us
  • Try now

Class WorksheetProtectionOptions

Represents the protection options of a worksheet.

Inheritance
System.Object
WorksheetProtectionOptions
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Telerik.Windows.Documents.Spreadsheet.Model.Protection
Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public class WorksheetProtectionOptions

Constructors

WorksheetProtectionOptions(Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean)

Initializes a new instance of the WorksheetProtectionOptions class.

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
System.Boolean allowDeleteRows

The allow delete rows.

System.Boolean allowInsertRows

The allow insert rows.

System.Boolean allowDeleteColumns

The allow delete columns.

System.Boolean allowInsertColumns

The allow insert columns.

System.Boolean allowFormatCells

The allow format cells.

System.Boolean allowFormatColumns

The allow format columns.

System.Boolean allowFormatRows

The allow format rows.

System.Boolean allowFiltering

The allow use autofilter.

System.Boolean allowSorting

The allow sorting.

Fields

Default

Default protection options.

Declaration
public static readonly WorksheetProtectionOptions Default
Field Value
WorksheetProtectionOptions

Properties

AllowDeleteColumns

Gets a value indicating whether the user can delete columns when the worksheet is protected.

Declaration
public bool AllowDeleteColumns { get; }
Property Value
System.Boolean

The allow delete columns.

AllowDeleteRows

Gets a value indicating whether the user can delete rows when the worksheet is protected.

Declaration
public bool AllowDeleteRows { get; }
Property Value
System.Boolean

The allow delete rows.

AllowFiltering

Gets a value indicating whether the user can use autofilter when the worksheet is protected.

Declaration
public bool AllowFiltering { get; }
Property Value
System.Boolean

The allow filtering.

AllowFormatCells

Gets a value indicating whether the user can format cells when the worksheet is protected.

Declaration
public bool AllowFormatCells { get; }
Property Value
System.Boolean

The allow format cells.

AllowFormatColumns

Gets a value indicating whether the user can format columns when the worksheet is protected.

Declaration
public bool AllowFormatColumns { get; }
Property Value
System.Boolean

The allow format columns.

AllowFormatRows

Gets a value indicating whether the user can format rows when the worksheet is protected.

Declaration
public bool AllowFormatRows { get; }
Property Value
System.Boolean

The allow format rows.

AllowInsertColumns

Gets a value indicating whether the user can insert columns when the worksheet is protected.

Declaration
public bool AllowInsertColumns { get; }
Property Value
System.Boolean

The allow insert columns.

AllowInsertRows

Gets a value indicating whether the user can insert rows when the worksheet is protected.

Declaration
public bool AllowInsertRows { get; }
Property Value
System.Boolean

The allow insert rows.

AllowSorting

Gets a value indicating whether the user can sort when the worksheet is protected.

Declaration
public bool AllowSorting { get; }
Property Value
System.Boolean

The allow sorting.

Methods

Clone()

Clones this instance.

Declaration
public WorksheetProtectionOptions Clone()
Returns
WorksheetProtectionOptions

The cloned instance.

Equals(Object)

Determines whether the specified System.Object is equal to the current System.Object.

Declaration
public override bool Equals(object obj)
Parameters
System.Object obj

The System.Object to compare with the current System.Object.

Returns
System.Boolean

True if the specified System.Object is equal to the current System.Object; otherwise, false.

Overrides
System.Object.Equals(System.Object)

GetHashCode()

Serves as a hash function for a particular type.

Declaration
public override int GetHashCode()
Returns
System.Int32

A hash code for the current System.Object.

Overrides
System.Object.GetHashCode()
Getting Started
  • Getting Started
Support Resources
  • Documentation
Community
  • Forums
  • Blogs
  • Document Processing Feedback Portal

Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.