ig.excel.WorksheetProtectedRange

Represents a range of cells in a worksheet that may be edited by the end user.

Dependencies

jquery-1.4.4.js
infragistics.util.js
infragistics.ext_core.js
infragistics.ext_collections.js
infragistics.ext_collectionsExtended.js
infragistics.ext_io.js
infragistics.ext_text.js
infragistics.documents.core_core.js
infragistics.ext_ui.js
The current widget has no options.
The current widget has no events.
  • ig.excel.WorksheetProtectedRange
    Constructor

    new $.ig.excel.WorksheetProtectedRange( title:string );

    Initializes a new WorksheetProtectedRange

    • title
    • Type:string
    • The name of the range
  • hasPassword

    .hasPassword( );

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

  • isProtected

    .isProtected( );

    Returns a boolean indicating if the range is currently locked.

    Remarks

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

  • ranges

    .ranges( );

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

  • title

    .title( );

    Returns the name of the range.

  • title

    .title( value:string );

    Sets the name of the range.

    • value
    • Type:string
  • unprotect

    .unprotect( );

    Removes the password from the range.

    Remarks

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

  • worksheet

    .worksheet( );
    Return Type:
    ig.excel.Worksheet
    Return Type Description:
    Returns a Worksheet.

    Returns the worksheet with which the edit range is associated.

Copyright © 1996 - 2019 Infragistics, Inc. All rights reserved.