2.4.784 BrtSheetProtectionIso

The BrtSheetProtectionIso record specifies protection options for a Worksheet, Dialog Sheet (section 2.1.7.20), or Macro Sheet (section 2.1.7.32) in a manner compatible with ISO/IEC 29500 sheet protection records as specified in [ISO/IEC29500-1:2016], section 18.3.1.85. A BrtSheetProtectionIso record MUST be immediately followed by a BrtSheetProtection (section 2.4.783) record whose protpwd field value MUST be set to 0x0000 and whose fLocked, fObjects, fScenarios, fFormatCells, fFormatColumns, fFormatRows, fInsertColumns, fInsertRows, fInsertHyperlinks, fDeleteColumns, fDeleteRows, fSelLockedCells, fSort, fAutoFilter, fPivotTables and fSelUnlockedCells fields MUST have the same values as the fields of the same names in the BrtSheetProtectionIso record.

dwSpinCount (4 bytes): An unsigned 32-bit integer that specifies the number of times that the hash function was iterated over the password to generate the rgbHash field of ipdPasswordData, as described in the Strong Password Verifier Algorithm (section 2.2.10). It MUST NOT be greater than 10,000,000.

fLocked (4 bytes):  A Boolean (section 2.5.98.3) with a meaning that depends on the type of sheet. For a worksheet the value specifies whether the worksheet and the contents of locked cells are protected. For a macro sheet the value specifies whether the macro sheet is protected. For a dialog sheet it is undefined and MUST be ignored. It MUST have the same value as the fLocked field in the following BrtSheetProtection record.

For worksheets and macro sheets it MUST be a value from the following table:

Value	Meaning
0x00000000	The worksheet and contents of locked cells are not protected. The macro sheet is not protected.
0x00000001	The worksheet and contents of locked cells are protected. The macro sheet is protected.

fObjects (4 bytes):  A Boolean with a meaning that depends on the type of sheet. When the sheet is a worksheet or macro sheet and the value of fLocked is 0x00000001, this field specifies whether editing of objects is allowed. Undefined and MUST be ignored if the sheet is a worksheet or macro sheet and fLocked is 0x00000000. It MUST have the same value as the fObjects field in the following BrtSheetProtection record.

When the sheet is a dialog sheet, this field specifies whether the dialog sheet is protected. The value of fScenarios MUST be the same as the value of this field.

MUST be a value from the following table:

Value	Meaning
0x00000000	Editing of objects is not allowed in the worksheet or macro sheet when the value of fLocked is 0x00000001. The dialog sheet is protected.
0x00000001	Editing of objects is allowed in the worksheet or macro sheet when the value of fLocked is 0x00000001. The dialog sheet is not protected.

fScenarios (4 bytes):  A Boolean with a meaning that depends on the type of sheet. When the sheet is a worksheet or macro sheet and the value of fLocked is 0x00000001, this field specifies whether editing of scenarios is allowed. Undefined and MUST be ignored if the sheet is a worksheet or macro sheet and fLocked is 0x00000000. It MUST have the same value as the fScenarios field in the following BrtSheetProtection record.

When the sheet is a dialog sheet, this field specifies whether the dialog sheet is protected. The value of fObjects MUST be the same as the value of this field.

MUST be a value from the following table:

Value	Meaning
0x00000000	Editing of scenarios is not allowed in the worksheet or macro sheet when the value of fLocked is 0x00000001. The dialog sheet is protected.
0x00000001	Editing of scenarios is allowed in the worksheet or macro sheet when the value of fLocked is 0x00000001. The dialog sheet is not protected.

fFormatCells (4 bytes):  A Boolean that specifies whether formatting of cells is allowed in the worksheet when the value of fLocked is 0x00000001, and undefined and MUST be ignored when the value of fLocked is 0x00000000. It MUST have the same value as the fFormatCells field in the following BrtSheetProtection record. For a macro sheet or dialog sheet, it MUST have a value of 0x00000000 and MUST be ignored. For a worksheet it MUST have a value from the following table:

Value	Meaning
0x00000000	Formatting of cells is not allowed when the value of fLocked is 0x00000001.
0x00000001	Formatting of cells is allowed when the value of fLocked is 0x00000001.

