L.2.7.4.5 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
Here is the “TableStyleMedium10 - Custom” definition in the Styles part:
<stylesheet>
…
<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
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.