Member Junction
    Preparing search index...

    Interface SheetProtection

    Sheet protection options

    interface SheetProtection {
        autoFilter?: boolean;
        deleteColumns?: boolean;
        deleteRows?: boolean;
        formatCells?: boolean;
        formatColumns?: boolean;
        formatRows?: boolean;
        insertColumns?: boolean;
        insertHyperlinks?: boolean;
        insertRows?: boolean;
        password?: string;
        pivotTables?: boolean;
        selectLockedCells?: boolean;
        selectUnlockedCells?: boolean;
        sort?: boolean;
    }
    Index

    Properties

    autoFilter? deleteColumns? deleteRows? formatCells? formatColumns? formatRows? insertColumns? insertHyperlinks? insertRows? password? pivotTables? selectLockedCells? selectUnlockedCells? sort?

    Properties

    autoFilter?: boolean

    Allow auto filter

    deleteColumns?: boolean

    Allow deleting columns

    deleteRows?: boolean

    Allow deleting rows

    formatCells?: boolean

    Allow formatting cells

    formatColumns?: boolean

    Allow formatting columns

    formatRows?: boolean

    Allow formatting rows

    insertColumns?: boolean

    Allow inserting columns

    insertHyperlinks?: boolean

    Allow inserting hyperlinks

    insertRows?: boolean

    Allow inserting rows

    password?: string

    Password for protection (will be hashed)

    pivotTables?: boolean

    Allow pivot tables

    selectLockedCells?: boolean

    Allow selecting locked cells

    selectUnlockedCells?: boolean

    Allow selecting unlocked cells

    sort?: boolean

    Allow sorting

    Settings

    Member Visibility

    On This Page

    Properties