SheetProtectProperties

Specifies the properties to be allowed when applying Excel sheet protection.

Signature:

export interface SheetProtectProperties

Remarks

Enter "0" if allowed. Enter "1" if not allowed.

If the property is not specified, it is set to the Excel default value.

The lock/hide format properties of a cell are DataColumn.cellProps or ColumnStyleObject.cellProtectProps is used.

Example

gridView.exportGrid({
     type: "excel",
     target: "local",
     sheetProtect: true;
     protectProperties: {
         selectLockedCells: "0",
         selectUnlockedCells: "0"
     },
     protectPassword: "12345678";
})

Properties

Properties Desc

autoFilter

Use automatic filters

Type - string

deleteColumns

Delete column

Type - string

deleteRows

Delete row

Type - string

formatCells

cell format

Type - string

formatColumns

column format

Type - string

formatRows

Row Format

Type - string

insertColumns

Insert column

Type - string

insertHyperlinks

Insert hyperlink

Type - string

insertRows

Insert row

Type - string

objects

Edit object

Type - string

pivotTables

Use PivotTable reports

Type - string

scenarios

Edit scenario

Type - string

selectLockedCells

Select locked cells

Type - string

selectUnlockedCells

Select unlocked cells

Type - string

sort

Sort

Type - string