Consider the guidelines in this topic while using Excel formulas in forms.

• You can create Excel formulas in form cells inside or outside the grid if the cells are not read-only or locked.

• Cells that contain cell text can contain Excel formulas, but cells containing supporting detail (such as Oracle Fusion Cloud Enterprise Performance Management cells) cannot.

• Formulas are preserved in forms when you refresh the form even without saving the data.

• If you move a referential formula, its cell references are updated to reflect the new location.

• A cell with formula displays the dirty cell style if the value in the cell reference, present either in the same sheet or another sheet, is updated. On submitting, the updated value in the formula cell also gets submitted.

• In forms, you are prompted to save the workbook as an Excel file if you do any of the following (but you temporarily lose access to the form):

  • Change the current page

  • Select a different form

  • Connect to a different data source