Using Undo and Redo

You can use Ctrl + Z to undo an action in the widget. You can then use Ctrl + Y to redo the action you canceled.

You can undo the following types of actions:

Editing text
Autofit when double-clicking
Resizing headers
Dragging columns or rows with the mouse
Expanding or collapsing groups with the group button
Editing the sheet tab name by double-clicking on the tab strip
Using Ctrl + V to paste
Using the Commands class to execute an action

The following actions do not respond to Ctrl + Z:

Sorting or filtering with the drop-down button
Selecting a range
Navigating to a specific cell
Scrolling
Resizing the tab strip resize box
Clicking the new tab option on the tab strip

You can prevent or allow the undo action in code with the options.allowUndo property.

Using Code

This example sets the options.allowUndo property and specifies an action.

JavaScript	Copy Code
spread.options.allowUndo = true; spread.commandManager().execute({cmd: "outlineRow", sheetName: activeSheet.name(), index: 3, count: 5});

The following code can be used to undo or redo an action.

JavaScript	Copy Code
$(function () { var spread = new GC.Spread.Sheets.Workbook($("#ss")[0]); var activeSheet = spread.getActiveSheet(); spread.commandManager().execute({cmd: "outlineRow", sheetName: activeSheet.name(), index: 3, count: 5}); $("#button1").click(function () { if(spread.undoManager().canUndo()){ spread.undoManager().undo(); } }); $("#button2").click(function () { if(spread.undoManager().canRedo()){ spread.undoManager().redo(); } }); })

JavaScript

Copy Code

$(function () {
            var spread = new GC.Spread.Sheets.Workbook($("#ss")[0]);
            var activeSheet = spread.getActiveSheet();
            spread.commandManager().execute({cmd: "outlineRow", sheetName: activeSheet.name(), index: 3, count: 5});
            $("#button1").click(function () {
                if(spread.undoManager().canUndo()){
                    spread.undoManager().undo();
                }
            });

            $("#button2").click(function () {
                if(spread.undoManager().canRedo()){
                    spread.undoManager().redo();
                }
            });
        })