<brk> (Break)

Individual row or column breaks

Parent Elements

<colBreaks> (§3.3.1.13); <rowBreaks> (§3.3.1.72)

Attributes

Description

<id> (Id)

Zero-based row or column Id of the page break. Breaks occur above the specified row and left of the specified column.

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

<man> (Manual Page Break)

Manual Break flag. '1' means the break is a manually inserted break.

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

<max> (Maximum)

Zero-based index of end row or column of the break. For row breaks, specifies column index; for column breaks, specifies row index.

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

<min> (Minimum)

Zero-based index of start row or column of the break. For row breaks, specifies column index; for column breaks, specifies row index.

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

<pt> (Pivot-Created Page Break)

Flag indicating that a PivotTable created this break.

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_Break">
	<attribute name="id" type="xsd:unsignedInt" use="optional" default="0"/>
	<attribute name="min" type="xsd:unsignedInt" use="optional" default="0"/>
	<attribute name="max" type="xsd:unsignedInt" use="optional" default="0"/>
	<attribute name="man" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="pt" type="xsd:boolean" use="optional" default="false"/>
</complexType>