Setting Up Display

NOTE. To use formatting applied on the sheet to the table, select the Use Sheet Formatting checkbox in the Parameters group of parameters for the Table area type.

To open the Set Up Display panel, execute the following operations:

On the parameters panel:

Select a cell or a cell range.
Click the Parameters on the toolbar and select the Data/Cells area type in the drop-down menu of the parameters panel's title.
Select the Formatting / Format Cells group of parameters.
Click the Set Up button in the Set Up Cell Editor field in the Special Format group of settings. The Special Format group of settings for cells is located on the Settings tab.

On the working area:

Select a table cell or a table cell range in the working area.
Select the Formatting context menu item for the cells or in the drop-down list of the Formatting item select data area type/dimension/level/element.
Click the Set Up button in the Set Up Cell Editor field in the Special Format group of settings. Go to the Special Format group of settings on the Settings tab.

The editor shows a set of available values as an hierarchical list:

Set editor parameters:

Default Value. Set default value. This value must be included into a set of values specified in the list of available values.
Available Values. This box is used to create a tree of available values.

To add a node, select the Add Node item in the drop-down menu of the Add button. Enter node name in the dialog box that opens. The node is added to the first level if this is the first added element or at the same level with the selected element.
To add a child element to the selected element, select the Add Subelement item in the drop-down menu of the Add button. Enter element name in the dialog box that opens.
To rename the element, select the Rename item in the drop-down menu of the Settings button.
To delete the selected element, click the Delete button or select the Delete item in the drop-down menu of the Settings button.

A radio button or a checkbox sets a logical value:

If the radio button is selected, the value is True; if the radio button is deselected, the value is False.

Set editor parameters:

Caption Text. Determine checkbox label caption.
Default Value. Determine the default checkbox state: selected or deselected.

The string editor enables the user to display and set text value in a one-line input box:

Set editor parameters:

Default Value. Determine the editor value to be displayed by default. A string may contain up to 2 Gb of data. String text is not enclosed in quotation marks.
Maximum Length. Activate the box using the radio button and set the maximum number of characters that can be entered in the editor box.
Read Only. If the checkbox is selected, the value cannot be edited.

The masked string editor enables the user to limit the range of characters that can be entered and to determine format (or template) of the entered value:

This type of editor can be used to enter phone numbers, postal and other codes, identifiers, and so on.

An input mask enables the user to insert digits, letters, or other characters automatically, such as when you want parentheses around the zip code or a hyphen inside the telephone number.

Set editor parameters:

Default Value. Set default value. A string may contain up to 2 Gb of data corresponding to mask. String text is not enclosed in quotation marks.
Maximum Length. Activate the box using the radio button and set the number of characters that can be entered in the editor box.
Mask. Activate the box using the radio button and set a mask for the edit box. A mask should include characters that determine entering a character into selected position, and it may also include automatically displayed text. To include text constants, characters and spaces into a mask, enter them into the required position:

Mask symbol	Description
a/A	Letters and digits are allowed to be inserted into this position.
d/D	Only digits are allowed to be inserted into this position.
c/C	Only letters are allowed to be inserted into this position.

For example, the Series AACCDD mask allows (but does not require from the user) for six characters to be entered. The first two symbols may be any letter or digit; the second two symbols are letters only, and the third two symbols are digits only. The Series text is also automatically displayed.

Input Template. Activate the box using the radio button and set the template that will be used to enter data to the editor. A template should include underscore characters (_) on positions, to which various characters are entered, and text constants if there are any in the mask.
Allowed Characters. Activate the box using the radio button and set the number of characters that can be entered in the edit box. For example, if "AK23" is set:

Only digits 2 or 3 are allowed to be inserted into the positions allowing to enter digits.
Only letters A or K are allowed to be inserted into the positions allowing to enter letters.
Only digits 2 or 3 and letters A or K are allowed to be inserted into the positions allowing to enter digits and letters.

The dictionary box editor enables the user to show and set values using a drop-down list with dictionary elements:

Set editor parameters:

Dictionary. Use the drop-down list to select a dictionary, which elements are displayed in the editor.
Dictionary Attribute Controlling Value. Use the drop-down list to select a dictionary attribute that is used to transfer a value to parameter. For example, the dictionary displays element names, and parameter takes integer values. In this case the parameter will need to take values of the Key attribute. The Key attribute is used by default.

The selected attribute should have a unique index. It is necessary to restore selection.

Sorting. In the drop-down list select the option for sorting dictionary elements by name:

<No>. Dictionary elements are not sorted.
Ascending. Dictionary elements are sorted in ascending and alphabetical order or by text values of numbers.
Descending. Dictionary elements are sorted in descending and alphabetical order or by text values of numbers.

Selection Type. Select the type of dictionary elements' selection in the drop-down list:

