Sheetprotectproperties

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

Property	Type	Description
autoFilter	string	Use AutoFilter
deleteColumns	string	Delete Column
deleteRows	string	Delete row
formatCells	string	Cell Format
formatColumns	string	Column Format
formatRows	string	Row Format
insertColumns	string	Insert Column
insertHyperlinks	string	Insert hyperlink
insertRows	string	Insert row
objects	string	Edit Object
pivotTables	string	Using PivotTable Reports
scenarios	string	Edit scenario
selectLockedCells	string	Select locked cells
selectUnlockedCells	string	Select unlocked cells
sort	string	sort

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

ShapeCellRenderer SignalBarCellRenderer