GrapeCity.Xaml.SpreadSheet.UI
ClearValueUndoAction Constructor
Example 


GrapeCity.Xaml.SpreadSheet.UI.UndoRedo Namespace > ClearValueUndoAction Class : ClearValueUndoAction Constructor
The worksheet to clear values on.
The clear value cell ranges.
Creates a new instance of the ClearValueUndoAction class.
Syntax
'Declaration
 
Public Function New( _
   ByVal sheet As Worksheet, _
   ByVal ranges() As CellRange _
)
'Usage
 
Dim sheet As Worksheet
Dim ranges() As CellRange
 
Dim instance As New ClearValueUndoAction(sheet, ranges)
public ClearValueUndoAction( 
   Worksheet sheet,
   CellRange[] ranges
)

Parameters

sheet
The worksheet to clear values on.
ranges
The clear value cell ranges.
Example
This example clears cell values.
 //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.Data.CellRange[] srange;
srange = new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.SpreadSheet.Data.CellRange(10, 5, 1, 1) };
var action = new GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.ClearValueUndoAction(GcSpreadSheet1.Sheets[0], srange);
GcSpreadSheet1.DoCommand(action);
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 srange As GrapeCity.Xaml.SpreadSheet.Data.CellRange()
srange = New GrapeCity.Xaml.SpreadSheet.Data.CellRange() {New GrapeCity.Xaml.SpreadSheet.Data.CellRange(10, 5, 1, 1)}
Dim action As New GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.ClearValueUndoAction(GcSpreadSheet1.Sheets(0), srange)
GcSpreadSheet1.DoCommand(action)
See Also

Reference

ClearValueUndoAction Class
ClearValueUndoAction Members