fFormatColumns (4 bytes):  A Boolean that specifies whether formatting of columns (1) is allowed in the worksheet when the value of fLocked is 0x00000001, and undefined and MUST be ignored when the value of fLocked is 0x00000000. It MUST have the same value as the fFormatColumns field in the following BrtSheetProtection record. For a macro sheet or dialog sheet, it MUST have a value of 0x00000000 and MUST be ignored. For a worksheet it MUST have a value from the following table:

Value	Meaning
0x00000000	Formatting of columns (1) is not allowed when the value of fLocked is 0x00000001.
0x00000001	Formatting of columns (1) is allowed when the value of fLocked is 0x00000001.

fFormatRows (4 bytes):  A Boolean that specifies whether formatting of rows is allowed in the worksheet when the value of fLocked is 0x00000001, and undefined and MUST be ignored when the value of fLocked is 0x00000000. It MUST have the same value as the fFormatRows field in the following BrtSheetProtection record. For a macro sheet or dialog sheet, it MUST have a value of 0x00000000 and MUST be ignored. For a worksheet it MUST have a value from the following table:

Value	Meaning
0x00000000	Formatting of rows is not allowed when the value of fLocked is 0x00000001.
0x00000001	Formatting of rows is allowed when the value of fLocked is 0x00000001.

fInsertColumns (4 bytes):  A Boolean that specifies whether insertion of columns (1) is allowed in the worksheet when the value of fLocked is 0x00000001, and undefined and MUST be ignored when the value of fLocked is 0x00000000. It MUST have the same value as the fInsertColumns field in the following BrtSheetProtection record. For a macro sheet or dialog sheet, it MUST have a value of 0x00000000 and MUST be ignored. For a worksheet it MUST have a value from the following table:

Value	Meaning
0x00000000	Insertion of columns (1) is not allowed when the value of fLocked is 0x00000001.
0x00000001	Insertion of columns (1) is allowed when the value of fLocked is 0x00000001.

fInsertRows (4 bytes):  A Boolean that specifies whether insertion of rows is allowed in the worksheet when the value of fLocked is 0x00000001, and undefined and MUST be ignored when the value of fLocked is 0x00000000. It MUST have the same value as the fInsertRows field in the following BrtSheetProtection record. For a macro sheet or dialog sheet, it MUST have a value of 0x00000000 and MUST be ignored. For a worksheet, it MUST have a value from the following table:

Value	Meaning
0x00000000	Insertion of rows is not allowed when the value of fLocked is 0x00000001.
0x00000001	Insertion of rows is allowed when the value of fLocked is 0x00000001.

fInsertHyperlinks (4 bytes):  A Boolean that specifies whether insertion of hyperlinks is allowed in the worksheet when the value of fLocked is 0x00000001, and undefined and MUST be ignored when the value of fLocked is 0x00000000. It MUST have the same value as the fInsertHyperlinks field in the following BrtSheetProtection record. For a macro sheet or dialog sheet, it MUST have a value of 0x00000000 and MUST be ignored. For a worksheet, it MUST have a value from the following table:

Value	Meaning
0x00000000	Insertion of hyperlinks is not allowed when the value of fLocked is 0x00000001.
0x00000001	Insertion of hyperlinks is allowed when the value of fLocked is 0x00000001.

fDeleteColumns (4 bytes):  A Boolean that specifies whether deletion of columns (1) is allowed in the worksheet when the value of fLocked is 0x00000001, and undefined and MUST be ignored when the value of fLocked is 0x00000000. It MUST have the same value as the fDeleteColumns field in the following BrtSheetProtection record. For a macro sheet or dialog sheet, it MUST have a value of 0x00000000 and MUST be ignored. For a worksheet, it MUST have a value from the following table:

Value	Meaning
0x00000000	Deletion of columns (1) is not allowed when the value of fLocked is 0x00000001.
0x00000001	Deletion of columns (1) is allowed when the value of fLocked is 0x00000001.

