Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Function New( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal rowCount As Integer, _ ByVal columnCount As Integer _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim row As Integer Dim column As Integer Dim rowCount As Integer Dim columnCount As Integer Dim instance As New CellRange(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
Example
This example uses a CellRange to create a span in the sheet. The values returned from several of the methods of the range are put in a list box.
| C# | Copy Code |
|---|---|
FarPoint.Web.Spread.Model.CellRange range=new FarPoint.Web.Spread.Model.CellRange(0,0,4,4); bool b; FpSpread1.ActiveSheetView.ColumnCount=10; FpSpread1.ActiveSheetView.RowCount=10; FpSpread1.ActiveSheetView.AddSpanCell(range.Row,range.Column,range.RowCount,range.ColumnCount); b=range.Contains(1,1); ListBox1.Items.Add(Convert.ToString(b)); | |
| Visual Basic | Copy Code |
|---|---|
Dim range As New FarPoint.Web.Spread.Model.CellRange(0,0,4,4) Dim b As Boolean FpSpread1.ActiveSheetView.ColumnCount=10 FpSpread1.ActiveSheetView.RowCount=10 FpSpread1.ActiveSheetView.AddSpanCell(range.Row,range.Column,range.RowCount,range.ColumnCount) b=range.Contains(1,1) 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