Setting Up Form Formatting and Display Type

To change zoom:

Click the Zoom button, select the value.
Focus on the table and scroll the mouse wheel while holding down the CTRL key. Scroll up the mouse wheel to zoom in and scroll down to zoom out.

To display full-sized form, click the 100% button.

To keep form areas visible on scrolling the rest, freeze the required areas:

To freeze the first row, select the Freeze First Row item in the drop-down menu of the Freeze Areas button.
To freeze the leftmost column, select the Freeze First Column item in the drop-down menu of the Freeze Areas button.
To freeze the area including several rows and columns:

Select the cell, which top left corner will determine fixed rows and columns.
Select the Freeze Areas item in the Freeze Areas drop-down menu of the button.

To unfreeze areas, select the Freeze Areas > Unfreeze Areas item in the Layout group.

To show or hide scrollbars, formula bar, headers and grid, select or deselect the checkbox.

For autofit size by string or column contents, click the Fit Row Height/ Fit Column Width buttons.

On working with business processes to execute process steps, use the panel and the Processes tab. To show or hide panel and tab, press or release the Process Tree button of the Panels group.

Setting Up Form Formatting

To set up format of the specific form area, select the element in the Current Section group in the drop-down list. Available area types: corner, sidehead, heading, data, selected area, entire table, dimension, level, element, selected columns.

Depending on the selected cell or cell range, the box of the drop-down list in the Current Section group is filled.

Formatting Features of the Selected Columns Area

Formatting priority of the Selected Columns area is higher than for all other areas.

If heading has several cells, the formatting priority is higher for the lower row.

The setup is executed in the Text group and is the same as for the font format setup in the Reports tool.

To set up fill, click the Fill on the Format ribbon tab. Select fill color in the button's drop-down menu.

To set up borders, click the Border button on the Format ribbon tab. Select border type and its color in the button's drop-down menu.

The setup is executed in the Number group. In the drop-down list select one of the supported data formats: general, number, currency, date, time, percentage, exponential, text.

To set up data format, use the buttons:

- converting into currency format. To select currency, use the drop-down menu of the button.
- converting into percentage format.
- converting into number format and displaying two decimal places after point.
- decreasing or increasing by 1 the number of decimal places.

To set up cell formatting, use the Formatting standard dialog box. To open the dialog box, click the Set Formatting button of the Formatting tab. Dialog box tabs include advanced settings presented on the Format ribbon tab.

NOTE. The cell formatting dialog box contains the following tabs in data entry forms: Number Format, Font, Fill, Alignment, Borders, Other.

To limit value types on data entry and adding entry mask to form cells, use value editor.

To cancel application of the specified formatting, click the Reset Style button of the Formatting group.

Setting Up Data Entry Form Formatting and Display Type

Setting Up Form Display Type

Setting Up Form Formatting

Formatting Features of the Selected Columns Area