2.5.198.111 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 (2 bytes): An RwU that specifies information about the row of the cell reference. If column.rowRelative is 0, then row specifies the row coordinate of the cell reference. If column.rowRelative is 1, then row 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 or greater than 0x0000FFFF, the value is adjusted by 0x00010000 so that it will result in a valid row index.
column (2 bytes): A ColRelNegU that specifies information about the row and column. If column.colRelative is 0, then column.col is an unsigned integer that specifies the column coordinate of the cell reference and MUST be less than 256. If column.colRelative is 1, then column.col is a signed integer that specifies the column as an offset from the cell in which the formula is evaluated. If the signed result of the offset is a column index less than 0x0000 or greater than 0x00FF, the value is adjusted by 0x0100 so that it will result in a valid column index.