Setting Up the Table Visualizer

To create a table, use the boxes:

Available table settings are given in the Setting Up Table and Its Elements section.

To exclude row or column from table:

1. Select header of the row or column to exclude.

TIP. To select several rows/columns, hold down the CTRL key during the selection.

2. Select the Exclude item in the context menu of the selected row or column header.

As a result, the row or column is excluded from the table.

To exclude all data from table except for the selected:

1. Hold down the row or column header, which data must be displayed in the table.

TIP. To select several rows/columns, hold down the CTRL key during the selection.

2. Select the Exclude the Rest item in the context menu of the selected row/column header.

As a result, all data except for the selected is excluded from the table.

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

• To freeze table heading, select the Freeze > Heading item in the context menu of the element located in the heading.

• To freeze table sidehead, select the Freeze > Sidehead item in the context menu of the element located in the sidehead.

• To freeze arbitrary area with several rows and columns, select the cell, which top left corner will determine frozen rows and columns. Then select the Freeze > Arbitrary Area item in the element's context menu.

The selected areas are frozen during copying, duplicating and export of visualizer to XLSX.

NOTE. One can freeze table heading and sidehead at the same time. Freezing of table's arbitrary area has a higher priority than freezing of heading and sidehead.

To unfreeze heading, sidehead, or arbitrary area, deselect the checkbox of the selected freeze option.