GrapeCity.Xaml.SpreadSheet.Data
ResetWidth Method
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > Column Class : ResetWidth Method
Resets the column to inherit the width from the default column.
Syntax
'Declaration
 
Public Sub ResetWidth() 
'Usage
 
Dim instance As Column
 
instance.ResetWidth()
public void ResetWidth()
Example
This example uses the ResetWidth method.
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