Spread Silverlight Documentation
ColumnResizeUndoAction Constructor
Example 


The sheet.
The resize columns.
The resized size.
Whether the column being resized is in the row header area.
Creates a new undo action for column resizing.
Syntax
'Declaration
 
Public Function New( _
   ByVal sheet As Worksheet, _
   ByVal columns() As ColumnResizeExtent, _
   ByVal size As System.Double, _
   ByVal rowHeader As System.Boolean _
)
'Usage
 
Dim sheet As Worksheet
Dim columns() As ColumnResizeExtent
Dim size As System.Double
Dim rowHeader As System.Boolean
 
Dim instance As New ColumnResizeUndoAction(sheet, columns, size, rowHeader)
public ColumnResizeUndoAction( 
   Worksheet sheet,
   ColumnResizeExtent[] columns,
   System.double size,
   System.bool rowHeader
)

Parameters

sheet
The sheet.
columns
The resize columns.
size
The resized size.
rowHeader
Whether the column being resized is in the row header area.
Example
This example resizes columns.
//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.ColumnResizeExtent[] columns;
columns =  new GrapeCity.Windows.SpreadSheet.UI.UndoRedo.ColumnResizeExtent[] {new GrapeCity.Windows.SpreadSheet.UI.UndoRedo.ColumnResizeExtent(2, 4)};
var action = new GrapeCity.Windows.SpreadSheet.UI.UndoRedo.ColumnResizeUndoAction(GcSpreadSheet1.Sheets[0], columns, 100, 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 columns() = {New GrapeCity.Windows.SpreadSheet.UI.UndoRedo.ColumnResizeExtent(2, 4)}
Dim action As New GrapeCity.Windows.SpreadSheet.UI.UndoRedo.ColumnResizeUndoAction(GcSpreadSheet1.Sheets(0), columns, 100, False)
GcSpreadSheet1.DoCommand(action)
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

ColumnResizeUndoAction Class
ColumnResizeUndoAction Members

 

 


Copyright © GrapeCity, inc. All rights reserved.