Share via

2.4.805 BrtSupNameFmla

  • Article

The BrtSupNameFmla record specifies the formula (section 2.2.2) of an external defined name (section 2.2.7.4.1.1). The formula of an external defined name, if defined, is restricted to the formula types specified by the val field.


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

val (variable)

...

cb (4 bytes): An unsigned integer that specifies the size of val in bytes. If the external defined name, as specified by the previous BrtSupNameStart (section 2.4.809) record, is not defined in the external workbook (section 2.1.10), this value MUST be 0 and val MUST NOT exist.

val (variable): An optional variant of a Ptg (section 2.5.98.16) that specifies the formula of an external defined name. This field exists if and only if cb is greater than 0. If this field exists, the contents of this field MUST be one and only one of the following structures:

  • ExtPtgRef3D (section 2.5.48)

  • ExtPtgArea3D (section 2.5.45)

  • ExtPtgRefErr3D (section 2.5.49)

  • ExtPtgAreaErr3D (section 2.5.46)

  • ExtPtgErr (section 2.5.47)

    If the formula cannot be represented correctly with one of the previous variant structures of a Ptg, then val MUST contain an ExtPtgErr.