2.4.841 BrtUCR
The BrtUCR record specifies undo information for row or column (1) deletion and move operations when affected formulas (section 2.2.2) (section 2.2.2) or named ranges reference the deleted rows, columns (1), or moved range. This record is not applicable for insert revisions.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
iptg |
ptg |
A |
B |
reserved1 |
|||||||||||||||||||||||||||
|
reserved2 |
|||||||||||||||||||||||||||||||
|
rfxChanged (16 bytes) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
rw |
|||||||||||||||||||||||||||||||
|
col |
|||||||||||||||||||||||||||||||
|
tabid |
rgb (variable) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
iptg (16 bits): An unsigned integer that specifies a zero-based index of a Ptg (section 2.5.98.16) record in the Rgce (section 2.5.98.88) Ptg of the affected formula. The referenced Ptg specifies the affected element of the formula. If fLbl is 1, this value MUST be 0 and MUST be ignored.
ptg (8 bits): An unsigned integer that specifies the type of expression that was adjusted in the affected formula or named range. The value MUST be one of the values specified in the following table.
-
Value
Meaning
0x24
Specifies a reference to a single cell.
0x25
Specifies a reference to a rectangular area of cells.
0x26
Specifies a reference to a fixed set of cells.
0x2A
Specifies an invalid reference to a cell.
0x2B
Specifies an invalid reference to a cell range.
0x3A
Specifies a reference to a single cell on the referenced sheet.
0x3B
Specifies a reference to a rectangular area of cells on the referenced sheet.
0x3C
Specifies an invalid reference to a single cell on the referenced sheet.
0x3D
Specifies an invalid reference to a rectangular area of cells on the referenced sheet.
0x44
Specifies a value-typed reference to a single cell.
0x45
Specifies a value-typed reference to a rectangular area of cells.
0x46
Specifies a value-typed reference to a fixed set of cells.
0x4A
Specifies a value-typed invalid reference to a cell.
0x4B
Specifies a value-typed invalid reference to a cell range.
0x5A
Specifies a value-typed reference to a single cell on the referenced sheet.
0x5B
Specifies a value-typed reference to a rectangular area of cells on the referenced sheet.
0x5C
Specifies a value-typed invalid reference to a single cell on the referenced sheet.
0x5D
Specifies a value-typed invalid reference to a rectangular area of cells on the given sheet.
0x64
Specifies an array-typed reference to a single cell.
0x65
Specifies an array-typed reference to a rectangular area of cells.
0x66
Specifies an array-typed reference to a fixed set of cells.
0x6A
Specifies an array-typed invalid reference to a cell.
0x6B
Specifies an array-typed invalid reference to a cell range.
0x7A
Specifies an array-typed reference to a single cell on the given sheet.
0x7B
Specifies an array-typed reference to a rectangular area of cells on the given sheet.
0x7C
Specifies an array-typed invalid reference to a single cell on the given sheet.
0x7D
Specifies an array-typed invalid reference to a rectangular area of cells on the given sheet.
A - fLbl (1 bit): A bit that specifies whether this record applies to a formula or a named range. If this value is 0, then this record applies to a formula. Otherwise, this record applies to a named range.
B - fUseSh2 (1 bit): A bit that specifies whether the expression was on a different sheet.
reserved1 (6 bits): This value MUST be 0 and MUST be ignored.
reserved2 (4 bytes): This value MUST be 0 and MUST be ignored.
rfxChanged (16 bytes): An RfXRel (section 2.5.119) that specifies the range that is referenced by the affected formula or named range.
rw (4 bytes): A RwNullable (section 2.5.128) that specifies the row of the cell of the formula that referenced the deleted cell range. If fLbl equals 1, then this value MUST be 0xFFFFFFFF and MUST be ignored.
col (4 bytes): A ColNullable (section 2.5.24) that specifies the column (1) of the cell of the formula that referenced the deleted cell range. If fLbl equals 1, then this value MUST be 0xFFFFFFFF and MUST be ignored.
tabid (2 bytes): A signed integer that specifies the identifier of the sheet that contained the formula that referenced the deleted cell range. If tabid equals -1, then tabid is ignored. This value MUST be greater than or equal to -1.
rgb (variable): An XLNameWideString (section 2.5.166) that specifies the named range that references the deleted cells. This value MUST NOT be present if fLbl equals 0. This value MUST be present if fLbl equals 1.