Numbering of rows and columns can be set up for table area.
To enable numbering for rows and columns:
Select the checkboxes on creating table area:
Numbering of Rows on the Sidehead Structure page to display and set up numbers of rows.
Numbering of Columns on the Indicators Structure page to display and set up numbers of columns.
On editing data entry form:
Click the
Numbering button on the Table ribbon tab.
Select the checkboxes:
The By Rows in the
Numbering button drop-down menu to display rows numbers.
The By Columns in the
Numbering button drop-down menu to display columns numbers.
NOTE. Enable/disable numbering display is available on viewing ready data entry form.
Default settings:
For rows:
Row numbers will be displayed in a new sidehead column before headers.
Numbering starts from rows containing data.
Continuous numbering is applied.
For columns.
Columns numbers will be displayed in a new heading row after headers.
Numbering starts from the first sidehead column: if the table corner does not contain any header from sidehead, the numbering is displayed from rows containing data; on enabling sidehead header in table corner, numbering is displayed from the first sidehead column.
Continuous numbering is applied.
On enabling headers in corner it is possible to set header:
For column with rows numbers.
For row with columns numbers.
NOTE. It is available to set up header in corner only using the context menu.
It is available to divide corner into rows/columns only on displaying names of dimensions/attributes.
The cell can contain user-defined text, for example: No.
On disabling headers display in corner, the header of rows numbering column and columns numbering row will not be displayed too. On re-enabling headers in corner, the text for column/row with numbering will be displayed again.
For advanced numbering setup:
On creating table area, click the
button. The button becomes available after selecting the Numbering of Rows/Numbering of Columns checkboxes.
On editing data entry form, select the Set Up item of the
Numbering button drop-down menu on the Table ribbon tab.
The Numbering dialog box opens:
The dialog box contains the Rows and Columns tabs, the tabs availability depends on enabled numbering: if the numbering by rows is enabled, the Rows tab is displayed, if the numbering by columns is enabled, the Columns dialog box is displayed, if numbering by rows and columns is enabled, then both tabs are displayed.
Available settings:
Layout Area. To determine layout position for column with numbering toward the headers, select one of the following checkbox editor options: Before Header or After Header:
Merge for All Dimensions. For continuous numbering of all dimensions, select the Merge For All Dimensions checkbox. It is available, if the sidehead or heading contains two or more dimensions. The checkbox is disables by default. When the checkbox is deselected, elements numbers are set for each element of the first dimension displayed in the sidehead:
Consider Dimension Elements Paddings. To display numbering paddings according to dimension elements layout paddings in table area, select the Consider Dimension Elements Paddings checkbox:
Start Numbering from Corner. For numbering considering rows/columns of corner, select the Start Numbering from Corner checkbox:
Numbering from corner is displayed only on enabling name in corner. When the Start Numbering from Corner checkbox is selected for columns and when name from sidehead is enabled, numbering starts and is displayed from the first sidehead column. When the Start Numbering from Corner checkbox is selected for rows and when name from heading is enabled, numbering starts and is displayed from the first heading column.
Numbering Settings for Dimensions and Levels. In the area for numbering setup for dimensions and dimensions levels, set:
Numbering Type. Set up numbering type for dimension/level. Available types:
Inherit from Parent. It enables to modify numbering type, format, delimiter in chain order. It is available only for dimension levels. It is selected by default for dimension levels.
Continuous. It enables to set continuous numbering for level elements independently of parent level numbering. It is selected by default for dimension.
Hierarchical. On selecting this type, level numbering follows the parent level.
Hierarchical with Prefix. On selecting this type, level numbering follows the parent level numbering, parent element number will be included into prefix.
Format. Set up numbering format. It is available for the following numbering types: continuous, hierarchical and hierarchical with prefix. Available options:
1, 2, 3. Default.
I, II, III.
i, ii, iii.
A, B, C.
a, b, c.
А, Б, В.
а, б, в.
NOTE. If letters of the alphabet are finished, the numbering starts from the beginning with the repeated symbol.
Delimiter. To add a symbol after number or for numbering with prefix, specify any symbol in the field. If the symbol is not specified, the delimiter after number and between number and prefix, if hierarchical numbering type with prefix is specified, will be absent. It is available for the following numbering types: continuous, hierarchical and hierarchical with prefix. It is not specified by default.
Initial Value. To determine the initial numbering value, enter a value in the field. It is available for the first dimension. By default the 1 value is set. Depending on the specified numbering format, the initial value is converted to the format.
The example of numbering settings use
Show or hide numbering on working with ready form.
To set up numbering formatting, use the Format ribbon tab.
See also:
Building Data Entry Form | Working with Ready Data Entry Form