fDeleteRows (4 bytes):  A Boolean that specifies whether deletion of rows is allowed in the worksheet when the value of fLocked is 0x00000001, and undefined and MUST be ignored when the value of fLocked is 0x00000000. It MUST have the same value as the fDeleteRows field in the following BrtSheetProtection record. For a macro sheet or dialog sheet, it MUST have a value of 0x00000000 and MUST be ignored. For a worksheet, it MUST have a value from the following table:

Value	Meaning
0x00000000	Deletion of rows is not allowed when the value of fLocked is 0x00000001.
0x00000001	Deletion of rows is allowed when the value of fLocked is 0x00000001.

fSelLockedCells (4 bytes):  A Boolean that specifies whether selection of locked cells is allowed in the worksheet when the value of fLocked is 0x00000001, and undefined and MUST be ignored when the value of fLocked is 0x00000000. It MUST have the same value as the fSelLockedCells field in the following BrtSheetProtection record. For a macro sheet or dialog sheet, it MUST have a value of 0x00000001 and MUST be ignored. For a worksheet, it MUST have a value from the following table:

Value	Meaning
0x00000000	Selection of locked cells is not allowed when the value of fLocked is 0x00000001.
0x00000001	Selection of locked cells is allowed when the value of fLocked is 0x00000001.

fSort (4 bytes):  A Boolean that specifies whether sorting is allowed in the worksheet when the value of fLocked is 0x00000001, and undefined and MUST be ignored when the value of fLocked is 0x00000000. It MUST have the same value as the fSort field in the following BrtSheetProtection record. For a macro sheet or dialog sheet, it MUST have a value of 0x00000000 and MUST be ignored. For a worksheet, it MUST have a value from the following table:

Value	Meaning
0x00000000	Sorting is not allowed when the value of fLocked is 0x00000001.
0x00000001	Sorting is allowed when the value of fLocked is 0x00000001.

fAutoFilter (4 bytes):  A Boolean that specifies whether use of AutoFilters is allowed in the worksheet when the value of fLocked is 0x00000001, and undefined and MUST be ignored when the value of fLocked is 0x00000000. It MUST have the same value as the fAutoFilter field in the following BrtSheetProtection record. For a macro sheet or dialog sheet, it MUST have a value of 0x00000000 and MUST be ignored. For a worksheet, it MUST be a value from the following table:

Value	Meaning
0x00000000	Use of AutoFilters is not allowed when the value of fLocked is 0x00000001.
0x00000001	Use of AutoFilters is allowed when the value of fLocked is 0x00000001.

fPivotTables (4 bytes):  A Boolean that specifies whether use of PivotTable (section 2.1.7.40) reports is allowed in the worksheet when the value of fLocked is 0x00000001, and undefined and MUST be ignored when the value of fLocked is 0x00000000. It MUST have the same value as the fPivotTables field in the following BrtSheetProtection record. For a macro sheet or dialog sheet, it MUST have a value of 0x00000000 and MUST be ignored. For a worksheet, it MUST have a value from the following table:

Value	Meaning
0x00000000	Use of PivotTable reports is not allowed when the value of fLocked is 0x00000001.
0x00000001	Use of PivotTable reports is allowed when the value of fLocked is 0x00000001.

fSelUnlockedCells (4 bytes):  A Boolean that specifies whether selection of unlocked cells is allowed in the worksheet when the value of fLocked is 0x00000001, and undefined and MUST be ignored when the value of fLocked is 0x00000000. It MUST have the same value as the fSelUnlockedCells field in the following BrtSheetProtection record. For a macro sheet or dialog sheet, it MUST have a value of 0x00000001 and MUST be ignored. For a worksheet, it MUST have a value from the following table:

Value	Meaning
0x00000000	Selection of unlocked cells is not allowed when the value of fLocked is 0x00000001.
0x00000001	Selection of unlocked cells is allowed when the value of fLocked is 0x00000001.

ipdPasswordData (variable): An IsoPasswordData (section 2.5.80) that specifies the salt, hash algorithm and password hash of the password required for editing the sheet, calculated using the Strong Password Verifier Algorithm (section 2.2.10). The size of the rgbHash member of this field MUST NOT be zero.