Equals(Int32,Int32,Int32,Int32) Method

In This Topic

Determines whether the range of cells is the same as another specified range of cells.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function Equals( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
) As Boolean

'Usage
 
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)

public bool Equals( 
   int row,
   int column,
   int rowCount,
   int 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.

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

Dim range As NewF arPoint.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)

Reference

CellRange Class
CellRange Members
Overload List

Product Support Forum | Print this page