GrapeCity.Xaml.SpreadSheet.UI
RowAutoFitUndoAction Constructor
Example 


GrapeCity.Xaml.SpreadSheet.UI.UndoRedo Namespace > RowAutoFitUndoAction Class : RowAutoFitUndoAction Constructor
The sheet.
The automatically resized rows.
if set to true the row is in the column header.
Initializes a new instance of the RowAutoFitUndoAction class.
Syntax
'Declaration
 
Public Function New( _
   ByVal sheet As Worksheet, _
   ByVal rows() As RowAutoFitExtent, _
   ByVal columnHeader As Boolean _
)
'Usage
 
Dim sheet As Worksheet
Dim rows() As RowAutoFitExtent
Dim columnHeader As Boolean
 
Dim instance As New RowAutoFitUndoAction(sheet, rows, columnHeader)
public RowAutoFitUndoAction( 
   Worksheet sheet,
   RowAutoFitExtent[] rows,
   bool columnHeader
)

Parameters

sheet
The sheet.
rows
The automatically resized rows.
columnHeader
if set to true the row is in the column header.
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.Xaml.SpreadSheet.UI.UndoRedo.RowAutoFitExtent[] rows;
rows =  new GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.RowAutoFitExtent[] {new GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.RowAutoFitExtent(2)};
var action = new GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.RowAutoFitUndoAction(GcSpreadSheet1.Sheets[0], rows, 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 rows() = {New GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.RowAutoFitExtent(2)}
Dim action As New GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.RowAutoFitUndoAction(GcSpreadSheet1.Sheets(0), rows, False)
GcSpreadSheet1.DoCommand(action)
See Also

Reference

RowAutoFitUndoAction Class
RowAutoFitUndoAction Members