Determines whether the range of cells is the same as another specified range of cells.
Syntax
Visual Basic (Usage) | Copy Code |
---|
Dim instance As CellRange
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim value As Boolean
value = instance.Equals(row, column, rowCount, columnCount) |
Parameters
- row
- Row index of first cell in the range
- column
- Column index of first cell in the range
- rowCount
- Number of rows in the range
- columnCount
- Number of columns in the range
Return Value
true if the two are identical;
false otherwise
Example
This example creates a CellRange and uses it to set up a selection in the sheet. The Equals method then queries whether the range is equal to the selection and the result is returned to a list box.
C# | Copy Code |
---|
FarPoint.Web.Spread.Model.CellRange range=new FarPoint.Web.Spread.Model.CellRange(0,0,4,4);
FarPoint.Web.Spread.Model.BaseSheetSelectionModel model;
model=(FarPoint.Web.Spread.Model.BaseSheetSelectionModel)FpSpread1.ActiveSheetView.SelectionModel;
FpSpread1.ActiveSheetView.SelectionBackColor=Color.Yellow;
model.AddSelection(range.Row,range.Column,range.RowCount,range.ColumnCount);
bool b;
FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.RowCount=10;
b=range.Equals(0,0,4,4);
ListBox1.Items.Add(b.ToString()); |
Visual Basic | Copy Code |
---|
Dim range As New FarPoint.Web.Spread.Model.CellRange(0,0,4,4)
Dim model As FarPoint.Web.Spread.Model.BaseSheetSelectionModel
model=FpSpread1.ActiveSheetView.SelectionModel
FpSpread1.ActiveSheetView.SelectionBackColor=Color.Yellow
model.AddSelection(range.Row,range.Column,range.RowCount,range.ColumnCount)
Dim b As Boolean
FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.RowCount=10
b=range.Equals(0,0,4,4)
ListBox1.Items.Add(b) |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also