Using Undo and Redo

When connected to a data source provider, the Undo option in the Smart View ribbon, undoes the last user action in a cell.

Undo, , and Redo, , behave differently depending on the data source to which you are connected.

Guidelines on using Undo and Redo

Consider the following guidelines while using Undo and Redo options in Oracle Smart View for Office.

You can only undo operations that are performed in Smart View. You cannot undo operations that are performed on the provider server, such as calculation status.
In ad hoc analysis with Oracle Essbase or Narrative Reporting data sources, Undo undoes Zoom In, Zoom Out, Keep Only, Remove Only, or Refresh and restores the previous database view to the grid. Performing an Undo after modifying member data returns the sheet to its state before the last refresh, not to its state before the data modification.
In forms, Undo undoes the last user action in a cell.
Undo action is not supported in a form when:
- The form has Enable drop-down for dimensions check box selected in Segment Properties during form creation.
- The form contains data validation errors due to data validation rules.
In ad hoc grids for all providers, Excel formatting is not retained when performing an Undo.
When you change the alias table, you will not be able to undo any previously performed actions. For example, you set the Number of Undo Actions option to 9. If you perform three ad hoc operations, such as Zoom In, Pivot, and then Keep Only, and then change the alias table, those three previously performed actions can no longer be undone. However, any supported actions you perform after changing the alias table are tracked and can be undone according to the setting in Number of Undo Actions. See Specifying the Number of Undo and Redo Actions for instructions on setting this option.