Zooming and Formatting

You can apply the formatting of the cell that you zoom in on to the cells that are created by zooming. For Oracle Smart View for Office formatting, this ability applies to data cells. For Excel formatting, this ability applies to member cells.

Excel Formatting

To apply Excel formatting selections to member cells created by zooming, from the Smart View ribbon, select Options. Then select all these options:

  • From the Formatting page, select these options:

    • Use Excel Formatting

    • Move Formatting on Operations

  • From the Member Options page, select Preserve Formulas and Comments in ad hoc operations (except Pivot)