Cell Style

Version

Function Description

You can select a cell, choose Cell Attribute > Style on the right, and set the cell style to Theme or Custom, as shown in the following figure.

Note:

The Style setting only controls the display effect of cells without affecting the actual values of cells.

1. After selecting a cell, choose Cell Attribute > Style. Style Setting is set to Theme by default. You can select a style in Application Style. The styles in Application Style come from the theme selected for the current template. Different themes have different styles, as shown in the following figure.

2. You can select the needed theme according to your actual needs, or customize the theme and the styles in the theme. For details, see Template Theme Management.

After selecting a cell, choose Cell Attribute > Style and set Style Setting to Custom. You can set Text, Cell, and Alignment separately, as shown in the following figure.

Text

Font

You can set the font type, font style, font size, color, underline, strikethrough, shadow, superscript, and subscript in the Font setting. There is no superscript or subscript by default, as shown in the following figure.

Note:

1. Due to limitations (minimum font size during report preview: 9) in the Chrome browser, the font size will still be 9 during report preview even if a smaller font size is set.

2. The shadow effect is only supported in versions 10 and 11 of the IE browser.

Cell

Border

You can set the line style and color for inside and outside borders under Cell > Border, as shown in the following figure.

Note:

After you set cell borders, the final display effect may vary depending on the rendering method of the browser. Even with the same setting, the borders may be displayed differently in different browsers.

Note:

You can also click the Border icon on the toolbar to customize cell borders, as shown in the following figure.

Background

The options for Fill for the cell background are similar to those for the report background. For details, see Report Background.

Alignment

Basic

Alignment specifies how texts within a cell are aligned. You can set Horizontal Alignment and Vertical Alignment separately, as shown in the following figure.

Horizontal Alignment can be set to Left, Center, Right, Distributed, or Default. If you select Default, numbers are right-aligned by default, while non-numeric characters are left-aligned by default.

Vertical Alignment, can be set to Top, Center, or Bottom. Vertical Alignment is set to Center by default.

Note:

When Horizontal Alignment is set to Distributed, the cell content will be displayed as an image with font changes during preview. In this case, the Distributed effect will turn invalid when the report is exported as a Word or Excel file.

Advanced

1. Image Layout

When the cell content is an image, you can set Image Layout to Default, Tile, Stretch, or Adapt, as shown in the following figure.

2. Text Style

Text Style can be set to Wrap Text, Single Line, Single Line (Adjust Font), or Multi-Lines (Adjust Font), as shown in the following figure.

The following table shows the specific differences among the four text styles.

Style	Definition	Example
Wrap Text	The font size remains unchanged Texts are displayed according to the cell size and wrapped automatically if they cannot be fully displayed in one line..
Single Line	The font size remains unchanged. Texts are displayed according to the cell size and truncated if they cannot be fully displayed in one line.
Single Line (Adjust Font)	The font size is adjusted accordingly. All texts are fully displayed in one line by default.
Multi-Lines (Adjust Font)	The font size is adjusted accordingly. All texts are displayed in multiple lines by default.

Note:

 1. For the Wrap Text setting to take effect, you have to select Auto Adjust Height under Cell Attribute > Others first. If you only select Wrap Text, the setting will not take effect.

2. If you select Single Line (Adjust Font) or Multi-Lines (Adjust Font), the cell content will be exported in the format of an image instead of text.

3. Text Orientation

Text Orientation can be set to Custom Angle, Vertical Text (Left to Right), or Vertical Text (Right to Left). The following figure shows the effects of these methods.

Note:

The cell content will be displayed in the format of an image during browser preview except when Custom Angle is set to 0.

4. Indentation

You can set the left and right indentation distances for texts in a cell. The texts are indented by 2 px both left and right by default, as shown in the following figure.

5. Spacing

You can set the spacing before a paragraph, the spacing after a paragraph, and the line spacing within a cell, as shown in the following figure.

The spacing before a paragraph refers to the distance before the current paragraph in the cell.

The spacing after a paragraph refers to the distance after the current paragraph in the cell.

The line spacing refers to the distance between each line of text in the cell.

How to Reset the Style to Default

Step one: Select a cell, choose Cell Attribute > Style, set Style Setting to Theme, and select Small title in Application Style, as shown in the following figure.

Step two: Click Custom, as shown in the following figure.

In this case, the custom style applied to the cell mirrors the style selected in Theme in step one. You can also modify the style to other ones here.

Step three: Click Theme again. In this case, the cell style is reset to the Default style, as shown in the following figure.

How to Reset the Style to Default After Template Theme Switchover

1. Select Compatible Theme on the upper toolbar, choose Cell Attribute > Style, set Style Setting to Theme, and select an application style in Application Style, as shown in the following figure.

2. Switch the template theme to Classic Light Grey. Since no corresponding cell style exists in the Classic Light Grey theme, the cell style selected in the above step will be reset to the Default style, as shown in the following figure.

Mobile Terminal

All cell styles (except some custom cell styles) in Theme can be displayed on mobile terminals. The following explains the details.

1. Cell > Border: Only solid lines and equally spaced dashed lines are supported in the DataAnalyst app of 9.0 and later versions. Other line styles are not supported.

2. Alignment > Horizontal Alignment: The Default setting is supported in the DataAnalyst app of 9.0 and later versions.

3. Alignment > Text Style: Single Line (Adjust Font) and Multi-Lines (Adjust Font) are not supported on the HTML5 terminal.

4. Alignment > Text Orientation: The setting is not supported on mobile terminals.