2.4.757 BrtRangeProtectionIso14
The BrtRangeProtectionIso14 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 BrtRangeProtectionIso14 record MUST be immediately followed by a BrtRangeProtection14 (section 2.4.755) record whose protPwd field value MUST be set to 0x0000 and whose FRTHeader and RangeProtectionTitleSDRel fields MUST have the same values as the fields of the same names in the BrtRangeProtectionIso14 record.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FRTHeader (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
dwSpinCount |
|||||||||||||||||||||||||||||||
|
RangeProtectionTitleSDRel (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
ipdPasswordData (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
FRTHeader (variable): An FRTHeader that specifies the future record (section 2.1.6) information for this record.
-
The FRTHeader flags MUST have the values listed in the following table:
|
Field |
Value |
|---|---|
|
FRTHeader.fRef |
0 |
|
FRTHeader.fSqref |
1 |
|
FRTHeader.fFormula |
0 |
|
FRTHeader.fRelID |
0 |
-
The FRTHeader.rgSqrefs.csqref MUST equal 1.
The sqrfx field of the single FRTSqref (section 2.5.66) structure, which comprises an array of FRTHeader.rgSqrefs fields, specifies the cell range that can be unprotected. The value of the sqrfx.crfx MUST be equal to or greater than 8192.
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.
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. The size of the rgbHash member of this field MUST NOT be zero.