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 or the 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 the required custom style settings:

The following settings are available:

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

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

• Stripe Size. Set stripe size in lines using the value editor or keyboard.

• Table Sample. This area displays how a table will look after specified parameters are applied. Check if the table appearance corresponds to the expected result.

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

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

Standard styles used in a data entry form are available for editing in sheet styles. After the style is edited, it becomes a custom one.

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

Depending on the selected area type, a style can be deleted using the following methods:

• For the Table area. Click the Clear button. All styles applied to a table will be deleted from sheet styles. If styles are 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.