[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
This element describes which style is used to display this table, and specifies which portions of the table have the style applied.
Styles define set of formatting properties that may be easily referenced by cells or other objects in the spreadsheet application. A style can be applied to a table, but tables can define specific parts of the table that should not have the style applied independently of other table parts. For instance a table may not apply the row striping of the style, and may not show the style's formatting of the last column, but will apply the column striping and the formatting to the first column.
Parent Elements |
table (§3.5.1.2) |
Attributes |
Description |
name (Style Name) |
A string representing the name of the table style to use with this table.
If the style name isn't valid then the spreadsheet application should use default style.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
showColumnStripes (Show Column Stripes) |
A Boolean indicating whether column stripe formatting is applied. True when style column stripe formatting is applied, false otherwise.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
showFirstColumn (Show First Column) |
A Boolean indicating whether the first column in the table should have the style applied. True if the first column has the style applied, false otherwise.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
showLastColumn (Show Last Column) |
A Boolean indicating whether the last column in the table should have the style applied. True if the last column has the style applied, false otherwise.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
showRowStripes (Show Row Stripes) |
A Boolean indicating whether row stripe formatting is applied. True when style row stripe formatting is applied, false otherwise.
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_TableStyleInfo">
<attribute name="name" type="ST_Xstring" use="optional"/>
<attribute name="showFirstColumn" type="xsd:boolean" use="optional"/>
<attribute name="showLastColumn" type="xsd:boolean" use="optional"/>
<attribute name="showRowStripes" type="xsd:boolean" use="optional"/>
<attribute name="showColumnStripes" type="xsd:boolean" use="optional"/>
</complexType>