[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
Worksheet view pane
Parent Elements |
customSheetView (§3.3.1.23); sheetView (§3.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>