Gets the ending index for this range of columns.
Syntax
| Visual Basic (Declaration) | |
|---|
Public ReadOnly Property Index2 As Integer |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Column
Dim value As Integer
value = instance.Index2 |
| C# | |
|---|
public int Index2 {get;} |
Property Value
Integer index (zero-based) of the column at the end of the range
Remarks
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.
| C# | Copy Code |
|---|
FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.PageSize=20;
FpSpread1.ActiveSheetView.RowCount=20;
FarPoint.Web.Spread.Columnmycol;
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); |
| Visual Basic | Copy Code |
|---|
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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
