Repeat and Freeze

Version

Application Scenarios

When the table is too large or cannot be displayed in one page, you need to repeat and freeze the title or header.

Scenarios not Supported by Freezing

Floating elements, collapse trees, browsers with zooming in or out, merged cells covering frozen and unfrozen areas are not supported.

Pagination Preview

Choose Template > Repeat and Freeze in the menu bar, and the Repeat and Freeze interface will pop up. Select Pagination Preview.

1. Repeat supports settings for Title Area and End Area, including Repeat Title Rows, Repeat Title Columns, Duplicate Last Row, and Duplicate Last Column.

Note:

This function is supported on mobile terminals.

2. Freeze supports settings for Title Area and End Area.

Function	Explanation
Title area	Allows freezing the title row or title column. For details about pagination freezing, see Pagination Freezing. This function is supported on mobile terminals.
End area	Allows freezing the end row and end column. End area freezing only takes effect in the following scenarios: 1. Using pagination preview in general reports with Engine-X. For details, see Freezing End Row with Engine-X. 2. New version dashboards are previewed on PC. Note: This function is not supported on mobile terminals.

Data Entry Preview

Choose Template > Repeat and Freeze in the menu bar, and the Repeat and Freeze interface will pop up. Select Data Entry Preview.

Data entry preview allows freezing row or columns. For details about data entry freezing, see Data Entry Freezing.

Open a dashboard, click  to edit the report block. Click Freeze in the toolbar, and the Repeat and Freeze interface will pop up.

1. Repeat supports settings for Title Area and End Area, including Repeat Title Rows, Repeat Title Columns, Repeat Last Row, and Repeat Last Column.

2. Freeze supports settings for Title Area, including freezing the title row or title column.

Note:

End area freezing only takes effect in new version dashboards.

1. Freezing in Data Analysis Preview is the same as that in Pagination Preview.

2. Merged cells cannot span across frozen areas, otherwise the cell merging will not take effect.

For example, merge cells A1 to E1 and only freeze columns A to C. During preview, cells A1 to C1 will be merged and cells D1 to E1 will be merged.

3. You can only freeze consecutive rows in CPT reports. If you need to freeze rows with intervals, concatenate report blocks in a dashboard.

4. When there are frozen rows or columns in a report block, the old self-adaption of the report block does not take effect, and the new self-adaption requires you to set the row height to be smaller than the page size of report block, otherwise there will be blank areas. For details, see Dashboard Adaptive Attribute.

5. When you use freezing and header and footer at the same time, the header and footer will not appear on the web (but appear in the exported file).