GrapeCity.Documents.Excel.IProtectionSettings

Interface IProtectionSettings

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Represents the various types of protection options available for a worksheet. The setting action will take effect only if the worksheet is under protection.

public interface IProtectionSettings

Properties

AllowDeletingColumns

Gets or sets whether the deletion of columns is allowed on a protected worksheet.

bool AllowDeletingColumns { get; set; }

Property Value

bool

AllowDeletingRows

Gets or sets whether the deletion of rows is allowed on a protected worksheet.

bool AllowDeletingRows { get; set; }

Property Value

bool

AllowFiltering

Gets or sets whether the user is allowed to make use of an AutoFilter that was created before the sheet was protected.

bool AllowFiltering { get; set; }

Property Value

bool

AllowFormattingCells

Gets or sets whether the formatting of cells is allowed on a protected worksheet.

bool AllowFormattingCells { get; set; }

Property Value

bool

AllowFormattingColumns

Gets or sets whether the formatting of columns is allowed on a protected worksheet.

bool AllowFormattingColumns { get; set; }

Property Value

bool

AllowFormattingRows

Gets or sets whether the formatting of rows is allowed on a protected worksheet.

bool AllowFormattingRows { get; set; }

Property Value

bool

AllowInsertingColumns

Gets or sets whether the insertion of columns is allowed on a protected worksheet.

bool AllowInsertingColumns { get; set; }

Property Value

bool

AllowInsertingHyperlinks

Gets or sets whether the insertion of hyperlinks is allowed on a protected worksheet.

bool AllowInsertingHyperlinks { get; set; }

Property Value

bool

AllowInsertingRows

Gets or sets whether the insertion of rows is allowed on a protected worksheet.

bool AllowInsertingRows { get; set; }

Property Value

bool

AllowSorting

Gets or sets whether the sorting option is allowed on a protected worksheet.

bool AllowSorting { get; set; }

Property Value

bool

AllowUsingObjects

Gets or sets whether the user is allowed to use objects on a protected worksheet.

bool AllowUsingObjects { get; set; }

Property Value

bool

AllowUsingPivotTables

Gets or sets whether the user is allowed to use pivot tables on a protected worksheet.

bool AllowUsingPivotTables { get; set; }

Property Value

bool

Methods

FromJson(string)

Generate protectionSettings from the JSON string.

void FromJson(string json)

Parameters

json string

The JSON string representing the ProtectionOptions.

ToJson()

Generate the JSON string from the protectionSettings.

string ToJson()

Returns

string

The JSON string representing the ProtectionOptions.