2.4.756 BrtRangeProtectionIso

The BrtRangeProtectionIso record specifies a cell range that can be unprotected in a format compatible with ISO/IEC 29500 cell range protection records as specified in [ISO/IEC29500-1:2016], section 18.3.1.71. The cell range is editable with a password or proper credentials when sheet protection is on and the cell is locked. A BrtRangeProtectionIso record MUST be immediately followed by a BrtRangeProtection (section 2.4.754) record whose protPwd field value MUST be set to 0x0000 and whose sqRfX and RangeProtectionTitleSDRel field values MUST be the same as the values of the fields with the same names in the BrtRangeProtectionIso record.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

dwSpinCount

sqRfX (variable)

...

RangeProtectionTitleSDRel (variable)

...

ipdPasswordData (variable)

...

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). The value of the dwSpinCount field MUST NOT be greater than 10,000,000.

sqRfX (variable): An UncheckedSqRfX (section 2.5.156) that specifies the cell range to be protected. The value of the sqRfX.crfx field MUST be greater than 0. It MUST have the same value as the sqRfX field in the following BrtRangeProtection (section 2.4.754) record.

RangeProtectionTitleSDRel (variable): A RangeProtectionTitleSDRel (section 2.5.113) that specifies the title of the cell range and the security descriptor.

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