SingleSelect. Single selection: only one element at a time can be selected.
SingleSelectNullable. Single selection with the ability to select empty value.
MultiSelect. Multiple selection.
To invert element selection, click it.
Clicking with holding down the SHIFT key deselects all elements and selects elements (except for collapsed ones) located between the focused element and the clicked element.
Clicking with holding down the CTRL key selects or deselects the element and all dependent elements. When the context menu is opened in the element area, the element is focused but not selected.
MultiSelectStandart. Multiple selection. Clicking the element selects only the selected element.
To select several elements on click, hold down the SHIFT or CTRL key.
Clicking with holding down the SHIFT key deselects all elements and selects elements (except for collapsed ones) located between the focused element and the clicked element.
Clicking with holding down the CTRL key selects or deselects the element.
None. The selection type is not specified, the MultiSelect selection type is used by default.

Level Names. Set names for levels in the drop-down list. Select radio button to show dictionary attributes or custom name:

To display dictionary attributes that will be used on creating level names, specify:

Level. In the drop-down list select a level for which name is set up.
Name. In the drop-down list select the attribute that determines name.

The name specified for the [all] element of the Level field is applied to all levels except for those, which got a special name.

NOTE. The Name attribute is used by default for all levels.

To show custom level names, determine:

Custom Name. In the box determine the name that will be displayed for all levels in the drop-down list.
Insert Attribute. In the drop-down menu of the Settings button select the attribute that will be added to the name.

NOTE. When custom element names are displayed, search by list elements is unavailable.

The time editor enables the user to display and set time values:

Set editor parameters:

Default Value. Activate the box using the radio button and determine the time to be displayed in the editor by default. This value must be in the range of available values determined for the editor. If the range of available values for editor is not set, the value must be in the range from 0:00 to 23:59.
Minimum Value. Activate the box using the radio button and determine the minimum allowed time value.
Maximum Value. Activate the box using the radio button and determine the maximum allowed time value.

The date editor enables the user to display and set date values:

Set editor parameters:

Default Value. Activate the box using the radio button and determine the date to be displayed in the default editor. This value must be in the range of available values determined for the editor. If the range of available values for editor is not set, the value must be in the range from 01.01.1600 to 31.12.3000.
Minimum Value. Activate the box using the radio button and determine the minimum allowed date.
Maximum Value. Activate the box using the radio button and determine the maximum allowed date.
Show Drop-Down Calendar. Select the checkbox to display the calendar opening button for visual selection a date in the editor.

The date and time editor combines parameters of date editor and time editor:

Set editor parameters:

Default Value. Activate the box using the radio button and determine the time and date to be displayed in the editor by default. This value must be in the range of available values determined for the editor. If the range of available values for the editor is not set, the value must be in the range from 01.01.1600 00:00 to 31.12.3000 23:59.
Minimum Value. Activate the box using the radio button and determine the minimum allowed time and date value.
Maximum Value. Activate the box using the radio button and determine the maximum allowed time and date value.
Show Drop-Down Calendar. Select the checkbox to display the calendar opening button for visual selection a date in the editor.

The decimal editor enables the user to determine decimal type values using an input box with scrollbars:

Set editor parameters:

Tolerance. Determine the number of decimal places. This value must be in the range of available values [0; 28]. The number contains 14 decimal places by default.
Default Value. Determine the editor value to be displayed by default. This value must be in the range of available values [-179228162514264337593543950335; 179228162514264337593543950335].
Minimum Value. Determine minimum available value.
Maximum Value. Determine maximum available value.
Step. Determine a step on increasing or decreasing a number using the scroll buttons in the value editor.

Value Can Be Empty. Select the checkbox to display an empty value in the value editor. If the checkbox is deselected, the default value is displayed.

The editor enables the user to display and set identifier values:

Set editor parameters:

Value Can Be Empty. The checkbox is deselected by default. If the checkbox is selected, identifier value can be empty.

On creating identifiers, follow the rules:

Identifier should consist of only Latin letters, numbers and underline character.
The first symbol should be letter or underline symbol.
Lower-case and upper-case letters are considered as equal.
Maximum length of identifier is 255 symbols.

Like a radio button, the boolean values editor has only two positions: True and False, but the position is selected in a drop-down list:

Set editor parameters:

Default Value. Select the default value in the True or False drop-down list. If the value is not specified, a default value False is displayed in the box.

The integer editor enables the user to determine integer values using input box with scrollbars:

Set editor parameters:

Default Value. Activate the box using the radio button and determine the date to be displayed in the default editor. This value must be in the range of available values determined for the editor. If the range of available values for the editor is not set, the value must be in the range [-2147483648; 2147483647].
Minimum Value. Activate the box using the radio button and determine the minimum allowed value.
Maximum Value. Activate the box using the radio button and determine the maximum allowed value.
Value Can Be Empty. Select the checkbox to be able to keep the box empty.

The list enables the user to set a value from the predefined list of values:

Set editor parameters:

Default Value. Set default value. This value must be included into a set of values specified in the list of available values.
Allow Input. If the checkbox is selected, the value that is not available in the drop-down list can be entered into the editor box.
Available Values. This field is used to create a list of predefined values.

To add a value, click the Add button. Enter a value in the dialog box that opens.
To rename the element, select the Rename item in the drop-down menu of the Settings button.
To delete the selected element, click the Delete button or select the Delete item in the drop-down menu of the Settings button.