Interface SheetProtection

If the SheetProtection is present then everything is readonly. Setting any of the attributes allows these types of changes to be done.

interface SheetProtection {
    autoFilter: boolean;
    deleteColumns: boolean;
    deleteRows: boolean;
    formatCells: boolean;
    formatColumns: boolean;
    formatRows: boolean;
    insertColumns: boolean;
    insertHyperlinks: boolean;
    insertRows: boolean;
    objects: boolean;
    pivotTables: boolean;
    scenarios: boolean;
    selectLockedCells: boolean;
    selectUnlockedCells: boolean;
    sheet: boolean;
    sort: boolean;
    verifier: ModificationVerifier;
}

Properties

autoFilter deleteColumns deleteRows formatCells formatColumns formatRows insertColumns insertHyperlinks insertRows objects pivotTables scenarios selectLockedCells selectUnlockedCells sheet sort verifier

Properties

autoFilter

autoFilter: boolean

deleteColumns

deleteColumns: boolean

deleteRows

deleteRows: boolean

formatCells

formatCells: boolean

formatColumns

formatColumns: boolean

formatRows

formatRows: boolean

insertColumns

insertColumns: boolean

insertHyperlinks

insertHyperlinks: boolean

insertRows

insertRows: boolean

objects

objects: boolean

pivotTables

pivotTables: boolean

scenarios

scenarios: boolean

selectLockedCells

selectLockedCells: boolean

selectUnlockedCells

selectUnlockedCells: boolean

sheet

sheet: boolean

sort

sort: boolean

verifier

verifier: ModificationVerifier

If this is specified then a password will be requested to unlock

Settings

Member Visibility

Theme

On This Page

autoFilterdeleteColumnsdeleteRowsformatCellsformatColumnsformatRowsinsertColumnsinsertHyperlinksinsertRowsobjectspivotTablesscenariosselectLockedCellsselectUnlockedCellssheetsortverifier