IsAnyCellInColumnSelected Method (DefaultSheetSelectionModel)

Determines whether any cell in a specified column is in the selection.

Syntax

Visual Basic
C#

'Declaration
 
Public Overrides Function IsAnyCellInColumnSelected( _
   ByVal column As Integer _
) As Boolean

'Usage
 
Dim instance As DefaultSheetSelectionModel
Dim column As Integer
Dim value As Boolean
 
value = instance.IsAnyCellInColumnSelected(column)

public override bool IsAnyCellInColumnSelected( 
   int column
)

Parameters

column: Column to check

Return Value

true if any cell in the specified column is selected; false otherwise

Example

This example uses a DefaultSheetSelectionModel as the SelectionModel of the spreadsheet. A selection is added to object, and then several of the methods and properties are set and the values returned to a list box. The selection can be removed in a button click event.

private void Page_Load(object sender, System.EventArgs e)
{
   if (this.IsPostBack) return;

 FpSpread1.ActiveSheetView.ColumnCount = 8;
 FpSpread1.ActiveSheetView.RowCount = 10;
 FpSpread1.ActiveSheetView.SelectionBackColor = Color.Yellow;
 FarPoint.Web.Spread.Model.ISheetSelectionModel model = FpSpread1.ActiveSheetView.SelectionModel;
 
 bool b1, b2, b3;
 int i1;
 model.AddSelection(0, 0, 3, 3);
 b1 = model.IsAnyCellInColumnSelected(2);
 b2 = model.IsAnyCellInRowSelected(2);
 b3 = model.IsSelected(1,1);
 i1 = model.Count;
 ListBox1.Items.Add(Convert.ToString(b1));
 ListBox1.Items.Add(Convert.ToString(b2));
 ListBox1.Items.Add(Convert.ToString(b3));
 ListBox1.Items.Add(Convert.ToString(i1));
}

private void Button1_Click(object sender, System.EventArgs e)
{
 FarPoint.Web.Spread.Model.ISheetSelectionModel model = FpSpread1.Sheets[0].SelectionModel;
 model.RemoveSelection(0, 0, 3, 3);
}

Visual Basic

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
   If (IsPostBack) Then Return

   Dim b1, b2, b3 As Boolean
   Dim i1 As Integer
   FpSpread1.ActiveSheetView.ColumnCount = 8
   FpSpread1.ActiveSheetView.RowCount = 10
   FpSpread1.ActiveSheetView.SelectionBackColor = Color.Yellow
   Dim model As FarPoint.Web.Spread.Model.ISheetSelectionModel = FpSpread1.Sheets(0).SelectionModel
   model.AddSelection(0, 0, 3, 3)
   b1 = model.IsAnyCellInColumnSelected(2)
   b2 = model.IsAnyCellInRowSelected(2)
   b3 = model.IsSelected(1,1)
   i1 = model.Count
   ListBox1.Items.Add(b1)
   ListBox1.Items.Add(b2)
   ListBox1.Items.Add(b3)
   ListBox1.Items.Add(i1)

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
   Dim model As FarPoint.Web.Spread.Model.ISheetSelectionModel = FpSpread1.Sheets(0).SelectionModel
   model.RemoveSelection(0, 0, 3, 3)
End Sub

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

DefaultSheetSelectionModel Class
DefaultSheetSelectionModel Members
IsAnyCellInColumnSelected Method
IsSelected Method