Open the Formatting group of parametersTo set up formatting of table sidehead, heading, corner, data, single table dimension elements located in columns/rows, and row/column totals, use the Formatting group of parameters on the side panel.
Open the Formatting group of parameters
To open the Formatting group of parameters on the side panel:
On the side panel:
Select table element.
Press the 
Settings button on the toolbar. The side panel is hidden by default.
Select the required table element type in the drop-down menu of the side panel title.
In the working area:
Select table element.
Select the Formatting context menu item.
Select the required table element type.
Formatting parameters depend on the selected area type:
The following settings are available depending on the selected table element:
It is available only for the Corner table element.
To set up table corner contents, select corner contents option in the Formatting group of parameters or in the table corner's context menu:
Do not Show Name. Default value. Table corner is empty, and name is not displayed.
Name from Heading. On the settings panel in the drop-down list select the dimension, which name should be displayed in the table corner.
Name from Sidehead. Default value. On the settings panel in the drop-down list select the dimension, which name should be displayed in the table corner.
Custom Name. On the side panel in the edit box enter the name. When the Name from Heading or Name from Sidehead option is selected, custom name is reset.
After executing the operations the table corner contents is set up.
Features of displaying table corner name:
If table heading or sidehead contains several dimensions, corner cells are merged into one if the Custom Name option is selected. Previous corner names are reset.
If table heading or sidehead contains several dimensions, the name edit box displays name of the first dimension in the list if the Name from Heading or Name from Sidehead option is selected. Table corner will be split into several cells, which names correspond to heading or sidehead dimensions.
If table heading or sidehead contains no dimensions, the corner remains empty if the Name from Heading or Name from Sidehead option is selected.
The example of table corner with custom name:
Set up font options:
Font. Select one of the available fonts in the drop-down list.
Font Size. Set the required font size. Size is set in points, it can be entered manually or using the keyboard. The range of available values: [6; 36].
Font Color. Select font color in the drop-down palette. One can select standard and custom colors. The palette contains only standard colors by default.
To create a custom color:
Click the 
Add Color button. The advanced color palette opens.
Select a color in the advanced color palette, use color picker to select color on a browser page, or set color code in the RGB or HEX format.
After executing the operations the custom color is created and added to the palette.
To delete custom color from the palette, select the Delete item in the selected color's context menu.
NOTE. The maximum possible number of custom colors in the a palette is 23.
Font Style. Select font style in the button's drop-down menu:
B. Bold.
I. Italic.
U. Underline.
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. Select a cell text alignment option in the button's drop-down menu:
. Left.
. Center.
. Right.
. By width.
After executing the operations the specified font options are applied for the selected table element.
To reset the determined settings and restore the default style, click the Reset button.
To set up fill, set the parameters:
Background Color. Select fill option for background in the drop-down menu:
No Fill. Fill is not used by default.
Solid Fill. Go to the One Color tab and select plot area solid fill color in the drop-down palette.
Two-Color Fill. Go to the Two Colors tab and select start and end colors of two-color gradient in the drop-down palette. Specify tilt angle if required.
Hatching. Select hatching option in the drop-down menu:
No Hatching. Hatching is not used by default.
Hatching Types. After hatching type is selected, set hatching color in the drop-down color palette.
Image. To use an image to fill table element:
Toggle the Image switch to active state. The switch is inactive by default, and table element fill is set up using standard options.
Click the Select File button and select the file in the dialog box that opens.
After an image is selected, the file name is displayed in the corresponding box, the table element is filled with the use of the image.
To replace the image, click the Select File button again.
After the image is selected, the following settings are available:
Download. Click the Download button to export the image used as a fill.
Stretch Image. The checkbox is deselected by default, the table element image corresponds to its original size. To fit image into table element, select the checkbox.
To remove the image, click the 
Remove button next to the texture name.
After executing the operations, the specified fill settings are applied for the selected table element.
To reset the determined background fill and hatching settings and restore the default style, click the No Color button.
To set a custom color:
Click the Add Color button in the standard color palette and select the color in the advanced color palette.
Select a color in the advanced color palette, use color picker to select color, or set color code in the RGB or HEX format.
After executing the operations the custom color is added to the palette.
NOTE. The maximum possible number of custom colors in the a palette is 23.
To delete custom color from the palette, select the Delete item in the selected color's context menu.
In the order of fill application for table elements, each following point has a higher priority and overlaps the previous point:
Data (lowest priority).
Column totals.
Row totals (highest priority).
To reset the determined fill settings, click the Delete button next to the Fill tab name.
To set up borders:
Select the borders to be displayed:
All borders.
Inner borders.
Horizontal border between cells.
Vertical border between cells.
Outer border of selected element.
Border is set to the left from the selected element.
Border is set to the top from the selected element.
Border is set to the right from the selected element.
Border is set to the bottom from the selected element.
No borders.
Select border style type in the Line button's drop-down menu. The No Borders option is selected by default, and border is not displayed.
Select border color in the drop-down color palette. If required, specify border fill opacity percent. One can select standard and custom colors. The palette contains only standard colors by default.
To set a custom color:
Click the Add Color button in the standard color palette and select the color in the advanced color palette.
Select a color in the advanced color palette, use color picker to select color, or set color code in the RGB or HEX format.
After executing the operations the custom color is added to the palette.
NOTE. The maximum possible number of custom colors in the a palette is 23.
To delete custom color from the palette, select the Delete item in the selected color's context menu.
To reset border line color, click the No Color button.
After executing the operations, the specified border settings are applied for the selected table element.
In the order of special borders application for table elements, each following point has a higher priority and overlaps the previous point:
Entire table (lowest priority).
Corner.
Data.
Row totals.
Column totals.
Sidehead.
Heading (highest priority).
To reset the settings and restore the default style, click the Delete button.
It is available for the Data and Element table elements.
Select format of displayed values in the Format drop-down list. Depending on the selected format, advanced settings of displaying values are available:
When the Number, Currency, Percentage or Exponential value format is selected, in the Decimal Places box determine the number of displayed decimal places using the value editor or the keyboard.
When the Number or Currency value format is selected, in the Negative Numbers drop-down list select the required negative number display option.
When the Currency value format is selected, in the Symbol drop-down list select the required currency.
When the Number value format is selected, select the Thousands Separator checkbox to separate digit groups.
When the Date, Time, or Additional value format is selected, in the Type drop-down list select the required type of displaying values of the selected format.
When the Custom value format is selected, in the Type box select the proper method of displaying values.
NOTE. If data format settings were determined for the fields that are used in creating a table, these settings will be displayed in the Special Format group of settings.
Set up dimension element title
To set up the selected dimension element title, one can use font options, fill settings and border settings described above.
It is available only for the Data table element.
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 for empty or zero cells, click the Delete button.
When table sidehead/heading is selected, totals and column/row subtotals are selected too, but formatting style will be applied only to the selected element, that is, for sidehead/heading.
When formatting style is set for row/column totals and subtotals, settings are applied only for data of totals and subtotals.
If subtotals are displayed in the table, formatting specified for totals is applied subtotals. Formatting is applied only for data of subtotals.
See also:
Setting Up Data Visualization | Setting Up the Table Visualizer