Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Column Class / HorizontalAlignment Property
Example


In This Topic
    HorizontalAlignment Property (Column)
    In This Topic
    Gets or sets the default horizontal alignment for cells in this column.
    Syntax
    'Declaration
     
    Public Property HorizontalAlignment As CellHorizontalAlignment
    'Usage
     
    Dim instance As Column
    Dim value As CellHorizontalAlignment
     
    instance.HorizontalAlignment = value
     
    value = instance.HorizontalAlignment
    public CellHorizontalAlignment HorizontalAlignment {get; set;}

    Property Value

    CellHorizontalAlignment object containing the horizontal alignment for cell contents
    Remarks

    The HorizontalAlignment and VerticalAlignment properties determine the alignment of the cell's content (that is, the text) which is independent of the alignment of the cell's background image. The Picture class has a constructor for supplying alignment of the background image.

    Valid values for this property are the horizontal alignment settings listed in the HorizontalAlign enumeration in the Microsoft .NET Framework Reference.  The Distributed enumeration adds space between the words so that they evenly fill the cell.

    For more information on cell types, refer to the FarPoint.Spread.CellType namespace and to Customizing with Cell Types.

    The setting for this property can be overridden if a named style is assigned to the cell using the StyleName property, and that named style sets the horizontal alignment.

    Use the VerticalAlignment property to specify the vertical alignment of the object or text.

    Example
    This example specifies the text alignment for the column.
    FarPoint.Win.Spread.Column col;
    fpSpread1.ActiveSheet.Cells[0, 0].Text = "Alignment";
    col = fpSpread1.ActiveSheet.Columns[0];
    col.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
    col.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center;
    col.Width = 120;
    fpSpread1.ActiveSheet.Rows[0].Height = 60;
    Dim col As FarPoint.Win.Spread.Column
    fpSpread1.ActiveSheet.Cells(0, 0).Text = "Alignment"
    col = fpSpread1.ActiveSheet.Columns(0)
    col.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right
    col.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center
    col.Width = 120
    fpSpread1.ActiveSheet.Rows(0).Height = 60
    See Also

    Reference

    Column Class
    Column Members

    User-Task Documentation

    Aligning Cell Contents