Determines whether the range of cells contains another specified range of cells.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As CellRange
Dim range As CellRange
Dim value As Boolean
value = instance.Contains(range) |
Parameters
- range
- CellRange object that contains the other range of cells
Return Value
Boolean:
true if the cell range contains the specfied cell range;
false otherwise
Example
This example sets the background color of the cell range.
| C# | Copy Code |
|---|
FarPoint.Win.Spread.Model.CellRange cr = new FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3);
FarPoint.Win.Spread.Model.CellRange range = new FarPoint.Win.Spread.Model.CellRange(1, 1, 2, 2);
bool b;
b = cr.Contains(range);
if (b == true)
{
fpSpread1.ActiveSheet.Cells(cr.Row, cr.Column, cr.RowCount - 1, cr.ColumnCount - 1).BackColor = Color.Yellow;
} |
| Visual Basic | Copy Code |
|---|
Dim cr As New FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3)
Dim range As New FarPoint.Win.Spread.Model.CellRange(1, 1, 2, 2)
Dim b As Boolean
b = cr.Contains(range)
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
See Also
