2.5.98.92 RgceLocRel
The RgceLocRel structure specifies a single cell reference where the relative portions of relative references are specified as offsets from the cell in which the formula (section 2.2.2) is evaluated.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
row |
|||||||||||||||||||||||||||||||
|
column |
|||||||||||||||||||||||||||||||
row (4 bytes): If column.fRwRel is 0, then row is an UncheckedRw (section 2.5.155) that specifies the row coordinate of the cell reference. If column.fRwRel is 1, then row is a RwRelNeg (section 2.5.129) that specifies the row as an offset from the cell in which the formula is evaluated. If the signed result of the offset is a row index less than 0x00000000, the value is incremented by 0x00100000 so that it results in a valid row index. If the signed result of the offset is a row index greater than 0x000FFFFF, the value is decremented by 0x00100000.
column (2 bytes): A ColRelShort (section 2.5.26) structure that specifies information about the row and column (1). If column.fColRel is 0, then column.col specifies the column (1) coordinate of the cell reference. If column.fColRel is 1, then column.col specifies the column (1) as an offset from the cell in which the formula is evaluated. If the signed result of the offset is a column (1) index less than 0x0000, the value is incremented by 0x4000 so that it results in a valid column (1) index. If the signed result of the offset is a column (1) index greater than 0x3FFF, the value is adjusted by 0x4000 so that it results in a valid column (1) index.