1. Developing Integrated Spreadsheets Using Oracle Visual Builder Add-in for Excel
  2. Use Lists of Values in an Excel Workbook
  3. Notes and Limitations for Lists of Values

Notes and Limitations for Lists of Values

Review the notes and limitations listed here when planning to use lists of values (LOV):

  • Only one identity field is supported in a list of values.
  • LOVs support strings, Boolean values, and integers. Decimal numbers, dates, and date-time values are not supported.
  • Excel drop-down lists using data validation may not be compatible with the add-in.
  • For Oracle ADF REST Resource services, if the catalog includes metadata for an LOV, the add-in reads the metadata and configures the LOV automatically. Supported ControlTypeHints: "combo_lov", "choice", and "input_text_lov".
  • For any read-only field (column or form), the add-in still swaps identity values for display values. However, the search-and-select window does not appear when the cell is selected.
  • When using an expression that refers to a field in an ancestor layout, ensure:
    • The referenced field is present in the ancestor layout.
    • The ancestor column in the current layout is configured properly so that the add-in can map a row to its ancestor row.
  • A field's LOV can be dependent on an ancestor field as long as that ancestor field does not have an LOV that is dependent on another field.
  • Dependent LOVs are not supported on ancestor columns.
  • When creating a cascading set of LOVs, you can use a "local" LOV (one based on a local data source) as the initial list, but not as one of the subsequent lists. A "remote" LOV (one based on a business object as the data source), however, can depend on a value in a local LOV.

    In a cascading list of values, the value selected in one list determines the range of values that users can select from subsequent lists.