Gets or sets the selections for the sheet.

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 selections

Remarks

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.SheetView sv=FpSpread1.ActiveSheetView; FarPoint.Web.Spread.Border bord=new FarPoint.Web.Spread.Border(BorderStyle.Double,Color.Tomato,3); bool bl; 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));

Copy Code

FarPoint.Web.Spread.SheetView sv=FpSpread1.ActiveSheetView;
FarPoint.Web.Spread.Border bord=new FarPoint.Web.Spread.Border(BorderStyle.Double,Color.Tomato,3);
bool bl;
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
Dim sv As FarPoint.Web.Spread.SheetView Dim bord As New FarPoint.Web.Spread.Border(BorderStyle.Double,Color.Tomato,3) Dim bl As Boolean 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)

Visual Basic

Copy Code

Dim sv As FarPoint.Web.Spread.SheetView
Dim bord As New FarPoint.Web.Spread.Border(BorderStyle.Double,Color.Tomato,3)
Dim bl As Boolean
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 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Syntax

Property Value

Remarks

Example

Requirements

See Also

Reference

User-Task Documentation

Spread for ASP.NET 7.0 Product Documentation
SelectionModel Property
See Also Example Support Options