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.CellRangerange=newFarPoint.Web.Spread.Model.CellRange(0,0,4,4);
boolb;
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 |
|---|
DimrangeAsNewFarPoint.Web.Spread.Model.CellRange(0,0,4,4)
DimbAsBoolean
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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
