2.5.198.106 RgceAreaRel
The RgceAreaRel structure specifies a rectangular range of cells 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 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
rowFirst |
rowLast |
||||||||||||||||||||||||||||||
|
columnFirst |
columnLast |
||||||||||||||||||||||||||||||
rowFirst (2 bytes): An RwU that specifies information about the first row of the cell reference. If columnFirst.rowRelative is 0, then rowFirst specifies the first row coordinate of the cell reference. If columnFirst.rowRelative is 1, then rowFirst specifies the first row as an offset from the cell in which the formula is evaluated.
rowLast (2 bytes): An RwU that specifies information about the last row of the cell reference. If columnLast.rowRelative is 0, then rowLast specifies the last row coordinate of the cell reference. If columnLast.rowRelative is 1, then rowLast specifies the last row as an offset from the cell in which the formula is evaluated.
columnFirst (2 bytes): A ColRelNegU that specifies information about the first row and column in the range. If columnFirst.colRelative is 0, then columnFirst.col is an unsigned integer that specifies the first column coordinate of the cell reference and MUST be less than 256. If columnFirst.colRelative is 1, then columnFirst.col is a signed integer that specifies the first column as an offset from the cell in which the formula is evaluated.
columnLast (2 bytes): A ColRelNegU that specifies information about the first row and column in the range. If columnLast.colRelative is 0, then columnLast.col is an unsigned integer that specifies the last column coordinate of the cell reference and MUST be less than 256. If columnLast.colRelative is 1, then columnLast.col is a signed integer that specifies the last column as an offset from the cell in which the formula is evaluated.