//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.RowAutoFitExtent[] rows;
rows = new GrapeCity.Windows.SpreadSheet.UI.UndoRedo.RowAutoFitExtent[] {new GrapeCity.Windows.SpreadSheet.UI.UndoRedo.RowAutoFitExtent(2)};
var action = new GrapeCity.Windows.SpreadSheet.UI.UndoRedo.RowAutoFitUndoAction(GcSpreadSheet1.Sheets[0], rows, false);
GcSpreadSheet1.DoCommand(action);