[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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>

end example]

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

chartsheet3.3.1.11); customSheetView3.3.1.23); customSheetView3.3.1.22); dialogsheet3.3.1.32); worksheet3.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>