Spread Windows Forms 11.0 Product Documentation
GetEnumerator Method (ISheetSelectionModel)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > ISheetSelectionModel Interface : GetEnumerator Method
Gets an enumerator that can iterate through the selections.
Syntax
'Declaration
 
Function GetEnumerator() As IEnumerator
'Usage
 
Dim instance As ISheetSelectionModel
Dim value As IEnumerator
 
value = instance.GetEnumerator()
IEnumerator GetEnumerator()

Return Value

IEnumerator object for enumerating to the next selection
Example
This example gets an enumerator that can iterate through the selections of cells.
FarPoint.Win.Spread.Model.ISheetSelectionModel sel;
IEnumerator se;
bool b;
FarPoint.Win.Spread.Model.CellRange cr;
sel = (FarPoint.Win.Spread.Model.ISheetSelectionModel)fpSpread1.ActiveSheet.Models.Selection;
sel.AddSelection(0, 0, 2, 2);
sel.AddSelection(3, 0, 3, 2);
se = sel.GetEnumerator();
b = se.MoveNext();
if (b == true)
{
cr = (FarPoint.Win.Spread.Model.CellRange)se.Current;
label1.Text = "First selection is Col - " + cr.Column + " Row - " + cr.Row + " Col2 - " + cr.ColumnCount + " Row2 - " + cr.RowCount;
}
Dim sel As FarPoint.Win.Spread.Model.ISheetSelectionModel
Dim se As IEnumerator
Dim b As Boolean
Dim cr As FarPoint.Win.Spread.Model.CellRange
sel = FpSpread1.ActiveSheet.Models.Selection
sel.AddSelection(0, 0, 2, 2)
sel.AddSelection(3, 0, 3, 2)
se = sel.GetEnumerator()
b = se.MoveNext()
If b = True Then
cr = se.Current()
Label1.Text = "First selection is Col - " & cr.Column & " Row - " & cr.Row & " Col2 - " & cr.ColumnCount & " Row2 - " & cr.RowCount
End If
See Also

Reference

ISheetSelectionModel Interface
ISheetSelectionModel Members