Determines whether the range of cells contains the cell at the specified row and column.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As CellRange
Dim row As Integer
Dim column As Integer
Dim value As Boolean
value = instance.Contains(row, column) |
Parameters
- row
- Row index of the cell
- column
- Column index of the cell
Return Value
Boolean:
true if the cell range contains the cells;
false otherwise
Example
This example sets the backcolor of the cell range.
| C# | Copy Code |
|---|
FarPoint.Win.Spread.Model.CellRange cr = new FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3);
bool b;
b = cr.Contains(2, 2);
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 b As Boolean
b = cr.Contains(2, 2)
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
