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.RowResizeExtent[] rows;
rows = new GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.RowResizeExtent[] { new GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.RowResizeExtent(2, 4) };
var action = new GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.RowResizeUndoAction(GcSpreadSheet1.Sheets[0], rows, 50, 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.RowResizeExtent(2, 4)}
Dim action As New GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.RowResizeUndoAction(GcSpreadSheet1.Sheets(0), rows, 50, False)
GcSpreadSheet1.DoCommand(action)