Undo and Redo

By using the undo and redo features, you can flexibly revert or reapply recent changes, allowing you to quickly correct mistakes or review previous data entries. You can use the shortcut keys [Ctrl] + [Z] to undo actions and [Ctrl] + [Y] to redo actions, which apply to a variety of operations.

By default, the system allows you to undo or redo up to the last 100 consecutive actions. You can customize the maximum number of undo and redo operations by setting the Limit property of the CommandManager class. Setting the Limit property to 0 will disable the undo and redo functionality.

The following sample code demonstrates how to disable the undo/redo functionality in a workbook:

C#

// Disable undo/redo functionality.
spreadSheet1.Workbook.WorkbookSet.CommandManager.Limit = 0;

VB

' Disable undo/redo functionality.
spreadSheet1.Workbook.WorkbookSet.CommandManager.Limit = 0