Spread WPF 15
GrapeCity.Windows.SpreadSheet.UI.UndoRedo Namespace / ColumnAutoFitExtent Class / ColumnAutoFitExtent Constructor
The column index.
Example


In This Topic
    ColumnAutoFitExtent Constructor
    In This Topic
    Creates a new instance of the class.
    Syntax
    'Declaration
     
    Public Function New( _
       ByVal column As Integer _
    )
    'Usage
     
    Dim column As Integer
     
    Dim instance As New ColumnAutoFitExtent(column)
    public ColumnAutoFitExtent( 
       int column
    )

    Parameters

    column
    The column index.
    Example
    This example uses automatic fit.
    //Add data
    for (var col = 1; col < 6; col++)
    {
        for (var row = 2; row < 11; row++)
        {
            GcSpreadSheet1.Sheets[0].SetValue(row, col, row + col);
        }
    }
    
    GcSpreadSheet1.CanUserUndo = true;     
    GrapeCity.Windows.SpreadSheet.UI.UndoRedo.ColumnAutoFitExtent[] columns;
    columns =  new GrapeCity.Windows.SpreadSheet.UI.UndoRedo.ColumnAutoFitExtent[] {new GrapeCity.Windows.SpreadSheet.UI.UndoRedo.ColumnAutoFitExtent(3)};
    var action = new GrapeCity.Windows.SpreadSheet.UI.UndoRedo.ColumnAutoFitUndoAction(GcSpreadSheet1.Sheets[0], columns, false);
    GcSpreadSheet1.DoCommand(action);
    'Add data
    For col As Integer = 1 To 6
        For row As Integer = 2 To 11
            GcSpreadSheet1.Sheets(0).SetValue(row, col, row + col)
        Next
    Next
    
    GcSpreadSheet1.CanUserUndo = True
    Dim columns() = {New GrapeCity.Windows.SpreadSheet.UI.UndoRedo.ColumnAutoFitExtent(3)}
    Dim action As New GrapeCity.Windows.SpreadSheet.UI.UndoRedo.ColumnAutoFitUndoAction(GcSpreadSheet1.Sheets(0), columns, False)
    GcSpreadSheet1.DoCommand(action)
    See Also