[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

tableColumn (Table Column)

An element representing a single column for this table.

Parent Elements

tableColumns3.5.1.4)

 

Child Elements

Subclause

calculatedColumnFormula (Calculated Column Formula)

§3.5.1.1

extLst (Future Feature Data Storage Area)

§3.2.10

totalsRowFormula (Totals Row Formula)

§3.5.1.6

xmlColumnPr (XML Column Properties)

§3.5.1.7

 

Attributes

Description

dataCellStyle (Data Area Style Name)

A string representing the name of the cell style that is applied to the cells in the data area of this table column.

 

If this string is missing or invalid, then the data cell style specified by the current table style should be applied.

 

This cell style should get precedence over the dataCellStyle defined by the table.

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

dataDxfId (Data & Insert Row Format Id)

A zero based integer index into the differential formatting records <dxfs> in the styleSheet indicating which format to apply to the data area of this column. This formatting shall also apply to cells on the insert row for this column.

 

The spreadsheet should fail to load if this index is out of bounds.

 

The possible values for this attribute are defined by the ST_DxfId simple type (§3.18.26).

headerRowCellStyle (Header Row Cell Style)

A string representing the name of the cell style that is applied to the header row cell of this column.

 

If this string is missing or invalid, then header row style specified by the current table style should be applied.

 

This cell style should get precedence over the headerRowCellStyle defined by the table.

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

headerRowDxfId (Header Row Cell Format Id)

A zero based integer index into the differential formatting records <dxfs> in the styleSheet indicating which format to apply to the header cell of this column.

 

The possible values for this attribute are defined by the ST_DxfId simple type (§3.18.26).

id (Table Field Id)

An integer representing the unique identifier of this column. This shall be unique per table.

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

name (Column name)

A string representing the unique caption of the table column. This is what shall be displayed in the header row in the UI, and is referenced through functions. This name shall be unique per table.

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

queryTableFieldId (Query Table Field Id)

An integer representing the query table field ID corresponding to this table column.

 

The relationship between this table and the corresponding query table is expressed in _rels part for this table. Each queryTableField has a unique id attribute, and this id is what is referenced here.

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

totalsRowCellStyle (Totals Row Style Name)

A string representing the name of the cell style that is applied to the Totals Row cell of this column.

 

If this string is missing or invalid, then the totals row cell style specified by the current table style should be applied.

 

This cell style should get precedence over the totalsRowCellStyle defined by the table.

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

totalsRowDxfId (Totals Row Format Id)

A zero based integer index into the differential formatting records <dxfs> in the styleSheet indicating which format to apply to the totals row cell of this column.

 

The spreadsheet shall not load if this index is out of bounds.

 

The possible values for this attribute are defined by the ST_DxfId simple type (§3.18.26).

totalsRowFunction (Totals Row Function)

An enumeration indicating which type of aggregation to show in the totals row cell for this column.

 

The possible values for this attribute are defined by the ST_TotalsRowFunction simple type (§3.18.83).

totalsRowLabel (Totals Row Label)

A String to show in the totals row cell for this column.

 

This string shall be ignored unless the totalsRowFunction="none" for this column, in which case it is displayed in the totals row.

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

uniqueName (Unique Name)

An optional string representing the unique name of the table column. This string is used to bind the column to a field in an data table, so it shall should only be used when this table's tableType is queryTable or xml.

 

This name shall be unique per table when it is used.

 

For tables created from xml mappings, by default this should be the same as the name of the column, and should be kept in synch with the name of the column if that name is altered by the spreadsheet application.

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_TableColumn">

   <sequence>

   <element name="calculatedColumnFormula" type="CT_TableFormula" minOccurs="0" maxOccurs="1"/>

   <element name="totalsRowFormula" type="CT_TableFormula" minOccurs="0" maxOccurs="1"/>

   <element name="xmlColumnPr" type="CT_XmlColumnPr" minOccurs="0" maxOccurs="1"/>

   <element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>

   </sequence>

   <attribute name="id" type="xsd:unsignedInt" use="required"/>

   <attribute name="uniqueName" type="ST_Xstring" use="optional"/>

   <attribute name="name" type="ST_Xstring" use="required"/>

   <attribute name="totalsRowFunction" type="ST_TotalsRowFunction" use="optional" default="none"/>

   <attribute name="totalsRowLabel" type="ST_Xstring" use="optional"/>

   <attribute name="queryTableFieldId" type="xsd:unsignedInt" use="optional"/>

   <attribute name="headerRowDxfId" type="ST_DxfId" use="optional"/>

   <attribute name="dataDxfId" type="ST_DxfId" use="optional"/>

   <attribute name="totalsRowDxfId" type="ST_DxfId" use="optional"/>

   <attribute name="headerRowCellStyle" type="ST_Xstring" use="optional"/>

   <attribute name="dataCellStyle" type="ST_Xstring" use="optional"/>

   <attribute name="totalsRowCellStyle" type="ST_Xstring" use="optional"/>

</complexType>