Exporting to Smart View

Oracle Smart View for Office enables the following export options:

• Export the current page of the current data object to Word, Power Point, or Excel as an image. After insertion, you can query the corresponding web application again to refresh the image.

• Export documents to Microsoft Excel as either query-ready HTML or formatted HTML.

  When you export content as query-ready HTML, the current page of the current data object is converted to HTML and Oracle-specific formatting is removed. All data rows and columns are included, including hidden rows and columns, to ensure a valid ad-hoc query format in Oracle Smart View for Office (Windows). In addition, Financial Reporting formula and text rows and columns are not included. This enables Smart View to query the data source independent of the web application.

  When you export content as Formatted HTML, the current page of the current data object is converted to HTML with the Oracle formatting definitions and calculated members. This formatting content prevents Smart View from directly querying the data source, but enables Oracle content to be leveraged by Office applications.

Not all export options are supported by all data sources and web applications. The following table indicates export options for Smart View:

Table 3-6 Smart View Export Options

Web Applications	Export Image to Microsoft Word, and PowerPoint	Export Formatted HTML to Excel	Export Query-Ready HTML to Excel
Planning	Yes	Yes	Yes
Financial Reporting	Yes	Yes	Yes

Because Excel worksheets prevent users from entering data into read-only cells, some Excel functions, such as AutoSum and F9, and some formatting functions, are disabled in Smart View.