Spread Windows Forms 11.0 Product Documentation
Contains(CellRange) Method
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > CellRange Class > Contains Method : Contains(CellRange) Method
CellRange object that contains the other range of cells
Determines whether the range of cells contains another specified range of cells.
Syntax
'Declaration
 
Public Overloads Function Contains( _
   ByVal range As CellRange _
) As Boolean
'Usage
 
Dim instance As CellRange
Dim range As CellRange
Dim value As Boolean
 
value = instance.Contains(range)
public bool Contains( 
   CellRange range
)

Parameters

range
CellRange object that contains the other range of cells

Return Value

Boolean: true if the cell range contains the specified cell range; false otherwise
Example
This example sets the background color of the cell range.
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; 
}
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
See Also

Reference

CellRange Class
CellRange Members
Overload List