[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

tableStyleElement (Table Style)

This element specifies formatting for one area of a table or PivotTable. Together the sequence of these elements makes up one entire Table style or PivotTable style definition.

The order in which table style element formatting is applied is as follows:

Table Style Element Order

Whole Table

First Column Stripe

Second Column Stripe

First Row Stripe

Second Row Stripe

Last Column

First Column

Header Row

Total Row

First Header Cell

Last Header Cell

First Total Cell

Last Total Cell

For instance, row stripe formatting 'wins' over column stripe formatting, and both 'win' over whole table formatting.

PivotTable Style Element Order

Whole Table

Page Field Labels

Page Field Values

First Column Stripe

Second Column Stripe

First Row Stripe

Second Row Stripe

First Column

Header Row

First Header Cell

Subtotal Column 1

Subtotal Column 2

Subtotal Column 3

Blank Row

Subtotal Row 1

Subtotal Row 2

Subtotal Row 3

Column Subheading 1

Column Subheading 2

Column Subheading 3

Row Subheading 1

Row Subheading 2

Row Subheading 3

Grand Total Column

Grand Total Row

Parent Elements

tableStyle3.8.40)

 

Attributes

Description

dxfId (Formatting Id)

Zero-based index to a dxf record in the dxfs collection, specifying differential formatting to use with this Table or PivotTable style element.

 

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

size (Band Size)

Number of rows or columns in a single band of striping. Applies only when type is firstRowStripe, secondRowStripe, firstColumnStripe, or secondColumnStripe.

 

[Example:

 

In this example, the firstRowStripe size is set to 2, and the secondRowStripe size is set to 1:

 

end example]

 

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

type (Table Style Type)

Identifies this table style element's type.

 

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

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

<complexType name="CT_TableStyleElement">

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

   <attribute name="size" type="xsd:unsignedInt" use="optional" default="1"/>

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

</complexType>