1. Developing Integrated Spreadsheets Using Oracle Visual Builder Add-in for Excel
  2. Create Layouts in an Excel Workbook
  3. Manage Layout Capabilities

Manage Layout Capabilities

Each layout in Oracle Visual Builder Add-in for Excel enables you to perform various standard and custom actions in an Excel workbook, so long as the operation is supported by your service. You can enable or disable these supported capabilities to control their availability in a layout.

  1. In the Excel ribbon, click Designer to open a workbook's Layout Designer.
  2. Click Advanced to see the layout's capabilities. Here's an example of a Form-over-Table layout, indicating form capabilities and table capabilities:
    Description of layout_capabilities.png follows
    Description of the illustration layout_capabilities.png

  3. Select or deselect options as required. If the business object doesn't support an action, it won't be available for selection (like Delete Enabled under Table Capabilities as shown in this image). See REST Operations for more information about the REST support required for these options.