Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / RowHeader Class / ColumnCount Property
Example


In This Topic
    ColumnCount Property (RowHeader)
    In This Topic
    Gets or sets the number of columns in the row header.
    Syntax
    'Declaration
     
    Public Property ColumnCount As Integer
    'Usage
     
    Dim instance As RowHeader
    Dim value As Integer
     
    instance.ColumnCount = value
     
    value = instance.ColumnCount
    public int ColumnCount {get; set;}

    Property Value

    Integer number of columns in the header
    Exceptions
    ExceptionDescription
    Specified column count is less than 0 or greater than 256.
    Remarks

    Use this property to specify the number of columns in the row header. When you set this property to a value greater than 1, additional columns are added to the row header. The maximum value allowed is 256. The minimum value allowed is 0.

    This property is equivalent to the SheetView RowHeaderColumnCount.

    The added columns display the row header appearance (the background, text, and border colors) but are blank by default. Use the Text property to add content to the additional columns.

    If you set this property to a value greater than 1, you can specify which column displays the automatic text by setting the AutoTextIndex property. The right-most header column displays the automatic text, as defined in the AutoText property, unless another header column is specified by the AutoTextIndex property.

    This property does not have an effect unless the Visible property (or the SheetView RowHeaderVisible property) is set to true and the row header columns are not hidden.

    Tip: If the Spread component displays multiple header columns such that the row headers fill the entire view of the spreadsheet, users cannot scroll to the data portion of the spreadsheet. Keep this in mind when sizing the Spread component and adding multiple row header columns.

    Set the ColumnHeader RowCount property (or SheetView ColumnHeaderRowCount property) to specify the number of rows to display as the column header.

    For more information about headers with multiple columns or rows, see Creating a Header with Multiple Rows or Columns.

    Example
    This example sets the row header to have four columns and changes the background color of the first four row headers.
    Dim r As FarPoint.Win.Spread.RowHeader
    r = FpSpread1.ActiveSheet.RowHeader
    r.ColumnCount = 4
    r.Cells(0, 0, 3, 3).BackColor = Color.Teal
    FarPoint.Win.Spread.RowHeader r;
    r = fpSpread1.ActiveSheet.RowHeader;
    r.ColumnCount = 4; 
    r.Cells[0, 0, 3, 3].BackColor = Color.Teal;
    See Also