<headerFooter> (Header Footer Settings)

Header and footer settings.

example:

This example demonstrates "Header" at the top and "Footer" at the bottom of a page.

<headerFooter>
  <oddHeader>&amp;CHeader</oddHeader>
  <oddFooter>&amp;CFooter</oddFooter>
</headerFooter>

The tokens in the header & footer elements can be localized. An application may decide which locales are supported. Even when a locale is not supported, the header and footer text must be loaded, and only the formatting is discarded.

Parent Elements

<chartsheet>3.3.1.11); <customSheetView>3.3.1.23); <customSheetView>3.3.1.22); <dialogsheet>3.3.1.32); <worksheet>3.3.1.96)

Child Elements

Subclause

<evenFooter> (Even Page Footer)

§3.3.1.35

<evenHeader> (Even Page Header)

§3.3.1.36

<firstFooter> (First Page Footer)

§3.3.1.38

<firstHeader> (First Page Header)

§3.3.1.39

<oddFooter> (Odd Page Footer)

§3.3.1.55

<oddHeader> (Odd Header)

§3.3.1.56

Attributes

Description

<alignWithMargins> (Align Margins)

Align header footer margins with page margins. When true, as left/right margins grow and shrink, the header and footer edges stay aligned with the margins. When false, headers and footers are aligned on the paper edges, regardless of margins.

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

<differentFirst> (Different First Page)

Different first page header and footer. When true then @firstHeader and @firstFooter specify first page header and footer values. If false and @firstHeader / @firstFooter are present, they are ignored.

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

<differentOddEven> (Different Odd Even Header Footer)

Different odd and even page headers and footers. When true then @oddHeader / oddFooter and @evenHeader / evenFooter specify page header and footer values for odd and even pages. If false then <oddHeader> / <oddFooter> is used, even when <evenHeader> / <evenFooter> are present.

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

<scaleWithDoc> (Scale Header & Footer With Document)

Scale header and footer with document scaling.

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_HeaderFooter">
	<sequence>
	<element name="oddHeader" type="ST_Xstring" minOccurs="0" maxOccurs="1"/>
	<element name="oddFooter" type="ST_Xstring" minOccurs="0" maxOccurs="1"/>
	<element name="evenHeader" type="ST_Xstring" minOccurs="0" maxOccurs="1"/>
	<element name="evenFooter" type="ST_Xstring" minOccurs="0" maxOccurs="1"/>
	<element name="firstHeader" type="ST_Xstring" minOccurs="0" maxOccurs="1"/>
	<element name="firstFooter" type="ST_Xstring" minOccurs="0" maxOccurs="1"/>
	</sequence>
	<attribute name="differentOddEven" type="xsd:boolean" default="false"/>
	<attribute name="differentFirst" type="xsd:boolean" default="false"/>
	<attribute name="scaleWithDoc" type="xsd:boolean" default="true"/>
	<attribute name="alignWithMargins" type="xsd:boolean" default="true"/>
</complexType>