Special Table Columns

Each table in an integrated workbook includes three special columns managed by Oracle Visual Builder Add-in for Excel: Change, Status, and Key.

If the table is read-only (Download only), the Change and Status columns do not appear.

Caution:

These columns are required. Do not edit the cells in these columns or delete the columns from the worksheet.

The Change Column

The Change column displays the pending action for a row based on the changes that you make. If you edit an existing row that has been downloaded, the Change cell displays "Update". If you inserted a new row, it displays "Create". And so on.

This column helps you keep track of what operation will occur for each row when you perform Upload. If the Change cell is empty for a given row, that row is not included in the next upload.

When a new or changed row is successfully uploaded, the Change column cell is cleared. If the upload failed, the operation is still pending and the Change column cell is not cleared.

The Status Column

The Status column shows the result of the upload for a row. You may see values like "Create Succeeded" or "Update Failed", and so on. In the case of an update failure, select the row to see more details in the Status Viewer.

The Status column cells are cleared on download.

Tip:

Use Excel's commands to filter the table by values in this column to focus on the rows that need the most attention.

The Key Column

The Key column is the last column in the table and is used to store internal information that allows the add-in to work as expected. This information is not intended to be viewed by users and is deliberately unreadable.

Note:

If you sort the table using Excel's Sort command, make sure to include the Key column in the sorted range. Otherwise, you may inadvertently corrupt your data.