Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.UI.UndoRedo Namespace / ClearValueUndoAction Class / ClearValueUndoAction Constructor
The worksheet to clear values on.
The clear value cell ranges.
Example


In This Topic
    ClearValueUndoAction Constructor
    In This Topic
    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