Selection Class

Selection.When the object is serialized out as xml, its qualified name is x:selection.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.Spreadsheet.Selection

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
Public Class Selection _
    Inherits OpenXmlLeafElement
'Usage
Dim instance As Selection
public class Selection : OpenXmlLeafElement

Remarks

[ISO/IEC 29500-1 1st Edition]

18.3.1.78 selection (Selection)

Worksheet view selection.

Parent Elements

customSheetView (§18.3.1.25); sheetView (§18.3.1.87)

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 (§18.18.7).

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 W3C 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 (§18.18.52).

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 (§18.18.76).

[Note: The W3C XML Schema definition of this element’s content model (CT_Selection) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

Selection Members

DocumentFormat.OpenXml.Spreadsheet Namespace