TdxSpreadSheetHistory Class

Stores and manages the undo and redo action lists in spreadsheet controls.

Declaration

TdxSpreadSheetHistory = class(
    TdxSpreadSheetPersistentObject
)

Remarks

A spreadsheet control records history action performed in an opened spreadsheet document if the control’s OptionsBehavior.History property is set to True.

The TdxSpreadSheetHistory class has the following members that allow you to:

Limit the number of stored undo and redo actions (MaxActionCount).
Identify the number of actions stored in undo and redo lists (UndoActionCount and RedoActionCount).
Access the undo and redo action lists (UndoActions and RedoActions).
Add a custom change command to the undo action list (AddCommand).
Record a large series of document changes as a single history action (BeginAction and EndAction).
Clear the both action lists (Clear).
Undo one or more recorded actions (Undo).
Restore one or more of the previously undone actions (Redo).
Manage the state of the action lists (Lock and Unlock).