2.5.98.52 PtgList
The PtgList structure specifies a rectangular area of cells in a table.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ptg |
A |
eptg |
ixti |
||||||||||||||||||||||||||||
|
B |
rowType |
C |
D |
E |
F |
G |
H |
I |
listIndex |
||||||||||||||||||||||
|
... |
colFirst |
||||||||||||||||||||||||||||||
|
colLast |
|||||||||||||||||||||||||||||||
ptg (7 bits): Reserved. This value MUST be 0x18.
A - reserved1 (1 bit): This value MUST be 0, and MUST be ignored.
eptg (1 byte): Reserved. This value MUST be 0x19.
ixti (2 bytes): An XtiIndex (section 2.5.98.103) structure that specifies the location of the table.
B - columns (2 bits): An unsigned integer that specifies the columns (1) in the referenced area. If invalid is 1 or nonresident is 1, columns is unused and MUST be ignored. Otherwise, it MUST be a value from the following table.
-
Value
Meaning
0x00
The columns (1) of the rectangular area consist of all the columns (1) of the table.
0x01
The rectangular area is one column (1) wide; that column (1) is specified by colFirst.
0x02
The columns (1) of the rectangular area consist of the columns (1) between the column (1) specified by colFirst and the column (1) specified by colLast, inclusive.
rowType (5 bits): A PtgRowType (section 2.5.98.73) structure that specifies the rows of the referenced area. If invalid is 1 or nonresident is 1, rowType is unused and MUST be ignored.
C - squareBracketSpace (1 bit): A bit that specifies whether to display spacing around the intra-table portion of the string representation of this formula (section 2.2.2) element.
D - commaSpace (1 bit): A bit that specifies whether to display spacing between column (1) references in the string representation of this formula element.
E - unused (1 bit): Undefined. This value MUST be ignored.
F - type (2 bits): An unsigned integer that specifies the data type of this record. This value MUST be a value from the following table.
-
-
-
-
Value
Meaning
0x00
This structure contains a reference, as specified in PtgDataType (section 2.5.98.36).
0x01
This structure contains a value, as specified in PtgDataType.
0x02
This structure contains an array, as specified in PtgDataType.
-
-
-
G - invalid (1 bit): A bit that specifies whether or not this structure specifies an invalid area.
H - nonresident (1 bit): A bit that specifies whether or not the table is on a different workbook than the Rgce (section 2.5.98.88). It MUST be 1 if ixti specifies a different workbook than the workbook containing the Rgce and invalid is 0.
If the value of invalid is 1, nonresident is unused and MUST be ignored.
If the value of nonresident is 1, there MUST be a PtgExtraList (section 2.5.98.43) associated with this PtgList (section 2.5.98.52) in the RgbExtra (section 2.5.98.87). This associated PtgExtraList specifies the rectangular area.
I - reserved2 (2 bits): This value MUST be 0, and MUST be ignored.
listIndex (4 bytes): An unsigned integer that specifies the numeric identifier of the referenced table. It MUST equal the idList of one of the BrtBeginList (section 2.4.100) records in this file.
If invalid is 1 or nonresident is 1, listIndex is unused and MUST be ignored.
colFirst (2 bytes): A ColShort (section 2.5.27) structure that specifies the first column (1) of the referenced area of the table, relative to the position of the referenced table. Its value MUST be less than the number of columns (1) in the referenced table.
If invalid is 1, or nonresident is 1, or columns is 0, then colFirst is unused and MUST be ignored.
colLast (2 bytes): A ColShort structure that specifies the index of the last column (1) of the referenced area of the table, relative to the position of the referenced table. Its value MUST be greater than or equal to the value of colFirst, and less than the number of columns (1) in the table.
If invalid is 1, or nonresident is 1, or columns is 0, then colLast is unused and MUST be ignored.