2.5.98.90 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 (4 bytes): If columnFirst.fRwRel is 0, then rowFirst is an UncheckedRw (section 2.5.155) that specifies the first row coordinate of the cell reference. If columnFirst.fRwRel is 1, then rowFirst is a RwRelNeg (section 2.5.129) that specifies the first row as an offset from the cell in which the formula is evaluated.
rowLast (4 bytes): If columnLast.fRwRel is 0, then rowLast is an UncheckedRw that specifies the last row coordinate of the cell reference. If columnLast.fRwRel is 1, then rowLast is a RwRelNeg that specifies the last row as an offset from the cell in which the formula is evaluated.
columnFirst (2 bytes): A ColRelShort (section 2.5.26) structure that specifies information about the first row and column (1). If columnFirst.fColRel is 0, then columnFirst.col specifies the first column (1) coordinate of the cell reference. If columnFirst.fColRel is 1, then columnFirst.col specifies the first column (1) as an offset from the cell in which the formula is evaluated.
columnLast (2 bytes): A ColRelShort structure that specifies information about the last row and column (1). If columnLast.fColRel is 0, then columnLast.col specifies the last column (1) coordinate of the cell reference. If columnLast.fColRel is 1, then columnLast.col specifies the last column (1) as an offset from the cell in which the formula is evaluated.