Pagination

## Pagination Paginated template lets you paginate worksheets in a report having the same layout by specifying **the number of records** or **page size** to be generated per page. For example, this feature is helpful in generating reports such as invoices which require to be presented in fixed format with specified number of records on a worksheet grouped by particular data field. In this case, remaining records are rendered on other worksheet, thereby paginating the worksheet based on the specified number of records. Turn on the pagination mode by adding a defined name **TemplateOptions.PaginationMode** and set it to **True**. The pagination mode supports following properties: - **CountPerPage:** The value limits the number of instances (of a grouped value) for a cell template. - **RepeatType:** Enum type. The value can be **PerPage**(Default), **FirstPage**, **LastPage**. Sets the display position of the cell and its descendants in the current group. - **RepeatWithGroup:** Cell reference. Sets the cell and its descendants to be repeated by the specified cell. - **NoRepeatAction:** Enum type. The value can be **ClearCells** (Default), **DeleteRows**, **DeleteColumns**. Sets the action to process the cell and its descendants positions when the cell should not display on the current page. - **RepeatOutput:** Boolean type. The value can be **True** or **False**(Default). Sets whether to display value on each page when merge cells across pages. - **KeepTogether:** Enum type. The value can be **Horizontal**, **Vertical**, **Both**, **None**(Default). Sets if the cell and its descendants should be on the same page as much as possible in the horizontal/vertical direction. - **AttachTo:** Cell reference. Sets the template cell that should always appear together with the specific cell. - **FillMode.OverwriteWithFormat:** When a template cell is expanded, the new instances will overwrite below cells and copy style and merge from the template cell.