GrapeCity.Xaml.SpreadSheet.Data
HorizontalAlignment Property (Column)
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > Column Class : HorizontalAlignment Property
Gets or sets the horizontal alignment of the column contents.
Syntax
'Declaration
 
<DefaultValueAttribute()>
Public Property HorizontalAlignment As CellHorizontalAlignment
'Usage
 
Dim instance As Column
Dim value As CellHorizontalAlignment
 
instance.HorizontalAlignment = value
 
value = instance.HorizontalAlignment
[DefaultValue()]
public CellHorizontalAlignment HorizontalAlignment {get; set;}

Property Value

A CellHorizontalAlignment object that specifies the horizontal alignment for the column. The default value is General.
Example
This example sets the HorizontalAlignment property.
GcSpreadSheet1.ActiveSheet.Columns[0].Width = 50;
GcSpreadSheet1.ActiveSheet.Columns[0].VerticalAlignment = GrapeCity.Xaml.SpreadSheet.Data.CellVerticalAlignment.Bottom;
GcSpreadSheet1.ActiveSheet.Columns[0].HorizontalAlignment = GrapeCity.Xaml.SpreadSheet.Data.CellHorizontalAlignment.Right;
GcSpreadSheet1.ActiveSheet.Rows[3].Height = 80;
GcSpreadSheet1.ActiveSheet.Rows[3].HorizontalAlignment = GrapeCity.Xaml.SpreadSheet.Data.CellHorizontalAlignment.Center;
GcSpreadSheet1.ActiveSheet.Rows[3].VerticalAlignment = GrapeCity.Xaml.SpreadSheet.Data.CellVerticalAlignment.Top;

private void button1_Click(object sender, RoutedEventArgs e)
{
        GcSpreadSheet1.ActiveSheet.Columns[0].ResetWidth();
        GcSpreadSheet1.ActiveSheet.Columns[0].ResetVerticalAlignment();
        GcSpreadSheet1.ActiveSheet.Columns[0].ResetHorizontalAlignment();
        GcSpreadSheet1.ActiveSheet.Rows[3].ResetHeight();
        GcSpreadSheet1.ActiveSheet.Rows[3].ResetHorizontalAlignment();
        GcSpreadSheet1.ActiveSheet.Rows[3].ResetVerticalAlignment();
}
GcSpreadSheet1.ActiveSheet.Columns(0).Width = 50
GcSpreadSheet1.ActiveSheet.Columns(0).VerticalAlignment = GrapeCity.Xaml.SpreadSheet.Data.CellVerticalAlignment.Bottom
GcSpreadSheet1.ActiveSheet.Columns(0).HorizontalAlignment = GrapeCity.Xaml.SpreadSheet.Data.CellHorizontalAlignment.Right
GcSpreadSheet1.ActiveSheet.Rows(3).Height = 80
GcSpreadSheet1.ActiveSheet.Rows(3).HorizontalAlignment = GrapeCity.Xaml.SpreadSheet.Data.CellHorizontalAlignment.Center
GcSpreadSheet1.ActiveSheet.Rows(3).VerticalAlignment = GrapeCity.Xaml.SpreadSheet.Data.CellVerticalAlignment.Top


Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
        GcSpreadSheet1.ActiveSheet.Columns(0).ResetWidth()
        GcSpreadSheet1.ActiveSheet.Columns(0).ResetVerticalAlignment()
        GcSpreadSheet1.ActiveSheet.Columns(0).ResetHorizontalAlignment()
        GcSpreadSheet1.ActiveSheet.Rows(3).ResetHeight()
        GcSpreadSheet1.ActiveSheet.Rows(3).ResetHorizontalAlignment()
        GcSpreadSheet1.ActiveSheet.Rows(3).ResetVerticalAlignment()
    End Sub
See Also

Reference

Column Class
Column Members