1 What's New in Release 3.0.0
Here’s an overview of new features and enhancements added to Oracle Visual Builder Add-in for Excel in Release 3.0.0. Take note also of some limitations when using the add-in.
New and Changed Features
- Oracle Visual Builder Add-in for Excel supports authentication for REST services using OAuth 2.0 Authorization Code flow with Proof Key for Code Exchange (PKCE). This authentication method allows clients like the add-in to authenticate and get an access token which can then be used to make REST requests to service endpoints. See OAuth 2.0 Authorization Code Flow.
- You can create expressions that access the field values of ancestor business objects using
Parentto represent the parent business object of the currently selected field's business object. You can use these expressions in List of Values (LOV) filter query parameters and polymorphic bind parameters. See About Expressions. - When creating new rows in a workbook, the add-in automatically populates any "ancestor" columns with the correct values when you provide valid values for the direct parent columns. See Manage Data in a Dependent Layout in Managing Data Using Oracle Visual Builder Add-in for Excel.
- A New Layout Setup wizard that steps you through the task of adding a catalog and creating a Table or Form-over-Table layout for your workbook. See Create Layouts in an Excel Workbook.
- Support for Microsoft Excel 2021.
Known Limitations
- Review REST Service Support Limitations to understand the limitations around data type support.
- Review Notes and Limitations for Lists of Values to understand limitations around using lists of values.
- Review Custom Action Limitations to understand the limitations of custom action support.
- Workbooks created or modified with version 3.0 are generally considered to be incompatible with prior versions of the add-in.