GrapeCity.Xaml.SpreadSheet.UI
RowResizeUndoAction Constructor
Example 


GrapeCity.Xaml.SpreadSheet.UI.UndoRedo Namespace > RowResizeUndoAction Class : RowResizeUndoAction Constructor
The sheet.
The resize rows.
The resize size.
Whether the row being resized is in the column header area.
Creates a new undo action for row resizing.
Syntax
'Declaration
 
Public Function New( _
   ByVal sheetView As Worksheet, _
   ByVal rows() As RowResizeExtent, _
   ByVal size As Double, _
   ByVal columnHeader As Boolean _
)
'Usage
 
Dim sheetView As Worksheet
Dim rows() As RowResizeExtent
Dim size As Double
Dim columnHeader As Boolean
 
Dim instance As New RowResizeUndoAction(sheetView, rows, size, columnHeader)
public RowResizeUndoAction( 
   Worksheet sheetView,
   RowResizeExtent[] rows,
   double size,
   bool columnHeader
)

Parameters

sheetView
The sheet.
rows
The resize rows.
size
The resize size.
columnHeader
Whether the row being resized is in the column header area.
Example
This example resizes rows.
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)
See Also

Reference

RowResizeUndoAction Class
RowResizeUndoAction Members