[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

pane (View Pane)

Worksheet view pane

Parent Elements

customSheetView3.3.1.23); sheetView3.3.1.83)

 

Attributes

Description

activePane (Active Pane)

The pane that is active.

 

The possible values for this attribute are defined by the ST_Pane simple type (§3.18.54).

state (Split State)

Indicates whether the pane has horizontal / vertical splits, and whether those splits are frozen.

 

The possible values for this attribute are defined by the ST_PaneState simple type (§3.18.55).

topLeftCell (Top Left Visible Cell)

Location of the top left visible cell in the bottom right pane (when in Left-To-Right mode).

 

The possible values for this attribute are defined by the ST_CellRef simple type (§3.18.8).

xSplit (Horizontal Split Position)

Horizontal position of the split, in 1/20th of a point; 0 (zero) if none. If the pane is frozen, this value indicates the number of columns visible in the top pane.

 

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

ySplit (Vertical Split Position)

Vertical position of the split, in 1/20th of a point; 0 (zero) if none. If the pane is frozen, this value indicates the number of rows visible in the left pane.

 

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

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Pane">

   <attribute name="xSplit" type="xsd:double" use="optional" default="0"/>

   <attribute name="ySplit" type="xsd:double" use="optional" default="0"/>

   <attribute name="topLeftCell" type="ST_CellRef" use="optional"/>

   <attribute name="activePane" type="ST_Pane" use="optional" default="topLeft"/>

   <attribute name="state" type="ST_PaneState" use="optional" default="split"/>

</complexType>