Class SheetProtectionOptions

Namespace

SheetStream

Assembly

SheetStream.dll

What users may still do on a protected sheet. Everything is blocked by default except selecting cells, matching Excel's "Protect Sheet" dialog. Cells styled with Protection.Locked = false stay editable.

public sealed class SheetProtectionOptions

Inheritance

object

SheetProtectionOptions

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Properties

AllowAutoFilter

Use existing AutoFilter drop-downs.

public bool AllowAutoFilter { get; set; }

Property Value

bool

AllowDeleteColumns

Delete columns.

public bool AllowDeleteColumns { get; set; }

Property Value

bool

AllowDeleteRows

Delete rows.

public bool AllowDeleteRows { get; set; }

Property Value

bool

AllowEditObjects

Edit drawings, charts and comments.

public bool AllowEditObjects { get; set; }

Property Value

bool

AllowEditScenarios

Edit scenarios.

public bool AllowEditScenarios { get; set; }

Property Value

bool

AllowFormatCells

Format cells.

public bool AllowFormatCells { get; set; }

Property Value

bool

AllowFormatColumns

Change column widths and hide columns.

public bool AllowFormatColumns { get; set; }

Property Value

bool

AllowFormatRows

Change row heights and hide rows.

public bool AllowFormatRows { get; set; }

Property Value

bool

AllowInsertColumns

Insert columns.

public bool AllowInsertColumns { get; set; }

Property Value

bool

AllowInsertHyperlinks

Insert hyperlinks.

public bool AllowInsertHyperlinks { get; set; }

Property Value

bool

AllowInsertRows

Insert rows.

public bool AllowInsertRows { get; set; }

Property Value

bool

AllowPivotTables

Use pivot tables.

public bool AllowPivotTables { get; set; }

Property Value

bool

AllowSelectLockedCells

Select locked cells. Default true.

public bool AllowSelectLockedCells { get; set; }

Property Value

bool

AllowSelectUnlockedCells

Select unlocked cells. Default true.

public bool AllowSelectUnlockedCells { get; set; }

Property Value

bool

AllowSort

Sort.

public bool AllowSort { get; set; }

Property Value

bool