2.5.173 Xti
The Xti structure specifies a supporting link record and scope information for a Supporting Link (section 2.2.7.2).
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
externalLink |
|||||||||||||||||||||||||||||||
|
firstSheet |
|||||||||||||||||||||||||||||||
|
lastSheet |
|||||||||||||||||||||||||||||||
externalLink (4 bytes): An unsigned integer that specifies a zero-based index to a supporting link record in the collection of supporting link records (section 2.2.7.3) in the Workbook (section 2.1.7.61) part ABNF. This value MUST be less than the count of the supporting link records in that part.
firstSheet (4 bytes): A signed integer that specifies the scope of the supporting link. If externalLink refers to a BrtSupAddin (section 2.4.799), a BrtSupSame (section 2.4.812), or a BrtSupBookSrc (section 2.4.800) that specifies a DDE data source (section 2.2.7.4.2) or OLE data source (section 2.2.7.4.3), this field MUST be -2.
-
If externalLink refers to a BrtSupSelf (section 2.4.813) or a BrtSupBookSrc that specifies an external workbook link (section 2.2.7.4.1), this field MUST be a value from the following table.
-
Value
Meaning
-2
Workbook-level reference that applies to the entire workbook.
-1
Sheet-level reference. The first sheet in the reference cannot be found.
>= 0
Sheet-level reference. This value specifies the first sheet in the reference.
If externalLink specifies a BrtSupSelf record, then this value specifies a zero-based index of a BrtBundleSh (section 2.4.313) record in the collection of all records directly following BrtBeginBundleShs (section 2.4.13) in the Workbook (section 2.1.7.61) part. If externalLink specifies a BrtSupBookSrc record, then this value specifies a zero-based index of an XLWideString in the array specified by the sheetNames field in the BrtSupTabs (section 2.4.814) record in the External Link (section 2.1.7.25) part ABNF external link part that is specified by the BrtSupBookSrc record. The sheet specified by the part specified by the BrtBundleSh record, or the sheet identified by the sheet name specified by the item in the sheetNames field, MUST be a worksheet or macro sheet.
lastSheet (4 bytes): A signed integer that specifies the scope of the supporting link. If externalLink refers to a BrtSupAddin, a BrtSupSame, or a BrtSupBookSrc that specifies a DDE Data Source or OLE Data Source, this field MUST be -2.
-
If externalLink refers to a BrtSupSelf or a BrtSupBookSrc that specifies an external workbook link, this field MUST be a value from the following table.
-
Value
Meaning
-2
Workbook-level reference. MUST be used if firstSheet equals -2.
-1
Sheet-level reference. The last sheet in the reference cannot be found.<75> MUST NOT be used if firstSheet equals -2.
>= 0
Sheet-level reference. This value specifies the last sheet in the reference. MUST NOT be used if firstSheet equals -2.
If externalLink specifies a BrtSupSelf record, then this value specifies a zero-based index of a BrtBundleSh record in the collection of all records directly following BrtBeginBundleShs in the Workbook (section 2.1.7.61) part. If externalLink specifies a BrtSupBookSrc record, then this value specifies a zero-based index of an XLWideString in the array specified by the sheetNames field in the BrtSupTabs record in the external link part that is specified by the BrtSupBookSrc record. The sheet specified by the part specified by the BrtBundleSh record, or the sheet identified by the sheet name specified by the item in the sheetNames field, MUST be a worksheet or macro sheet.
This value MUST be greater than or equal to firstSheet.