Spread for ASP.NET 9.0 Product Documentation
Row Property (CellRange)
Example 


Gets the row index of the first cell in the range.
Syntax
'Declaration
 
Public ReadOnly Property Row As Integer
'Usage
 
Dim instance As CellRange
Dim value As Integer
 
value = instance.Row
public int Row {get;}

Property Value

Integer index of the first row in the range
Example
This example creates a CellRange and uses it to set up a selection and a span in the spreadsheet. The several Intersect methods then query whether the selected range intersects the specified column and row 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,b1,b2;
FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.RowCount=10;
FpSpread1.ActiveSheetView.AddSpanCell(range.Row,range.Column,range.RowCount,range.ColumnCount);
b=range.IntersectColumn(1);
b1=range.IntersectRow(1);
b2=range.Intersects(0,0,4,4);
ListBox1.Items.Add(Convert.ToString(b));
ListBox1.Items.Add(Convert.ToString(b1));
ListBox1.Items.Add(Convert.ToString(b2));
Dim range As New FarPoint.Web.Spread.Model.CellRange(1,1,4,4)
Dim range1 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,b1,b2AsBoolean
FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.RowCount=10
FpSpread1.ActiveSheetView.AddSpanCell(range.Row,range.Column,range.RowCount,range.ColumnCount)
b=range.IntersectColumn(1)
b1=range.IntersectRow(1)
b2=range.Intersects(0,0,4,4)
ListBox1.Items.Add(b)
ListBox1.Items.Add(b1)
ListBox1.Items.Add(b2)
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

CellRange Class
CellRange Members

 

 


Copyright © GrapeCity, inc. All rights reserved.