Spread Windows Forms 7.0 Product Documentation
GetSelection Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : GetSelection Method


index
Index into the list of selections

Glossary Item Box

Gets the selection on this sheet with the specified index.

Syntax

Visual Basic (Declaration) 
Public Function GetSelection( _
   ByVal index As Integer _
) As CellRange
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim index As Integer
Dim value As CellRange
 
value = instance.GetSelection(index)
C# 
public CellRange GetSelection( 
   int index
)

Parameters

index
Index into the list of selections

Return Value

CellRange object containing the range of cells for the specified selection

Example

This example illustrates the use of this member by returning the selection with the specified index.
C#Copy Code
DialogResult dlg; 
fpSpread1.ActiveSheet.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.MultiRange;
fpSpread1.ActiveSheet.AddSelection(0, 0, 2, 2);
fpSpread1.ActiveSheet.AddSelection(0, 3, 2, 2);
dlg = MessageBox.Show("Do you want to get one of the selections?", "GetSelection", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
    FarPoint.Win.Spread.Model.CellRange cr;
    cr = fpSpread1.ActiveSheet.GetSelection(1);
    label1.Text = "The selection covers cells " + cr.Row + ", " + cr.Column + ", " + cr.RowCount + ", " + cr.ColumnCount;
}
Visual BasicCopy Code
Dim dlg As DialogResult
FpSpread1.ActiveSheet.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.MultiRange
FpSpread1.ActiveSheet.AddSelection(0, 0, 2, 2)
FpSpread1.ActiveSheet.AddSelection(0, 3, 2, 2)
dlg = MessageBox.Show("Do you want to get one of the selections?", "GetSelection", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
    Dim cr As FarPoint.Win.Spread.Model.CellRange
    cr = FpSpread1.ActiveSheet.GetSelection(1)
    Label1.Text = "The selection covers cells " & cr.Row & ", " & cr.Column & ", " & cr.RowCount & ", " &     cr.ColumnCount
End If

Requirements

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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.