Setting Up Data Entry Form Formatting and Display Type

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

To freeze the first row, select the View > Freeze > Freeze First Row main menu item.
To freeze the leftmost column, select the View > Freeze > Freeze First Column main menu item.
To freeze the area including several rows and columns:

Select the cell, which top left corner will determine frozen rows and columns.
Select the View > Freeze > Freeze Areas main menu item.

To unfreeze area, deselect the checkbox of the selected freeze option by selecting the View > Freeze > Freeze Areas main menu item.

Resize rows and columns

Setting Up Form Formatting

The side panel name depends on the selected area type. The cell formatting setup panel opens by default.

Quick Setup of Cell Format

Open the cell formatting panel

To set up font, determine the following:

Font. Select one of the available font styles in the drop-down list. If required, one can load custom fonts.
Font size. Set the required font size. The size is set in points, and it can be selected in the drop-down list or entered manually. The range of available values: [8; 36].
Color. Select font color in the drop-down palette or set it in the RGB or HEX formats by clicking the the Text Color button:

NOTE. Color of the Font Color button changes for the selected color.

Font style. Select font style in the drop-down list:

B. Bold. One can also use CTRL+B to set this option.
I. Italic. One can also use CTRL+I to set this option.
U. Underline. One can also use CTRL+U to set this option.

NOTE. As a rule, the CTRL+U hotkey combination is reserved in the browser for opening source code of the current page. To use this hotkey combination for underlining text, redefine its purpose in browser settings.

S. Strikethrough. One can also use ALT+SHIFT+5 to set this option.

When the button is pressed, the corresponding font style is used. One can also use several styles at the same time, for example, clicking the B and I buttons results in the bold italic style.

To set up fill, click the Fill Color button and select fill option in the drop-down list:

The following fill options are available:

No Fill. Default value. Plot area is not filled.
Solid Fill. In the drop-down palette select solid fill color for plot area or set color in the RGB or HEX formats. If required, specify fill transparency degree.
Two-Color Fill. In the drop-down palette select start and end color of two-color gradient or set them in the RGB or HEX formats. If required, specify tilt angle and fill transparency degree.

NOTE. When the Solid Fill option is selected, color of the Fill Color button changes to the selected color. When the Two-Color Fill option is selected, color of the button changes to the color selected as the start color.

There are the following cell border options:

. Show all borders.
. Show internal borders only.
. Show internal horizontal border.
. Show internal vertical border.
. Show external borders only.
. Show left border.
. Show top border.
. Show right border.
. Show bottom border.

To undo showing selected range borders:

. Do not show borders.

To merge cells, select a cell range and click the Merge Cells button.

To unmerge merged cells, select the merged cell and click the Unmerge Cells button.

The merged cell contains data from the first cell in the selected range. After the merge, data of other cells does not disappear, it is only hidden. Thus, after unmerging, data of all cells in the range is restored.

NOTE. Cells can be merged or unmerged in the context menu of the selected cell range.

To determine a method for inside cell alignment, use the Alignment group of settings. Cell value can be aligned horizontally and vertically with selected rotation angle and paddings from the cell borders. Wrap method can also be selected for string values.

Set the options of value position within a cell:

Alignment. Set value alignment method:

Horizontal. Available options:

By Value. Alignment depends on the cell(s) contents. If a cell contains only numbers (including digit group separators, decimal separators, and the percent sign), it is right-aligned; otherwise, it is left-aligned.
Left. Value is aligned to the cell's left border.
Center. Value is aligned at the same distance from the left and right cell border taking into account defined paddings.
Right. Value is aligned to the cell's right border.
By Width. Value is aligned to fit the cell width.

Vertical. Available options:

Top. Value is aligned to the cell's top border.
Center. Value is aligned at the same distance from the top and bottom cell border taking into account defined paddings.
Bottom. Value is aligned to the cell's bottom border.

Wrap Text. Set text wrapping in cells:

Do not Hyphenate. The text is not wrapped. The entire text is displayed as a single line.
By Words. Cell text is wrapped. Cell width determines where line breaks occur.

Text Rotation. Set text tilt angle in a cell. The default value is 0.

To change data format settings, select one of the supported data formats in the drop-down list. Different settings are available depending on the selected format:

General. Equal to canceling formatting.
Number. Default format. To display less/more precise values, click the Decrease Number of Decimal Places / Increase Number of Decimal Places button as many times as required. The minimum number of decimal places: 0. Default value: 2.
Percentage. If the Percentage format is selected, to display less/more precise values, click the Decrease Number of Decimal Places / Increase Number of Decimal Places button as many times as required. The minimum number of decimal places: 0. Default value: 2.

If the Percentage format is used, the number values are multiplied by 100 and the "%" character is added. Values entered into a cell are processed in different ways depending on the way the "%" character is used. For example, when 40% is entered, the cell displays 40%, but the cell value is 0.4. When 40 is entered, the cell displays 4000%, but the cell value is 40.

Currency. If the Currency format is selected, the following settings are available:

Specify currency display format in the drop-down list.
To display less/more precise values, click the Decrease Number of Decimal Places / Increase Number of Decimal Places button as many times as required. The minimum number of decimal places: 0. Default value: 2.

Date. If the Date format is selected, data is displayed in the DD.MM.YYYY format.
Time. If the Time format is selected, data is displayed in the HH:MM format.
Exponential. This format is used to show a number in exponential format. If the Exponential format is selected, to display less/more precise values, click the Decrease Number of Decimal Places / Increase Number of Decimal Places button as many time as required. The minimum number of decimal places: 0. Default value: 2.
Text. Equal to canceling formatting. Text format is selected by default for the cells containing non-numeric values.
Additional. Automatic conversion to the predefined format. Default value: Zip Code.
Custom. It contains code views of all available data formats.

NOTE. For advanced data format setup use the Format Cells group of parameters on the parameters panel.

To set mixed cell text formatting, change font options of the selected text part. It is available for text data format.

NOTE. Formatting of the first text character is saved for the cell if text is replaced or deleted from the cell.

To reset all specified settings, select the Clear Format item in the drop-down menu of the

Clear button on the toolbar.

Setting Up Data Entry Form Formatting and Display Type

Setting Up Form Display Type

Setting Up Form Formatting

Quick Setup of Cell Format