[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

selection (Selection)

Worksheet view selection.

Parent Elements

customSheetView3.3.1.23); sheetView3.3.1.83)

 

Attributes

Description

activeCell (Active Cell Location)

Location of the active cell.

 

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

activeCellId (Active Cell Index)

0-based index of the range reference (in the array of references listed in sqref) containing the active cell. Only used when the selection in sqref is not contiguous. Therefore, this value needs to be aware of the order in which the range references are written in sqref.

 

When this value is out of range then activeCell can be used.

 

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

pane (Pane)

The pane to which this selection belongs.

 

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

sqref (Sequence of References)

Range of the selection. Can be non-contiguous set of ranges.

 

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

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

<complexType name="CT_Selection">

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

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

   <attribute name="activeCellId" type="xsd:unsignedInt" use="optional" default="0"/>

   <attribute name="sqref" type="ST_Sqref" use="optional" default="A1"/>

</complexType>