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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
