Using Undo and Redo

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

Smart View Undo, Undo button, and Redo, Redo button, behave differently depending on the data source to which you are connected. Briefly:

  • In ad hoc analysis with Oracle Essbase, Oracle Hyperion Financial Management, Oracle Enterprise Performance Reporting Cloud, or Oracle Hyperion Enterprise® 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 with Financial Management, Hyperion Enterprise, or Oracle Hyperion Planning data sources, Undo undoes the last user action in a cell.

  • In ad hoc grids for all providers:

    • Formulas are not retained when performing an Undo, regardless of whether or not the Preserve Formulas and Comments in ad hoc operations (except pivot and undo) option is selected.

    • Excel formatting is not retained when performing an Undo.

See also Undo Support By Provider.

Note:

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.