FarPoint.Win.Spread
GetColumnAutoSortIndex Method
See Also  Example
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : GetColumnAutoSortIndex Method


column
column index
Gets the auto sort index for the specified column.

Syntax

Visual Basic (Declaration) 
Public Function GetColumnAutoSortIndex( _
   ByVal column As Integer _
) As Integer
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim column As Integer
Dim value As Integer
 
value = instance.GetColumnAutoSortIndex(column)
C# 
public int GetColumnAutoSortIndex( 
   int column
)

Parameters

column
column index

Return Value

auto sort index

Example

This example gets the column index of the sort icon.
C#Copy Code
private void Form1_Load(object sender, EventArgs e)
       {
           fpSpread1.Sheets[0].ColumnHeader.RowCount = 3;
           fpSpread1.Sheets[0].ColumnHeaderAutoTextIndex = 1;
           fpSpread1.Sheets[0].Cells[0, 0].Text = "Testing";
           fpSpread1.Sheets[0].Columns[0, 2].AllowAutoSort = true;
           fpSpread1.Sheets[0].Columns[3].AllowAutoFilter = true;
           fpSpread1.Sheets[0].SetColumnAutoSortIndex(0, 0);
           fpSpread1.Sheets[0].SetColumnAutoFilterIndex(3, 1);          
       }

private void button1_Click(object sender, EventArgs e)
       {
           listBox1.Items.Add(fpSpread1.Sheets[0].GetColumnAutoSortIndex(0).ToString());
           listBox1.Items.Add(fpSpread1.Sheets[0].GetColumnAutoFilterIndex(3).ToString());         
       }
Visual BasicCopy Code
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        FpSpread1.Sheets(0).ColumnHeader.RowCount = 3
        FpSpread1.Sheets(0).ColumnHeaderAutoTextIndex = 1
        FpSpread1.Sheets(0).Cells(0, 0).Text = "Testing"
        FpSpread1.Sheets(0).Columns(0, 2).AllowAutoSort = True
        FpSpread1.Sheets(0).Columns(3).AllowAutoFilter = True
        FpSpread1.Sheets(0).SetColumnAutoSortIndex(0, 0)
        FpSpread1.Sheets(0).SetColumnAutoFilterIndex(3, 1)
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        ListBox1.Items.Add(FpSpread1.Sheets(0).GetColumnAutoSortIndex(0).ToString())
        ListBox1.Items.Add(FpSpread1.Sheets(0).GetColumnAutoFilterIndex(3).ToString())
End Sub

Remarks

The auto sort index is the row index in the column header where the auto sort indicator is drawn.

See Also