Determines whether the range of cells contains another specified range of cells.
Syntax
Visual Basic (Usage) | Copy Code |
---|
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) |
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# | Copy Code |
---|
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)); |
Visual Basic | Copy Code |
---|
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) |
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
See Also