Setting Up Report Formatting and Display Type

To change sheet zoom:

Select one of the predefined zoom options using the Select button next to the current zoom value:

Change the current zoom value with the custom one:

To change the entire report zoom, use browser means.

To fix report areas on the screen on scrolling, freeze them:

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.

Rows/columns can be resized in several ways:

Manual resize. To manually resize rows/columns, execute the following operations:

For column. Hover the cursor to the column's right border in the header area, click the border, hold down the cursor and drag it to the required distance. Actual column width is displayed in the tooltip.
For row. Hover the cursor to the row's bottom border in the header area, click the border, hold down the cursor and drag it to the required distance. Actual row height is displayed in the tooltip.

Exact resize. To set precise size, execute the following operations:

For row. Select the Resize Row context menu item of the selected row or row header. In the dialog box that opens enter (change) row height value in pixels or millimeters:

For column. Select the Resize Column context menu item of the selected column or column header. In the dialog box that opens enter (change) column width value in pixels or millimeters:

Quick row height fit. To quickly fit row or column size by contents, execute one of the operations:

Select the Fit Row Height/ Fit Column Width context menu item of the selected cell or row/column header.
Select the View > Fit Row Height/View > Fit Column Width main menu item for the selected cell or row/column header.
Double-click the right border of the column header/bottom border of row header.

Each of the above-mentioned methods of row/column resize can be applied both to a single row/column and to a row/column group. The changed size is applied for each row/column in the group.

To show or hide row/column headers, grid, scrollbars, and sheet tabs, select or deselect checkboxes next to the required element in the drop-down menu after selecting the View > Show main menu item.

Setting Up Report Formatting

To open the parameters panel:

Select a cell or a cell range.
Click the Parameters button on the toolbar.

After an area type is selected in the drop-down list, the corresponding cells in the working area will be automatically selected.

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. 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 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. 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. Select a solid fill color for plot area in the drop-down palette or set it in the RGB or HEX format. If required, specify fill transparency degree.
Two-Color Fill. Select start and end colors of the two-color gradient in the drop-down palette or set them in the RGB or HEX format. If required, specify tilt angle and fill transparency degree.

NOTE. If solid fill is selected, color indication of the Fill Color button changes to the selected color, and if two-color fill is selected, it 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 cancel displaying of borders of the selected range:

. Do not show borders.

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

To unmerge merged cells, select a merged cell and click the Merge Cells button again.

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 following 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 by words. 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. Depending on the selected format, different settings are available:

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 the required number of times. 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. The entered numbers in this format are worked in a different way depending on the use of the % character. 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 the required number of times. 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. To executed advanced setup of data format, use the Format Cells group of parameters on the parameters panel.

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

NOTE. Formatting of the first character is saved for the cell on replacing or deleting text from the cell.

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

Clear button on the toolbar.

Setting Up Report Formatting and Display Type

Setting Up Report Display Type

Setting Up Report Formatting

Quick Setup of Cell Format