GrapeCity.Xaml.SpreadSheet.Data
CellRange Constructor
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > CellRange Class : CellRange Constructor
The row index of the first cell in the range.
The column index of the first cell in the range.
The number of rows in the range.
The number of columns in the range.
Creates a range of cells.
Syntax
'Declaration
 
Public Function New( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
)
'Usage
 
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)
public CellRange( 
   int row,
   int column,
   int rowCount,
   int columnCount
)

Parameters

row
The row index of the first cell in the range.
column
The column index of the first cell in the range.
rowCount
The number of rows in the range.
columnCount
The number of columns in the range.
Example
This example uses a cell range.
GrapeCity.Xaml.SpreadSheet.Data.CellRange r;
r = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 3, 3);
gcSpreadSheet1.Sheets[0].AddSpanCell(r, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells);
//gcSpreadSheet1.Sheets[0].AddSpanCell(1, 1, 3, 3);
//gcSpreadSheet1.Sheets[0].AddSpanCell(4, 0, 2, 2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells);

gcSpreadSheet1.Sheets[0].RowHeader.ColumnCount = 2;
gcSpreadSheet1.Sheets[0].ColumnHeader.RowCount = 2;
GrapeCity.Xaml.SpreadSheet.Data.CellRange r2;
r2 = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 2, 2);
gcSpreadSheet1.Sheets[0].AddSpanCell(r2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader);
Dim r As GrapeCity.Xaml.SpreadSheet.Data.CellRange
r = New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 3, 3)
GcSpreadSheet1.Sheets(0).AddSpanCell(r, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells)
' GcSpreadSheet1.Sheets(0).AddSpanCell(1, 1, 3, 3)
' GcSpreadSheet1.Sheets(0).AddSpanCell(4, 0, 2, 2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells)
GcSpreadSheet1.Sheets(0).RowHeader.ColumnCount = 2
GcSpreadSheet1.Sheets(0).ColumnHeader.RowCount = 2
Dim r2 As GrapeCity.Xaml.SpreadSheet.Data.CellRange
r2 = New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 2, 2)
GcSpreadSheet1.Sheets(0).AddSpanCell(r2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader)
See Also

Reference

CellRange Class
CellRange Members