constructor

• new WorksheetProtectedRange(title): WorksheetProtectedRange

• Parameters

  • title: string

  Returns WorksheetProtectedRange

Static $t

hasPassword

• get hasPassword(): boolean

• Returns true if the range has a password associated with it.

  Returns boolean

isProtected

• get isProtected(): boolean

• Returns a boolean indicating if the range is currently locked.

  When the associated Worksheet is protected, the ranges with a password will be marked as protected until they are unprotected.

  Returns boolean

• set isProtected(a): void

• Parameters

  • a: boolean

  Returns void

ranges

• get ranges(): ICollection$1<WorksheetRegion>

• Returns a collection of ranges that may be edited when the worksheet is protected.

  Returns ICollection$1<WorksheetRegion>

title

• get title(): string

• Returns or sets the name of the range.

  Returns string

• set title(a): void

• Parameters

  • a: string

  Returns void

worksheet

• get worksheet(): Worksheet

• Returns the worksheet with which the edit range is associated.

  Returns Worksheet

• set worksheet(a): void

• Parameters

  • a: Worksheet

  Returns void

unprotect

• unprotect(): void

• Removes the password from the range.

  Note: If the range is not currently protected (i.e. [[isProtected]] returns false) the method will not do anything.

  See

  • [[isProtected]]
  • [[hasPassword]]

  Returns void