[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
This element represents a single table style definition. The built-in table styles are written in the tableStyle element by name, but the corresponding tableStyleElement elements are assumed rather than explicitly written. Following is a listing of each of the built-in table style definitions, whose normative definition is in Annex D.
Any of the built-in tables styles, along with any additional table styles explicitly defined shall be supported by applications implementing table styles.
[Note: Each of the table styles is made up of a collection of formatting definitions, each of which corresponds to a particular structured region of the table. An application can decide to support these built-in types, and can also decide to define more styles, each with their own definitions. An application can also decide whether the user will be allowed to customize or further define additional table styles. end note]
Table Style |
[Example: (informative) |
TableStyleMedium28 |
|
TableStyleMedium27 |
|
TableStyleMedium26 |
|
TableStyleMedium25 |
|
TableStyleMedium24 |
|
TableStyleMedium23 |
|
TableStyleMedium22 |
|
TableStyleMedium21 |
|
TableStyleMedium20 |
|
TableStyleMedium19 |
|
TableStyleMedium18 |
|
TableStyleMedium17 |
|
TableStyleMedium16 |
|
TableStyleMedium15 |
|
TableStyleMedium14 |
|
TableStyleMedium13 |
|
TableStyleMedium12 |
|
TableStyleMedium11 |
|
TableStyleMedium10 |
|
TableStyleMedium9 |
|
TableStyleMedium8 |
|
TableStyleMedium7 |
|
TableStyleMedium6 |
|
TableStyleMedium5 |
|
TableStyleMedium4 |
|
TableStyleMedium3 |
|
TableStyleMedium2 |
|
TableStyleMedium1 |
|
TableStyleLight21 |
|
TableStyleLight20 |
|
TableStyleLight19 |
|
TableStyleLight18 |
|
TableStyleLight17 |
|
TableStyleLight16 |
|
TableStyleLight15 |
|
TableStyleLight14 |
|
TableStyleLight13 |
|
TableStyleLight12 |
|
TableStyleLight11 |
|
TableStyleLight10 |
|
TableStyleLight9 |
|
TableStyleLight8 |
|
TableStyleLight7 |
|
TableStyleLight6 |
|
TableStyleLight5 |
|
TableStyleLight4 |
|
TableStyleLight3 |
|
TableStyleLight2 |
|
TableStyleLight1 |
|
TableStyleDark11 |
|
TableStyleDark10 |
|
TableStyleDark9 |
|
ableStyleDark8 |
|
TableStyleDark7 |
|
TableStyleDark6 |
|
TableStyleDark5 |
|
TableStyleDark4 |
|
TableStyleDark3 |
|
TableStyleDark2 |
|
TableStyleDark1 |
|
PivotTable Style |
[Example: (informative) |
PivotStyleMedium28 |
|
PivotStyleMedium27 |
|
PivotStyleMedium26 |
|
PivotStyleMedium25 |
|
PivotStyleMedium24 |
|
PivotStyleMedium23 |
|
PivotStyleMedium22 |
|
PivotStyleMedium21 |
|
PivotStyleMedium20 |
|
PivotStyleMedium19 |
|
PivotStyleMedium18 |
|
PivotStyleMedium17 |
|
PivotStyleMedium16 |
|
PivotStyleMedium15 |
|
PivotStyleMedium14 |
|
PivotStyleMedium13 |
|
PivotStyleMedium12 |
|
PivotStyleMedium11 |
|
PivotStyleMedium10 |
|
PivotStyleMedium9 |
|
PivotStyleMedium8 |
|
PivotStyleMedium7 |
|
PivotStyleMedium6 |
|
PivotStyleMedium5 |
|
PivotStyleMedium4 |
|
PivotStyleMedium3 |
|
PivotStyleMedium2 |
|
PivotStyleMedium1 |
|
PivotStyleLight28 |
|
PivotStyleLight27 |
|
PivotStyleLight26 |
|
PivotStyleLight25 |
|
PivotStyleLight24 |
|
PivotStyleLight23 |
|
PivotStyleLight22 |
|
PivotStyleLight21 |
|
PivotStyleLight20 |
|
PivotStyleLight19 |
|
PivotStyleLight18 |
|
PivotStyleLight17 |
|
PivotStyleLight16 |
|
PivotStyleLight15 |
|
PivotStyleLight14 |
|
PivotStyleLight13 |
|
PivotStyleLight12 |
|
PivotStyleLight11 |
|
PivotStyleLight10 |
|
PivotStyleLight9 |
|
PivotStyleLight8 |
|
PivotStyleLight7 |
|
PivotStyleLight6 |
|
PivotStyleLight5 |
|
PivotStyleLight4 |
|
PivotStyleLight3 |
|
PivotStyleLight2 |
|
PivotStyleLight1 |
|
PivotStyleDark28 |
|
PivotStyleDark27 |
|
PivotStyleDark26 |
|
PivotStyleDark25 |
|
PivotStyleDark24 |
|
PivotStyleDark23 |
|
PivotStyleDark22 |
|
PivotStyleDark21 |
|
PivotStyleDark20 |
|
PivotStyleDark19 |
|
PivotStyleDark18 |
|
PivotStyleDark17 |
|
PivotStyleDark16 |
|
PivotStyleDark15 |
|
PivotStyleDark14 |
|
PivotStyleDark13 |
|
PivotStyleDark12 |
|
PivotStyleDark11 |
|
PivotStyleDark10 |
|
PivotStyleDark9 |
|
PivotStyleDark8 |
|
PivotStyleDark7 |
|
PivotStyleDark6 |
|
PivotStyleDark5 |
|
PivotStyleDark4 |
|
PivotStyleDark3 |
|
PivotStyleDark2 |
|
PivotStyleDark1 |
|
Parent Elements |
tableStyles (§3.8.42) |
Child Elements |
Subclause |
tableStyleElement (Table Style) |
§3.8.41 |
Attributes |
Description |
count (Table Style Count) |
Count of table style elements defined for this table style.
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
name (Table Style Name) |
Name of this table style.
The possible values for this attribute are defined by the XML Schema string datatype. |
pivot (Pivot Style) |
'True' if this table style should be shown as an available pivot table style.
Not mutually exclusive with table - both can be true.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
table (Table) |
True if this table style should be shown as an available table style.
Not mutually exclusive with pivot - both can be true.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_TableStyle">
<sequence>
<element name="tableStyleElement" type="CT_TableStyleElement" minOccurs="0" maxOccurs="unbounded"/>
</sequence>
<attribute name="name" type="xsd:string" use="required"/>
<attribute name="pivot" type="xsd:boolean" use="optional" default="true"/>
<attribute name="table" type="xsd:boolean" use="optional" default="true"/>
<attribute name="count" type="xsd:unsignedInt" use="optional"/>
</complexType>