Spreadsheet history

All important changes in the spreadsheet are tracked under the History internal container. From version 8, the history is one array shared for all worksheets. In this section, we give a few more details about the spreadsheet changes tracker.

Documentation

Methods

The methods undo and redo are normally invoked by the keyboard shortcut CTRL+Z, CTRL+Y. The following methods can be called programmatically, as follow.
MethodDescription
undo() Undo the last spreadsheet changes.
undo() : void
redo() Redo the most recent spreadsheet changes.
redo() : void


Events

Events related to the history changes tracker.
EventDescription
onredo onredo(worksheet: Object, info: Object) : null
The info array contains all necessary information about the history and depends on which change was performed.
onundo onundo(worksheet: Object, info: Object) : null
The info array contains all necessary information about the history and depends on which change was performed.