Contains(Int32,Int32,Int32,Int32) Method

In This Topic

Determines whether the range of cells contains another specified range of cells.

Syntax

Visual Basic
C#

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

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

public bool Contains( 
   int row,
   int column,
   int rowCount,
   int columnCount
)

Parameters

row: Row index of the first cell in the range
column: Column index of the first cell in the range
rowCount: Number of rows in the range
columnCount: Number of columns in the range

Return Value

true if the range contains the other range; false otherwise

Example

This example uses a CellRange to create a span in the sheet. The values returned from several of the methods of the range are put in a list box.

C#
Visual Basic

FarPoint.Web.Spread.Model.CellRange range=new FarPoint.Web.Spread.Model.CellRange(0,0,4,4);
bool b;
FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.RowCount=10;
FpSpread1.ActiveSheetView.AddSpanCell(range.Row,range.Column,range.RowCount,range.ColumnCount);
b=range.Contains(0,0,2,2);
ListBox1.Items.Add(Convert.ToString(b));

Dim range As New FarPoint.Web.Spread.Model.CellRange(0,0,4,4)
Dim b As Boolean
FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.RowCount=10
FpSpread1.ActiveSheetView.AddSpanCell(range.Row,range.Column,range.RowCount,range.ColumnCount)
b=range.Contains(0,0,2,2)
ListBox1.Items.Add(b)

Reference

CellRange Class
CellRange Members
Overload List