Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / ColumnHeader Class / AutoTextIndex Property
Example


In This Topic
    AutoTextIndex Property (ColumnHeader)
    In This Topic
    Gets or sets which header row displays the automatic text when there are multiple header rows.
    Syntax
    'Declaration
     
    <DefaultValueAttribute(0)>
    Public Overrides NotOverridable Property AutoTextIndex As Integer
    'Usage
     
    Dim instance As ColumnHeader
    Dim value As Integer
     
    instance.AutoTextIndex = value
     
    value = instance.AutoTextIndex
    [DefaultValue(0)]
    public override int AutoTextIndex {get; set;}

    Property Value

    The row index of the header that displays the automatic text. The default value is 0.
    Example
    This example uses the AutoTextIndex property.
    gcSpreadSheet1.Sheets[0].ColumnHeader.RowCount = 2;
    gcSpreadSheet1.Sheets[0].RowHeader.ColumnCount = 2;
    gcSpreadSheet1.Sheets[0].ColumnHeader.Cells(0, 2).Text = "Column";
    gcSpreadSheet1.Sheets[0].RowHeader.AutoTextIndex = 1;
    gcSpreadSheet1.Sheets[0].RowHeader.AutoText = GrapeCity.Windows.SpreadSheet.Data.HeaderAutoText.Letters;
    gcSpreadSheet1.Sheets[0].ColumnHeader.AutoTextIndex = 1;
    gcSpreadSheet1.Sheets[0].ColumnHeader.AutoText = GrapeCity.Windows.SpreadSheet.Data.HeaderAutoText.Numbers;
    gcSpreadSheet1.Invalidate();
    GcSpreadSheet1.Sheets(0).ColumnHeader.RowCount = 2
    GcSpreadSheet1.Sheets(0).RowHeader.ColumnCount = 2
    GcSpreadSheet1.Sheets(0).ColumnHeader.Cells(0, 2).Text = "Column"
    GcSpreadSheet1.Sheets(0).RowHeader.AutoTextIndex = 1
    GcSpreadSheet1.Sheets(0).RowHeader.AutoText = GrapeCity.Windows.SpreadSheet.Data.HeaderAutoText.Letters
    GcSpreadSheet1.Sheets(0).ColumnHeader.AutoTextIndex = 1
    GcSpreadSheet1.Sheets(0).ColumnHeader.AutoText = GrapeCity.Windows.SpreadSheet.Data.HeaderAutoText.Numbers
    GcSpreadSheet1.Invalidate()
    See Also