Reverting Actions

If you would like to revert an action that you performed in a Workbook, you can use the Undo and Redo buttons available in the toolbar. By default, you can undo or redo the last two actions performed on a Workbook that modify the Workbook state in the database. These actions don't include changes such as font style or column size, as the Workbook's state remains the same. You can also access these options through the Edit menu or using keyboard shortcuts (Cmd+Shift+Z for undo, Cmd+Shift+Z for redo). If the cursor is in a text field, using the keyboard shortcut reverts only the most recent changes in the text field, not the whole Workbook.

Administrators can adjust the settings for these buttons in default.properties and system.properties. There, admins can edit the amount of time the history of a Workbook is kept, the maximum number of actions a a user can revert, and how many Workbooks can retain a history at the same time.

To make sure this functionality isn't causing performance issues, you can check various statistics about the memory usage and Workbook states in <Datameer>/logs/workbook_undo.log. The log is set to record the following values separated by comma:

absoluteMemoryConsumption,absoluteMemoryUsageInBytes,generalMemoryUsage,historiesInUse,historyStatesInMemory,maxMemory,relativeUsageInPercent,usedMemory,usersWorking,workbooksInUse

All undo related actions are collected, but for memory performance, the system prints the values to the log once per minute.