Workbook.CancelChangeOperation Method

Stops tracking changes by the specified command and reverts all changes done so far.

Namespace: MindFusion.Spreadsheet.Wpf
Assembly: MindFusion.Spreadsheet.Wpf

 Syntax

C#

public void CancelChangeOperation (
    TrackChangesCommand command
)

Visual Basic

Public Sub CancelChangeOperation( _
    command As TrackChangesCommand _
)

 Parameters

command

The command to cancel.

 Remarks

The usual scenario for cancelling a command is when an exception happens while the command is active. The code below illustrates this scenario.

C#

var command = workbook.StartChangeOperation(worksheet);
try
{
    // Changes on the worksheet go here
    workbook.CommitChangeOperation(command);
}
catch
{
    workbook.CancelChangeOperation(command);
}

Visual Basic

Dim command = workbook.StartChangeOperation(worksheet)
Try

    ' Changes on the worksheet go here
    workbook.CommitChangeOperation(command)

Catch

    workbook.CancelChangeOperation(command)

End Try

Alternatively, the command can be cancelled by calling its Cancel method.