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


In This Topic
    RowHeaderAutoText Property
    In This Topic
    Gets or sets whether row headers on this sheet display letters or numbers or are blank.
    Syntax
    'Declaration
     
    Public Property RowHeaderAutoText As HeaderAutoText
    'Usage
     
    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
    Exceptions
    ExceptionDescription
    Specified header setting is not valid; must be one of the HeaderAutoText enumeration settings
    Remarks

    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).

    Example

    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