Spread Silverlight Documentation
RowAutoFitUndoAction Constructor
Example 


The sheet.
The automatically resized rows.
if set to true the row is in the column header.
Initializes a new instance of the RowAutoFitUndoAction class.
Syntax
'Declaration
 
Public Function New( _
   ByVal sheet As Worksheet, _
   ByVal rows() As RowAutoFitExtent, _
   ByVal columnHeader As System.Boolean _
)
'Usage
 
Dim sheet As Worksheet
Dim rows() As RowAutoFitExtent
Dim columnHeader As System.Boolean
 
Dim instance As New RowAutoFitUndoAction(sheet, rows, columnHeader)
public RowAutoFitUndoAction( 
   Worksheet sheet,
   RowAutoFitExtent[] rows,
   System.bool columnHeader
)

Parameters

sheet
The sheet.
rows
The automatically resized rows.
columnHeader
if set to true the row is in the column header.
Example
This example uses automatic fit.
//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);
'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.Windows.SpreadSheet.UI.UndoRedo.RowAutoFitExtent(2)}
Dim action As New GrapeCity.Windows.SpreadSheet.UI.UndoRedo.RowAutoFitUndoAction(GcSpreadSheet1.Sheets(0), rows, 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

RowAutoFitUndoAction Class
RowAutoFitUndoAction Members

 

 


Copyright © GrapeCity, inc. All rights reserved.