Setting Up Data Entry Form Formatting and Display Type

To set up data entry appearance:

  1. Set up display type.

  2. Set up formatting.

NOTE. Data entry form formatting is related to table area custom settings. On viewing ready data entry form, it is available to save selected data entry form formatting.

After the setup is finished, go to the next step if required:

Setting Up Form Display Type

To display form display type, follow the steps:

  1. Set up zoom.

  2. Set up layout.

  3. Set up size of rows and columns.

  4. Set up displaying of working area elements.

To set up, use the View ribbon tab:

Change zoom

Freeze areas

Show or hide graphical interface elements

Fit rows or columns sizes

Show or hide panels

Setting Up Form Formatting

To set up form formatting, follow the steps:

  1. Set up text format.

  2. Set up fill and borders.

  3. Set up number format.

  4. Set up cell formatting.

NOTE. Formatting setup is available only in the desktop application.

To set up, use the Format ribbon tab:

To set up format of a specific form area:

Available area types: corner, sidehead, heading, data, selected area, all table, dimension, level, element, indicator, selected columns, numbering by columns, numbering by rows.

Formatting application order is the following:

  1. Entire table. The lowest priority.

  2. Data.

  3. Dimension.

  4. Level.

  5. Element.

  6. Indicator.

  7. Selected columns. The highest priority.

For areas: dimension, level, element - it is available to set up different formatting for headers and data. To do this, use the Headers / Data buttons in the Current Fragment group. Only one button can be hold, on clicking one button, the other is automatically released. The Data button is pressed by default.

NOTE. The formatting setup is unavailable for private dimensions.

On data formatting, heading areas have higher priority than sidehead areas.

If sidehead or heading display several dimensions, formatting settings for data apply only if they are set for:

NOTE. On tucking the area type and formatting of tucked dimension element will change to area type and formatting of dimension element to which tucking is executed.

The formatting application order for headers is the following:

  1. Sidehead/heading. The lowest priority.

  2. Dimension header.

  3. Level header.

  4. Element header. The highest priority.

Formatting settings of headers are saved in the same way as all other formatting settings.

Formatting settings of table area are applied after form update.

Set up text format

Set up fill and borders

Set up number format

Set up cell formatting

To cancel the use of selected formatting for an area, click the Reset Style button of the Formatting group, the button becomes active after formatting setup.

Formatting Features of the Indicator Name Area

The <Indicator Name> area is available for heading cells of table area.

The formatting is applied for elements of selected indicator. On adding elements to selection, the formatting will be applied to added elements.

The formatting is available on displaying indicator name. If name is hidden, the formatting setup will be unavailable. If the style is defined previously, it will be applied but note that this style cannot be reset.

Formatting Features of the Selected Columns Area

The Selected Columns area is available for table area heading cells.

Formatting is applied for columns, to which selected cells belong.

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.

Formatting Features of the Selected Area Area

The Selected Area area is available for the cells:

Selected cells are formatted.

On formatting table area, use the Selected Area type only if on building a table area the Use Sheet Formatting checkbox is selected.

See also:

Building Data Entry Form | Working with Ready Data Entry Form