GetSelections Method (IDisjointSelections)

Gets an ordered array of cell ranges, from largest to smallest, containing the selected cells with minimal overlap between the ranges.

Syntax

Visual Basic
C#

'Declaration
 
Function GetSelections( _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
) As CellRange()

'Usage
 
Dim instance As IDisjointSelections
Dim rowCount As Integer
Dim columnCount As Integer
Dim value() As CellRange
 
value = instance.GetSelections(rowCount, columnCount)

CellRange[] GetSelections( 
   int rowCount,
   int columnCount
)

Parameters

rowCount: Number of rows in the sheet
columnCount: Number of columns in the sheet

Return Value

Ordered array of CellRange objects, from largest to smallest, containing the selected cells

Example

This example returns the starting row of the first selection and the starting column of the second selection.

FarPoint.Win.Spread.Model.IDisjointSelections djs;
FarPoint.Win.Spread.Model.CellRange[] cr;
djs = (FarPoint.Win.Spread.Model.IDisjointSelections)fpSpread1.ActiveSheet.Models.Selection;
fpSpread1.ActiveSheet.AddSelection(0, 0, 2, 2);
fpSpread1.ActiveSheet.AddSelection(0, 3, 2, 2);
cr = djs.GetSelections(4, 4);
label1.Text = "The first row in the first selection is " + cr[0].Row + " and the " +
"first column of the second selection is " + cr[1].Column;

Visual Basic

Dim djs As FarPoint.Win.Spread.Model.IDisjointSelections
Dim cr As FarPoint.Win.Spread.Model.CellRange()
djs = FpSpread1.ActiveSheet.Models.Selection
FpSpread1.ActiveSheet.AddSelection(0, 0, 2, 2)
FpSpread1.ActiveSheet.AddSelection(0, 3, 2, 2)
cr = djs.GetSelections(4, 4)
Label1.Text = "The first row in the first selection is " & cr(0).Row & " and the " & _
"first column of the second selection is " & cr(1).Column

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

IDisjointSelections Interface
IDisjointSelections Members