2.4.754 BrtRangeProtection

The BrtRangeProtection record specifies a cell range to be protected. The cell range is editable with a password or proper credentials when sheet protection is on and the cell is locked.


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

protPwd

sqRfX (variable)

...

RangeProtectionTitleSDRel (variable)

...

protPwd (2 bytes): An unsigned integer that specifies the verifier value of the password required for editing the cell range. If the 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).

sqRfX (variable): An UncheckedSqRfX (section 2.5.156) that specifies the cell range to be protected. sqRfX.crfx MUST be greater than 0 and less than 8192.

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