Returns an ordered array of CellRange objects, from largest to smallest, containing the selected cells with minimal overlap between the ranges.
Syntax
Parameters
- rowCount
- Specifies the number of rows in the sheet in which to look
- columnCount
- Specifies the number of columns in the sheet in which to look
Return Value
Array of
CellRange objects containing the ranges of cells
Remarks
Example
This example returns an ordered array of CellRange objects, from largest to smallest, containing the selected cells with minimal overlap between the ranges.
C# | Copy Code |
---|
FarPoint.Win.Spread.Model.DefaultSheetSelectionModel ds = new FarPoint.Win.Spread.Model.DefaultSheetSelectionModel();
ds.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.MultiRange;
ds.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Cell;
fpSpread1.ActiveSheet.Models.Selection = ds;
ds.SetSelection(0, 0, 2, 2);
ds.AddSelection(3, 0, 2, 2);
FarPoint.Win.Spread.Model.CellRange[] cr;
cr = ds.GetSelections(10, 5);
MessageBox.Show(cr[0].ColumnCount.ToString());
|
Visual Basic | Copy Code |
---|
Dim ds As New FarPoint.Win.Spread.Model.DefaultSheetSelectionModel
ds.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.MultiRange
ds.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Cell
FpSpread1.ActiveSheet.Models.Selection = ds
ds.SetSelection(0, 0, 2, 2)
ds.AddSelection(3, 0, 2, 2)
Dim cr As FarPoint.Win.Spread.Model.CellRange()
cr = ds.GetSelections(10, 5)
MessageBox.Show(cr(0).ColumnCount.ToString()) |
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