Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / RowHeaderAutoText Property

In This Topic
    RowHeaderAutoText Property
    In This Topic
    Gets or sets whether row headers on this sheet display letters or numbers or are blank.
    Public Property RowHeaderAutoText As HeaderAutoText
    Dim instance As SheetView
    Dim value As HeaderAutoText
    instance.RowHeaderAutoText = value
    value = instance.RowHeaderAutoText
    public HeaderAutoText RowHeaderAutoText {get; set;}

    Property Value

    HeaderAutoText setting that determines what to display in the row header
    Specified header setting is not valid; must be one of the HeaderAutoText enumeration settings

    The automatic text is the text automatically assigned to header cells by the component. Use this property to change the automatic text to blank or to letters.

    This property is equivalent to the RowHeader.AutoText property.

    If your header has multiple row header columns, you can specify which header column displays the automatic text by setting the RowHeaderAutoTextIndex property (or the RowHeader.AutoTextIndex property).


    This example sets up a number of column and row headers for the spreadsheet and changes the location of the header text and its type.

    fpSpread1.ActiveSheet.ColumnHeader.RowCount = 3;
    fpSpread1.ActiveSheet.RowHeader.ColumnCount = 2;
    fpSpread1.ActiveSheet.ColumnHeaderAutoText = FarPoint.Win.Spread.HeaderAutoText.Numbers;
    fpSpread1.ActiveSheet.ColumnHeaderAutoTextIndex = 0;
    fpSpread1.ActiveSheet.RowHeaderAutoText = FarPoint.Win.Spread.HeaderAutoText.Letters;
    fpSpread1.ActiveSheet.RowHeaderAutoTextIndex = 0;
    FpSpread1.ActiveSheet.ColumnHeader.RowCount = 3
    FpSpread1.ActiveSheet.RowHeader.ColumnCount = 2
    FpSpread1.ActiveSheet.ColumnHeaderAutoText = FarPoint.Win.Spread.HeaderAutoText.Numbers
    FpSpread1.ActiveSheet.ColumnHeaderAutoTextIndex = 0
    FpSpread1.ActiveSheet.RowHeaderAutoText = FarPoint.Win.Spread.HeaderAutoText.Letters
    FpSpread1.ActiveSheet.RowHeaderAutoTextIndex = 0
    See Also