Custom Table Style

This range of cells is a Table object with a custom Table style applied. The table definition in table1 specifies which table style is applied, and which aspects of the table style definition are 'turned on' and should be applied:

<table  id="2" name="Table11" displayName="Table11" ref="L20:O24" totalsRowShown="0">
	<tableStyleInfo name="TableStyleMedium10 - Custom" showFirstColumn="0" showLastColumn="0" showRowStripes="1" showColumnStripes="0"/>
</table>

The <tableStyleInfo> element indicates that this Table uses the "TableStyleMedium10 - Custom" style and that "first column", "last column", and "column stripes" formatting are OFF. It also indicates that "row stripes" formatting is ON.

Here is the "TableStyleMedium10 - Custom" definition in the Styles part:

	<tableStyles count="1" defaultTableStyle="TableStyleMedium9" defaultPivotStyle="PivotStyleLight16">
	<tableStyle name="TableStyleMedium10 - Custom" pivot="0" count="7">
	<tableStyleElement type="wholeTable" dxfId="6"/>
	<tableStyleElement type="headerRow" dxfId="5"/>
	<tableStyleElement type="totalRow" dxfId="4"/>
	<tableStyleElement type="firstColumn" dxfId="3"/>
	<tableStyleElement type="lastColumn" dxfId="2"/>
	<tableStyleElement type="firstRowStripe" dxfId="1"/>
	<tableStyleElement type="firstColumnStripe" dxfId="0"/>
	</tableStyle>
	</tableStyles>
	<colors/>
</styleSheet>

Note that even though column stripes are defined for this table style, they are not used for this instance of the table.

The header row formatting for this table is defined by the 5th <dxf> definition:

	<dxf>
	<font>
	<b/>
	<color theme="0"/>
	</font>
	<fill>
	<patternFill patternType="solid">
	<fgColor theme="5"/>
	<bgColor theme="5"/>
	</patternFill>
	</fill>
	<border>
	<bottom style="medium">
	<color theme="1"/>
	</bottom>
	</border>
	</dxf>

This formatting indicates that for the header row of this table, the font is bold face and uses a themed color; the fill is solid and uses a themed color; and there is a bottom border on the cells.