The following topics introduce the new and changed features of ADF Desktop Integration and other significant changes that are described in this guide, and provides pointers to additional information.
For changes made to Oracle JDeveloper and Oracle Application Development Framework (Oracle ADF) for this release, see the What's New page on the Oracle Technology Network at http://www.oracle.com/technetwork/developer-tools/jdev/documentation/index.html.
Oracle ADF Desktop Integration in Release 11.1.1.9.0 includes the following new and changed development features for this document.
Note:
The version of ADF Desktop Integration delivered in Release 11.1.1.9.0 of Oracle JDeveloper and Oracle Application Development Framework is 11.1.1.7.5.New feature, a Status Viewer, that displays error messages to end users in Excel´s task pane. For more information, see Section 13.2, "Using the Status Viewer to Report Error Messages to End Users."
Provides the option to create worksheet commands that download and upload data at runtime when you insert an ADF Table component at design time. For more information, see Section 7.3, "Inserting an ADF Table Component into an Excel Worksheet."
New property, DisplayUploadOptions, to control whether the Upload Options dialog displays. For more information, see Section 7.8, "Uploading Changes from an ADF Table Component."
New feature that makes an ADF Table component report errors in the specific rows that contain errors rather than report all rows in a batch as containing errors. For more information, see Section 7.11, "Batch Processing in an ADF Table Component."
New property, Options.AbortOnFailure that controls whether DeleteFlaggedRows continues processing if it encounters failures. For more information, see Section 7.10, "Deleting ADF Table Component Rows in the Fusion Web Application."
ADF Table component's DeleteFlaggedRow action can now be invoked in the same action set as the component's Upload action. For more information, see Section 7.10, "Deleting ADF Table Component Rows in the Fusion Web Application."
New property, GroupHeader, to enable the grouping of columns (including dynamic columns) in an ADF Table component by displaying an extra header row on top of the ADF Table component's header row. For more information, see Section 7.17, "Grouping Columns Together in an ADF Table Component."
New groups (Workbook and Worksheet) to appear in the runtime ribbon tab that you can add to an integrated Excel workbook. These new groups replace the previous groups of Connection, Worksheet, Clear, and About. For more information, see Section 9.3, "Configuring the Runtime Ribbon Tab."
New property, Image, that lets you choose one of a number of images to display as a worksheet ribbon command. For more information, see Section 9.3.2, "How to Configure a Worksheet Ribbon Command for the Runtime Ribbon Tab."
New styles that conform to the look and feel of Oracle Alta UI. Integrated Excel workbooks that you create with this release of ADF Desktop Integration use these styles by default. For more information, see Chapter 10, "Configuring the Appearance of Your Integrated Excel Workbook."
New feature, data entry validation, that validates certain types of user input in the integrated Excel workbook. For more information, see Section 13.3, "Providing Data Entry Validation for an Integrated Excel Workbook."
New property, AutoConvertNewRowsEnabled, that controls whether data entered after the last row of a table is converted into pending insert rows. For more information, see Section A.11.1, "ADF Table Component Properties."
For Release 11.1.1.9.0, this document has been updated in several ways, to include corrections and clarifications. In addition, the following significant changes or additions have occurred in these sections:
Added a new section, Section 7.15, "Adding a ModelDrivenColumnComponent Subcomponent to Your ADF Table Component", to describe the Search and Select user interface in integrated Excel workbooks.
Added a new chapter, Chapter 8, "Working with Lists of Values", with the content that describes how to create dropdown lists of values (including dependent lists of values) in integrated Excel workbooks.