2.4.755 BrtRangeProtection14
The BrtRangeProtection14 record specifies a cell range to be unprotected. The cell range is editable with a password or proper credentials when sheet protection is on and the cell is locked. This record is equivalent to BrtRangeProtection (section 2.4.754) record but allows for 8192 or more cell ranges to be specified.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FRTHeader (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
protPwd |
RangeProtectionTitleSDRel (variable) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
FRTHeader (variable): An FRTHeader (section 2.5.61) that specifies the future record (section 2.1.6) information for this record.
-
The FRTHeader field 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 of the single FRTSqref (section 2.5.66) field comprising the array of the FRTHeader.rgSqrefs specifies the cell range to be unprotected and the value of the sqrfx.crfx field MUST be equal to or greater than 8192.
protPwd (2 bytes): An unsigned integer that specifies the verifier value of the password required for editing the cell range. If the field value is 0x0000 then there is no password. For details on the algorithm to generate the value, see Password Verifier Algorithm (section 2.2.9).
RangeProtectionTitleSDRel (variable): A RangeProtectionTitleSDRel (section 2.5.113) that specifies the title of the cell range and the security descriptor.