Setting Up Changed Data

To set up font, set the parameters:

• Font. Select one of the available fonts in the drop-down list. If required, one can load custom fonts.

• Font size. Select 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: [6; 36].

• Color. Select text color in the drop-down palette or set it in the RGB or HEX format.

• Font style. Select font style:

• B. Bold. One can also use CTRL+B to set this font style.

• I. Italic. One can also use CTRL+I to set this font style.

• U. Underline. One can also use CTRL+U to set this font style.

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 for this purpose.

When the button is pressed, the corresponding font style is used. Several styles can be used simultaneously, for example, pressed B and I buttons result in bold italic font style.

• Cell text alignment. Set text alignment relative to cell:

• Left. It is used by default. One can also use CTRL+SHIFT+L to set this option.

• Center. One can also use CTRL+SHIFT+E to set this option.

• Right. One can also use CTRL+SHIFT+R to set this option.

NOTE. As a rule, the CTRL+SHIFT+R hotkey combination is reserved in the browser for refreshing the current page. To use this hotkey combination for aligning text to the right, redefine its purpose in browser settings.

• By Width.

Only one option can be selected.

To set up fill, set the parameters:

• Fill Color. Select the following in the drop-down menu of the Fill Color button:

• Fill Type. The option is available for regular reports, data entry forms, information panels, and calculation blocks:

• No Fill. Default value.

• Solid Fill.

• Two-Color Fill. It is available for regular reports, data entry forms, and calculation blocks.

• Fill Color:

• To use solid fill, select a color in the color palette or set it in the RGB or HEX format.

• To use two-color fill, select a start and end color in the color palette or set it in the RGB or HEX format.

• Fill Tilt Angle. Enter two-color fill tilt angle.

• Hatching Type. If required, add hatching. The parameter is set to No Hatching by default. The drop-down list contains all available hatching types.

• Hatching Color. The parameter is displayed after a hatching type is selected. Select a color in the drop-down palette or set it in the RGB or HEX format.

• Image. To set up a fill with an image, use the Image parameter. The radio button is disabled by default, a cell fill is set up in a standard way. To use an image as a fill, select the radio button. To add an image to cell, click the Select File button.

The image selection dialog box opens. Working with the dialog box depends on the browser in use. After an image is selected, the file name is displayed in the corresponding box, the report sheet cell is filled with the use of the image.

To remove the image, click the Delete button next to texture name.

To replace the image, click the Select File button again.

After the image is selected, the following elements are displayed:

• Download. Click the Download button to export the image used as a fill.

• Stretch Image. The checkbox is deselected by default, the cell image corresponds to its original size. Select the checkbox to fit the image to the cell.

To reset fill settings, click the Delete button next to the Fill tab name.

The following parameters to set up cell borders are available:

• Show Borders. The parameter is used to set and remove cell borders. The following modes are available:

• . Show all borders.

• . Show only external borders.

• . Show only internal borders.

• . Do not show borders.

Multiple selection is available for single border type modes:

• . Show internal horizontal border.

• . Show internal vertical border.

• . Show left border.

• . Show right border.

• . Show top border.

• . Show bottom border.

To cancel displaying of borders of the selected range:

• Click the button in the Special Border group on the parameters panel.

• Click the Do not Show Borders button.

• Line Type. Select line type in drop-down menu.

• Line Color. The parameter determines a border line color. Select a color in the drop-down palette or set it in the RGB or HEX format.

To fill in empty or zero cells, enter text, number, or characters in corresponding boxes.

The values, with which empty cells are filled, including numeric ones, will not be saved in the data source.

To remove filling of empty or zero cells, click the Delete button.