Setting Up Table Style

To open the Table Style or the Predefined Styles group of parameters on the parameters panel:

1. Select a cell or a cell range.

2. Click the Parameters button on the toolbar. The parameters panel opens.

3. Select the required area type in the drop-down menu of the parameters panel title.

4. Go to the Table Style/Predefined Styles group of parameters.

To apply a style to cells or a table, select one of the standard styles or sheet styles in the Table Style group of parameters. The following standard styles are available:

NOTE. One can apply table styles for several areas on an active sheet.

To create a custom table style:

1. Click the Create Table Style button. The button is available in the Table Style group of parameters for the Cells area.

2. Determine required custom style settings:

The following settings are available:

• Based on Style. In the drop-down list select one of the standard table styles (Blue, Dark Blue, and so on). The selected style is copied to the edited one.

• Style Elements. The list contains all style elements, which formatting parameters can be set up. When an element in this list is selected, the current style settings are displayed below. To change formatting of the selected style element, click the Edit button. The Element Format group of parameters opens containing various formatting settings. To set default formatting parameters, click the Delete button.

• Stripe Size. Set stripe size in rows by means of the value editor or the keyboard.

• Table Sample. This area displays table appearance after applying the set parameters. Check if the table appearance corresponds to the expected result.

To edit the style, select the Edit context menu item for the style to be changed in sheet styles. The Create Table Style group of parameters opens containing various style settings.

NOTE. Style editing is available in the Table Style group of parameters for the Cells area.

Standard styles used in report can be edited in sheet styles. After the style is edited, it becomes a custom one.

To delete a style, select the Delete item in the style's context menu in the Table Style group of parameters in sheet styles.

Depending on the selected area type, deletion can be executed in the following ways:

• For the Table area. Click the Clear button. All styles applied to table will be deleted from sheet styles. If styles were not applied, the button is disabled.

• For the Cells area. Click the Delete button. A drop-down list with the following commands appears:

• Delete Selected Table Style. It deletes the styles applied to the table with selected cells.

• Delete All Styles from Sheet. It deletes all styles applied on an active sheet.

NOTE. When table styles are deleted, the settings specified in the Formatting group of parameters are saved.