2.5.198.10 ExtNameParsedFormula

The ExtNameParsedFormula structure specifies a formula (section 2.2.2) used in an external defined name.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

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.