[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

sheetFormatPr (Sheet Format Properties)

Sheet formatting properties.

Parent Elements

dialogsheet3.3.1.32); worksheet3.3.1.96)

 

Attributes

Description

baseColWidth (Base Column Width)

Specifies the number of characters of the maximum digit width of the normal style's font. This value does not include margin padding or extra padding for gridlines. It is only the number of characters.

 

See defaultColWidth description in this section for details on calculating this value.

 

See the col element description, particularly the width attribute description, for more information on what is meant by "maximum digit width".

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

customHeight (Custom Height)

'True' if defaultRowHeight value has been manually set, or is different from the default value.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

defaultColWidth (Default Column Width)

Default column width measured as the number of characters of the maximum digit width of the normal style's font.

 

If the user has not set this manually, then it can be calculated:

defaultColWidth = baseColumnWidth + {margin padding (2 pixels on each side, totalling 4 pixels)} + {gridline (1pixel)}

 

If the user has set this manually, then there is no calculation, and simply a value is specified.

 

The possible values for this attribute are defined by the XML Schema double datatype.

defaultRowHeight (Default Row Height)

Default row height measured in point size. Optimization so we don't have to write the height on all rows. This can be written out if most rows have custom height, to achieve the optimization.

 

When the row height of all rows in a sheet is the default value, then that value is written here, and customHeight is not set. If a few rows have a different height, that information is written directly on each row. However, if most or all of the rows in the sheet have the same height, but that height isn't the default height, then that height value should be written here (as an optimization), and the customHeight flag should also be set. In this case, all rows having this height do not need to express the height, only rows whose height differs from this value need to be explicitly expressed.

 

The possible values for this attribute are defined by the XML Schema double datatype.

outlineLevelCol (Column Outline Level)

Highest number of outline levels for columns in this sheet. These values must be in synch with the actual sheet outline levels.

 

The possible values for this attribute are defined by the XML Schema unsignedByte datatype.

outlineLevelRow (Maximum Outline Row)

Highest number of outline level for rows in this sheet. These values must be in synch with the actual sheet outline levels.

 

The possible values for this attribute are defined by the XML Schema unsignedByte datatype.

thickBottom (Thick Bottom Border)

'True' if rows have a thick bottom border by default.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

thickTop (Thick Top Border)

'True' if rows have a thick top border by default.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

zeroHeight (Hidden By Default)

'True' if rows are hidden by default. This setting is an optimization used when most rows of the sheet are hidden. In this case, instead of writing out every row and specifying hidden, it is much shorter to only write out the rows that are not hidden, and specify here that rows are hidden by default, and only not hidden if specified.

 

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_SheetFormatPr">

   <attribute name="baseColWidth" type="xsd:unsignedInt" use="optional" default="8"/>

   <attribute name="defaultColWidth" type="xsd:double" use="optional"/>

   <attribute name="defaultRowHeight" type="xsd:double" use="required"/>

   <attribute name="customHeight" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="zeroHeight" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="thickTop" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="thickBottom" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="outlineLevelRow" type="xsd:unsignedByte" use="optional" default="0"/>

   <attribute name="outlineLevelCol" type="xsd:unsignedByte" use="optional" default="0"/>

</complexType>