2.4.101 BrtBeginListCol

The BrtBeginListCol record specifies properties of a column (1) in a table and specifies the beginning of a collection of records, as defined by the Table (section 2.1.7.51) part ABNF and the Single Cell Tables (section 2.1.7.46) part ABNF. The collection of records specifies a table column (1).

idField (4 bytes):  An unsigned integer that specifies the numeric identifier of the table column (1). The value MUST be unique for all BrtBeginListCol records following the preceding BrtBeginList (section 2.4.100) record. The value MUST be greater than or equal to 1.

ilta (4 bytes): A ListTotalRowFunction (section 2.5.88) that specifies the table total row aggregation function for this table column (1). If the crwTotals field in the BrtBeginList (section 2.4.100) record is equal to 1, then the formula (section 2.2.2) specified by the value of ilta MUST be equal to the formula of the cell intersected by the table total row and this table column (1).

nDxfHdr (4 bytes): A DXFId (section 2.5.38) that specifies the differential formatting (section 2.2.6.2) applied to the table header of this table column (1). If the fSingleCell field or crwHeader field of the preceding BrtBeginList record is equal to 1, the value MUST be 0xFFFFFFFF.

nDxfInsertRow (4 bytes): A DXFId that specifies the differential formatting (section 2.2.6.2) applied to the table insert row of this table column (1). If the fSingleCell field of the preceding BrtBeginList record is equal to 1, the value MUST be 0xFFFFFFFF.

nDxfAgg (4 bytes): A DXFId that specifies the differential formatting applied to the table total row of this table column (1). If the fSingleCell field of the preceding BrtBeginList record is equal to 1, the value MUST be 0xFFFFFFFF.

idqsif (4 bytes):  A QsiFieldId (section 2.5.112) that specifies the numeric identifier of the query table column (1) that corresponds to this column (1). The value MUST be 0 or unique for all BrtBeginListCol records following the preceding BrtBeginList record. If the lt field of the preceding BrtBeginList record is equal to LTEXTDATA, the value MUST be greater than or equal to 1; otherwise, the value MUST be 0.

stName (variable): An XLNullableWideString (section 2.5.167) that specifies a textual identifier of this table column (1). The string in this field MUST be NULL or unique for all BrtBeginListCol records following the preceding BrtBeginList (section 2.4.100) record. If the fSingleCell field of the preceding BrtBeginList record is equal to 1 or the lt field of the preceding BrtBeginList record is equal to LTRANGE, the string MUST be NULL; otherwise, the string length MUST be greater than or equal to 1 and less than or equal to 255.

stCaption (variable): An XLNullableWideString that specifies the caption of this table column (1) to be displayed in the sheet. The string MUST be NULL or unique for all BrtBeginListCol records following the preceding BrtBeginList (section 2.4.100) record. If the fSingleCell field of the preceding BrtBeginList record is equal to 1, the string MUST be NULL; otherwise, the string length MUST be greater than or equal to 1 and less than or equal to 255. If the crwHeader field of the preceding BrtBeginList record is equal to 1, then the string MUST be equal to the string of the cell intersected by the table header row and this table column (1).

stTotal (variable): An XLNullableWideString that specifies the text to be displayed in the table total row of this table column (1). The string length MUST be less than or equal to 8189. The string MUST be NULL if ilta is equal to ILTA_CUSTOM. If the crwTotals field of the preceding BrtBeginList record is equal to 1, then the string MUST be equal to the string of the cell intersected by the table total row and this table column (1).

stStyleHeader (variable): A CellStyleName (section 2.5.11) that specifies the name of the cell style (section 2.2.6.1.2) that is applied to the table header row of this table column (1). If the fSingleCell field or crwHeader field of the preceding BrtBeginList record is equal to 1, the string MUST be NULL.

stStyleInsertRow (variable): A CellStyleName that specifies the name of the cell style that is applied to the table insert row of this table column (1). If the fSingleCell field of the preceding BrtBeginList record is equal to 1, the string MUST be NULL.

stStyleAgg (variable): A CellStyleName that specifies the name of the cell style (section 2.2.6.1.2) that is applied to the total row of this table column (1)<13>. If the fSingleCell field of the preceding BrtBeginList record is equal to 1, the string MUST be NULL.