[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

tableStyle (Table Style)

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

tableStyles3.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>