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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
