2.5.198.16 ExtSheetPair
The ExtSheetPair structure specifies a pair of sheets in the formulas of an external defined name. The sheets are in the External Workbook as specified by the preceding SupBook record.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
itabFirst |
itabLast |
||||||||||||||||||||||||||||||
itabFirst (2 bytes): A signed integer that specifies the first sheet of a single or multi-sheet reference. It MUST be a value from the following table:
-
Value
Meaning
-1
Specifies that the first sheet of this reference could not be found.
>=0
This value specifies the zero-based index of an XLUnicodeString in the rgst field of the preceding SupBook record. The XLUnicodeString specifies the name of the first referenced sheet within the supporting workbook. This value MUST be less than the value of the ctab field in the preceding SupBook record.
itabLast (2 bytes): A signed integer that specifies the last sheet of a single or multi-sheet reference. The value MUST be greater than or equal to itabFirst if it is not -1 and MUST be a value from the following table:
-
Value
Meaning
-1
Specifies that the last sheet of this reference could not be found.
>=0
This value specifies the zero-based index of an XLUnicodeString in the rgst field of the preceding SupBook record. The XLUnicodeString specifies the name of the last referenced sheet within the supporting workbook. This value MUST be less than the value of the ctab field in the preceding SupBook record.