2.5.198.10 ExtNameParsedFormula
The ExtNameParsedFormula structure specifies a formula (section 2.2.2) used in an external defined name.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
cb |
extPtg (optional) |
val (variable) |
|||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
cb (2 bytes): An unsigned integer that specifies the number of bytes in extPtg + the number of bytes in val. If the defined name that this external defined name specifies does not exist in its containing workbook, this value MUST be 0, and extPtg and val MUST NOT exist.
extPtg (1 byte): An unsigned integer that specifies the formula type of val. This field MUST exist if and only if cb is greater than 0. MUST be one of the values as specified in the table in the val field section.
val (variable): An optional field that specifies the formula of an external defined name. If the formula cannot be represented correctly with one formula types allowed in this field, then this field MUST specify an ExtPtgErr formula. This field MUST exist if and only if cb is greater than 0. The size and the type of the formula vary based on the value of extPtg as follows:
-
extPtg value
Val field Data and Meaning
0x3A
Specifies an ExtPtgRef3D formula.
0x3B
Specifies an ExtPtgArea3D formula.
0x3C
Specifies an ExtPtgRefErr3D formula.
0x3D
Specifies an ExtPtgAreaErr3D formula.
0x1C
Specifies an ExtPtgErr formula.