Setting Up Parameters

To set up table area general parameters, use the Parameters group of parameters on the parameters panel:

To open the Parameters group of parameters on the parameters panel:

Select a cell or a cell range in the table area.
Click the Parameters button on the toolbar.
Select the Table area type in the drop-down menu of the parameters panel title.

The box displays the identifier of the table area as an object on the data entry form sheet.

To change table area identifier, enter a sequence of Latin letters and numbers in the box. The identifier should be unique within the data entry form.

To move the table area on another data entry form sheet, select the required sheet in the Sheet drop-down list.

NOTE. When the table area is moved from one sheet to another, formatting and all applied table settings are saved.

By default, the sheet name is displayed, which contains the table area.

To move the tale area within the data entry form sheet, change the left top corner coordinate of the table area.

NOTE. Table area borders cannot be set greater or less than their actual size.

By default, the actual table area cell range is displayed.

To clear the sheet formatting in the table, select the Clear Styles checkbox. Table formatting will be cleared only on form refresh.

To use the sheet formatting in the table, select the Clear Styles checkbox.

Sheet formatting includes settings of formatting, conditional formatting, table styles and predefined styles, determined for the Cell area type on the parameters panel regardless of the cell position.

Deselect the Clear Styles checkbox only if the table area will not be dynamically rebuilt with resizing.

The checkbox is selected by default.

To use only calculated formula value in a table area cell, select the Clear Formulas checkbox.

To use the formula in a table area cell, deselect the Clear Formulas checkbox.

Change of behavior will be applied on updating or saving data entry form.

If the checkbox was deselected on opening data entry form, and was selected during data entry form work, the formulas already entered in the table area will be calculated, and calculated values will be entered to cells.

Selecting the checkbox enables the user to save changed table area data to data source. If the checkbox is deselected, saved data cannot be saved to the data source. The checkbox is selected by default.