[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
pivotTableStyleInfo (PivotTable Style)
Represent information on style applied to the PivotTable.
[Example:
<sh:pivotTableStyleInfo name="PivotStyleLight16" showRowHeaders="1"
showColHeaders="1" showRowStripes="0" showColStripes="0" showLastColumn="1"/>
end example]
|
Parent Elements |
|
pivotTableDefinition (§3.10.1.73) |
|
Attributes |
Description |
|
name (Table Style Name) |
Specifies the name of the table style to use with this table.
The possible values for this attribute are defined by the XML Schema string datatype. |
|
showColHeaders (Show Table Style Column Header Formatting) |
Specifies a boolean value that indicates whether to show column headers for the table.
A value of on, 1, or true indicates column headers will be shown.
A value of off, 0, or false indicates column headers will be omitted.
'True' if table style column header formatting should be displayed.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
showColStripes (Show Column Stripes) |
Specifies a boolean value that indicates whether to show column stripe formatting for the table.
A value of on, 1, or true indicates column stripe formatting will be shown.
A value of off, 0, or false indicates no column formatting will be shown.
True if table style column stripe formatting should be displayed.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
showLastColumn (Show Last Column) |
Specifies a boolean value that indicates whether to show the last column.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
showRowHeaders (Show Row Header Formatting) |
Specifies a boolean value that indicates whether to show row headers for the table.
A value of on, 1, or true indicates table style formatting will be displayed.
A value of off, 0, or false indicates table style formatting will not be displayed.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
showRowStripes (Show Row Stripes) |
Specifies a boolean value that indicates whether to show row stripe formatting for the table.
A value of on, 1, or true indicates row stripe formatting will be displayed.
A value of off, 0, or false indicates no row formatting will be shown.
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_PivotTableStyle">
<attribute name="name" type="xsd:string"/>
<attribute name="showRowHeaders" type="xsd:boolean"/>
<attribute name="showColHeaders" type="xsd:boolean"/>
<attribute name="showRowStripes" type="xsd:boolean"/>
<attribute name="showColStripes" type="xsd:boolean"/>
<attribute name="showLastColumn" type="xsd:boolean" use="optional"/>
</complexType>