Contains(Int32,Int32) Method

Determines whether the range of cells contains the cell at the specified row and column.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function Contains( _
   ByVal row As Integer, _
   ByVal column As Integer _
) As Boolean

'Usage
 
Dim instance As CellRange
Dim row As Integer
Dim column As Integer
Dim value As Boolean
 
value = instance.Contains(row, column)

public bool Contains( 
   int row,
   int column
)

Parameters

row: Row index of the cell
column: Column index of the cell

Return Value

Boolean: true if the cell range contains the cells; false otherwise

Example

This example sets the backcolor of the cell range.

FarPoint.Win.Spread.Model.CellRange cr = new FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3); 
bool b; 
b = cr.Contains(2, 2); 
if (b == true) 
{ 
fpSpread1.ActiveSheet.Cells(cr.Row, cr.Column, cr.RowCount - 1, cr.ColumnCount - 1).BackColor = Color.Yellow; 
}

Visual Basic

Dim cr As New FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3) 
Dim b As Boolean 
b = cr.Contains(2, 2) 
If b = True Then 
FpSpread1.ActiveSheet.Cells(cr.Row, cr.Column, cr.RowCount - 1, cr.ColumnCount - 1).BackColor = Color.Yellow 
End If

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

Reference

CellRange Class
CellRange Members
Overload List