Retaining Formula, Label, and Comment Rows and Columns on Flex Forms

In Oracle Smart View for Office 23.200+, you can retain formula rows and columns on flex forms by enabling the "Show invalid members for flex form" option during form definition. When a Service Administrator enables this option, formula rows and columns are retained on the flex form after a refresh or a submit.

Note:

Formula rows and columns are also referred to as label or comment rows and columns.

After a refresh or submit operation, all members and data on a formula row or column are highlighted using the same cell style as used for invalid members, described in Retaining Invalid Members on Flex Forms.

In earlier Smart View releases, formula rows and columns were not supported in flex forms. Upon submit, a message noted that a refresh must first be performed; and upon refresh, the formula rows and columns were removed from the flex form.

Note:

Attempting to delete an entire row or column by using the Delete key to delete only the member cells of a row or column will result in invalid members in the member cells upon refresh. To delete entire rows or columns on a flex form, select the entire row or column, right-click, and then select Delete from the Excel context menu.

Enabling the Show invalid members for flex form option gives users the versatility of flex forms when working with forms containing formula rows and columns.