//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)