Saving Native Excel Formatting to EPM Cloud

Oracle Smart View for Office provides a way for users to save native Excel formatting back to Oracle Enterprise Performance Management Cloud business process as part of a form or ad hoc grid.

Data source types: Planning, Planning Modules, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Tax Reporting

Saved formatting is applied in both the business process browser interface and when the form is rendered within Excel. You can then choose how to display the formatting in Smart View. This functionality is in addition to the existing Smart View cell styles functionality.

See also Cell Styles.

These formatting options are available in the Formatting group of the provider ribbon, shown in Figure 22-17.

Figure 22-17 Formatting Options


The Formatting group options from the provider ribbon. Options are Save, Clear, and Apply