Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Property SelectionModel As ISheetSelectionModel | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SheetView Dim value As ISheetSelectionModel instance.SelectionModel = value value = instance.SelectionModel | |
| C# | |
|---|---|
public ISheetSelectionModel SelectionModel {get; set;} | |
Property Value
ISheetSelectionModel object containing the selectionsRemarks
This property is available at run time only.
Example
This example uses the SheetView object to change the appearance of a selected cell or cells, and selects a range of cells and returns if a cell in row 0 has been selected.
| C# | Copy Code |
|---|---|
FarPoint.Web.Spread.SheetViewsv=FpSpread1.ActiveSheetView;
FarPoint.Web.Spread.Borderbord=newFarPoint.Web.Spread.Border(BorderStyle.Double,Color.Tomato,3);
boolbl;
sv.SelectionModel.SetSelection(0,0,3,3);
bl=sv.SelectionModel.IsAnyCellInRowSelected(0);
sv.SelectionBackColor=Color.Yellow;
sv.SelectionForeColor=Color.Red;
sv.SelectionBorder=bord;
sv.SetValue(0,0,"Test");
ListBox1.Items.Add(Convert.ToString(bl)); | |
| Visual Basic | Copy Code |
|---|---|
DimsvAsFarPoint.Web.Spread.SheetView
DimbordAsNewFarPoint.Web.Spread.Border(BorderStyle.Double,Color.Tomato,3)
DimblAsBoolean
sv=FpSpread1.ActiveSheetView
sv.SelectionModel.SetSelection(0,0,3,3)
bl=sv.SelectionModel.IsAnyCellInRowSelected(0)
sv.SelectionBackColor=Color.Yellow
sv.SelectionForeColor=Color.Red
sv.SelectionBorder=bord
sv.SetValue(0,0,"Test")
ListBox1.Items.Add(bl) | |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
Reference
SheetView ClassSheetView Members
ISheetSelectionModel Interface