Spread Silverlight Documentation
HorizontalAlignment Property (Column)
Example 


Gets or sets the horizontal alignment of the column contents.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property HorizontalAlignment As CellHorizontalAlignment
'Usage
 
Dim instance As Column
Dim value As CellHorizontalAlignment
 
instance.HorizontalAlignment = value
 
value = instance.HorizontalAlignment
[System.ComponentModel.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.Windows.SpreadSheet.Data.CellVerticalAlignment.Bottom;
GcSpreadSheet1.ActiveSheet.Columns[0].HorizontalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellHorizontalAlignment.Right;
GcSpreadSheet1.ActiveSheet.Rows[3].Height = 80;
GcSpreadSheet1.ActiveSheet.Rows[3].HorizontalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellHorizontalAlignment.Center;
GcSpreadSheet1.ActiveSheet.Rows[3].VerticalAlignment = GrapeCity.Windows.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.Windows.SpreadSheet.Data.CellVerticalAlignment.Bottom
GcSpreadSheet1.ActiveSheet.Columns(0).HorizontalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellHorizontalAlignment.Right
GcSpreadSheet1.ActiveSheet.Rows(3).Height = 80
GcSpreadSheet1.ActiveSheet.Rows(3).HorizontalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellHorizontalAlignment.Center
GcSpreadSheet1.ActiveSheet.Rows(3).VerticalAlignment = GrapeCity.Windows.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
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

Column Class
Column Members

 

 


Copyright © GrapeCity, inc. All rights reserved.