Working with the Quick Toolbar in Forms 2.0

In Forms 2.0, instead of using a context (right-click) menu, certain common actions have been placed in the quick toolbar for easier accessibility.

Quick Toolbar

You can perform the following actions using the quick toolbar:

Table 14-5 Quick Toolbar

Icon Description
Adjust icon

Adjust: Increase or decrease the selected cell data by a positive or negative value, or a percentage value.

Grid Spread icon

Grid Spread: Specify an amount or percentage by which to increase or decrease values across multiple dimensions, based on the existing values in the target cells. You can select a Proportionally, Evenly, or Fill spread pattern. To use grid spread, your administrator must enable Grid Spread as a form property.

Comment icon

Comment: Explain data or provide background, and attach external files. You can add comments and attachments to a cell or to a range of cells across multiple dimensions. Multiple comments can be posted for the same cell. The comments popup can be used to upload attachments. Posted comments and attachments can also be deleted.

Note:

In Forms 2.0, you can attach files with file sizes of up to a maximum of 20 MB to formula cells.
Line Item Details icon

Line Item Details: Build logic into how a cell value is calculated. Line item details is an upgraded (alternative) functionality for supporting details:

  • Line item details can be invoked from the context (right-click) menu or from the Quick Toolbar

  • Add child or siblings with provisioning to make arithmetic calculations (add, subtract, multiply, and so on)

  • Support only for rows (not for columns)

Change History icon

Change History: Displays the history of the changes made to the cell data.

Undo icon

Undo: Cancel the last change you made.