1. User's Guide
  2. General Operations
  3. Using Undo and Redo

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, Undo button, and Redo, Redo button, behave differently depending on the data source to which you are connected.

Additionally:

  • In ad hoc analysis with Oracle Essbase, Oracle Hyperion Financial Management, 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.

  • In ad hoc grids for all providers, Excel formatting is not retained when performing an Undo.

  • When you change the alias table, the number of Undo operations reverts to one. Any previous actions are lost, regardless of the setting in the Number of Undo Actions option. See Specifying the Number of Undo and Redo Actions for instructions on setting this option.

See also Undo Support By Provider.

Note:

You can only undo operations that are performed in Oracle Smart View for Office. You cannot undo operations that are performed on the provider server, such as calculation status.