Spread for ASP.NET 9.0 Product Documentation
Index2 Property (Column)
Example 


Gets the ending index for this range of columns.
Syntax
'Declaration
 
Public ReadOnly Property Index2 As Integer
'Usage
 
Dim instance As Column
Dim value As Integer
 
value = instance.Index2
public int Index2 {get;}

Property Value

Integer index (zero-based) of the column at the end of the range
Remarks
Use the Index property to specify the starting index for the range.
Example
This example creates a multiple Column object and adjusts the alignment of the text in the column. The height of the rows are changed so that the alignment changes can be seen easily. The ending index (Index2) of the Column object is returned to a text box.
FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.PageSize=20;
FpSpread1.ActiveSheetView.RowCount=20;
FarPoint.Web.Spread.Column mycol;
mycol=FpSpread1.ActiveSheetView.Columns[1,3];
mycol.HorizontalAlign=HorizontalAlign.Right;
mycol.VerticalAlign=VerticalAlign.Top;
for(int i=0;i<FpSpread1.ActiveSheetView.RowCount;i++)
{
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment");
FpSpread1.ActiveSheetView.Rows[i].Height=80;
}

TextBox1.Text=Convert.ToString(mycol.Index2);
FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.PageSize=20
FpSpread1.ActiveSheetView.RowCount=20
Dim mycol As FarPoint.Web.Spread.Column
Dim i As Integer
mycol=FpSpread1.ActiveSheetView.Columns(1,3)
mycol.HorizontalAlign=HorizontalAlign.Right
mycol.VerticalAlign=VerticalAlign.Top
For i=0 To FpSpread1.ActiveSheetView.RowCount-1
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment")
FpSpread1.ActiveSheetView.Rows(i).Height=80
Next i
TextBox1.Text=Convert.ToString(mycol.Index2)
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

Column Class
Column Members
Index Property

 

 


Copyright © GrapeCity, inc. All rights reserved.