Class WorksheetProtectedRangeCollection

A collection of WorksheetProtectedRange instances in a Worksheet

Hierarchy

Hierarchy

  • Base
    • WorksheetProtectedRangeCollection

Implements

Constructors

Properties

$type: Type
$t: Type
nextHashCode: number

Accessors

  • get count(): number
  • Gets the number of ranges in the collection.

    Returns number

Methods

  • Clears all ranges from the collection.

    Returns void

  • Determines whether a range is in the collection.

    Returns

    True if the range is found; False otherwise.

    Parameters

    Returns boolean

  • Parameters

    • other: any

    Returns boolean

  • Returns number

  • Inserts the specified range in the collection.

    Parameters

    • index: number

      The 0-based index in the collection where the range should be inserted.

    • range: WorksheetProtectedRange

      The range to insert in the collection.

    Returns void

  • Gets the range at the specified index in the collection. The range at the specified index.

    Throws

    ArgumentOutOfRangeException 'index' is less than zero or 'index' is greater than or equal to count.

    Parameters

    • a: number

    Returns WorksheetProtectedRange

  • Removes the specified range from the collection.

    Returns

    True if the range was successfully removed from the collection; False if the range did not exist in the collection.

    Parameters

    Returns boolean

  • Removes the range at the specified index from the collection.

    Throws

    ArgumentOutOfRangeException 'index' is less than zero or 'index' is greater than or equal to count.

    Parameters

    • index: number

      The index of the range to remove from the collection.

    Returns void

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns boolean

  • Parameters

    • a: any
    • b: any

    Returns boolean

  • Parameters

    • obj: any

    Returns any[]

  • Parameters

    • obj: any

    Returns any[]

  • Parameters

    • obj: any

    Returns number

  • Parameters

    • a: any
    • b: any

    Returns boolean