Customize Excel Pagination Settings for PrizmDoc Server

PrizmDoc Server supports two basic pagination modes for rendering Excel documents:

• Non-paginated
• Paginated

In non-paginated mode, each Excel sheet, irrespective of its size, is rendered onto a single page. If the number of columns and/or rows is large, then this might result in very small and unreadable output. In paginated mode, each Excel sheet is divided into a number of pages, such that each page fits into a specific size.

To customize Excel pagination settings, edit the central configuration file.

Notes:

1. The file paths for the Central Configuration file are:
   • Linux: /usr/share/prizm/prizm-services-config.yml
   • Windows: C:\Prizm\prizm-services-config.yml
2. The default installation directory is: C:\Prizm.

Modify the following parameters to adjust pagination settings:

Example

fileTypes.excel.pagination.enabled: true
fileTypes.excel.pagination.dimensions.mode: override
fileTypes.excel.pagination.dimensions.minWidth: 11.0in
fileTypes.excel.pagination.dimensions.maxWidth: 22.0in
fileTypes.excel.pagination.dimensions.minHeight: 8.5in
fileTypes.excel.pagination.dimensions.maxHeight: 17.0in

• fileTypes.excel.pagination.enabled – set to "false" to disable pagination, set to "true" to enable pagination.
• fileTypes.excel.pagination.dimensions.mode - set to "override" to use custom page dimensions, set to "preserve" to use the page dimensions specified in the Excel file. Please note, "preserve" value requires that fileTypes.excel.margins.mode be set to "preserve" and Microsoft Office renderer to be active. If the fileTypes.excel.pagination.enabled parameter is set to "false", than this parameter is ignored.
• fileTypes.excel.pagination.minWidth, fileTypes.excel.pagination.maxWidth, fileTypes.excel.pagination.minHeight, fileTypes.excel.pagination.maxHeight – non-negative doubles. These parameters specify the minimum and maximum sizes, in inches, for pages dynamically generated in the paginated rendering mode. If the fileTypes.excel.pagination.dimensions.mode parameter is set to "preserve", then these 4 parameters are ignored.

Important: The following configuration properties have been deprecated and will be removed in a future release. Alter these properties only if not using the central configuration file.

To customize Excel pagination settings using legacy configuration, edit the Watchdog configuration file located in the following default directories:

• Windows: C:\Prizm\PCCIS\Watchdog\watchdog.config
• Linux: /usr/share/prizm/pccis/Watchdog/watchdog.config

Modify the following parameters to adjust pagination settings:

Example

"officeConversionService": {
    ...
    "excelPagination":true,
    "excelPageWidthMin":11.0,
    "excelPageWidthMax":22.0,
    "excelPageHeightMin":8.5,
    "excelPageHeightMax":17.0     
    ...
},

• excelPagination – set to "false" to disable pagination, set to "true" to enable pagination.
• excelPageWidthMin, excelPageWidthMax, excelPageHeightMin, excelPageHeightMax – non-negative doubles. These parameters specify the minimum and maximum sizes, in inches, for pages dynamically generated in the paginated rendering mode. If the 'excelPagination' parameter is set to "false", then these 4 parameters are ignored.