GrapeCity.Xaml.SpreadSheet.UI
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 Double, _
   ByVal rowHeader As Boolean _
)
'Usage
 
Dim sheet As Worksheet
Dim columns() As ColumnResizeExtent
Dim size As Double
Dim rowHeader As Boolean
 
Dim instance As New ColumnResizeUndoAction(sheet, columns, size, rowHeader)
public ColumnResizeUndoAction( 
   Worksheet sheet,
   ColumnResizeExtent[] columns,
   double size,
   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.Xaml.SpreadSheet.UI.UndoRedo.ColumnResizeExtent[] columns;
columns =  new GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.ColumnResizeExtent[] {new GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.ColumnResizeExtent(2, 4)};
var action = new GrapeCity.Xaml.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.Xaml.SpreadSheet.UI.UndoRedo.ColumnResizeExtent(2, 4)}
Dim action As New GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.ColumnResizeUndoAction(GcSpreadSheet1.Sheets(0), columns, 100, False)
GcSpreadSheet1.DoCommand(action)
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

ColumnResizeUndoAction Class
ColumnResizeUndoAction Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options