Customize Excel Document View Settings to Match Rendering in PrizmDoc Cloud

Excel document rendering settings in PrizmDoc Cloud are configured to closely match the default Microsoft Excel pagination and print layout for the best fidelity with Microsoft Excel.

While PrizmDoc Self-Hosted supports different view modes for rendering of Excel documents, it is important to know that the default rendering behavior of the PrizmDoc Self-Hosted product is different from PrizmDoc Cloud due to the following out of the box product behavior:

• PrizmDoc Self-Hosted renders hidden content
• PrizmDoc Self-Hosted ignores Print Area and renders the content outside of that area
• PrizmDoc Self-Hosted ignores document margin settings
• PrizmDoc Self-Hosted ignores document page dimension settings, and applies custom pagination logic
• PrizmDoc Self-Hosted forces rendering of gridlines

Note: the default rendering behavior of PrizmDoc Self-Hosted is expected to be changed in a future release to accurately match rendering in PrizmDoc Cloud.

To configure PrizmDoc Self-Hosted Excel document view settings to match rendering in PrizmDoc Cloud, 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.

Specifically modify the following parameters:

Example

fileTypes.excel.renderHiddenContent: false
fileTypes.excel.renderOnlyPrintArea: true
fileTypes.excel.margins.mode: preserve
fileTypes.excel.pagination.dimensions.mode: preserve
fileTypes.excel.renderGridlines: false

• fileTypes.excel.renderHiddenContent – specifies whether or not the hidden rows, hidden columns, and whole spreadsheets that are hidden in the original Excel workbook are to be rendered.
• fileTypes.excel.renderOnlyPrintArea – specifies whether the print areas defined in the Excel workbook are to be honored or not. When set to "true", only the content defined within the print areas will be rendered. When set to "false", the content that goes beyond print areas will be rendered as well.
• fileTypes.excel.margins.mode - set to "remove" to remove all margins from the document pages, set to "preserve" to use the page margins specified in the Excel file. Please note, "preserve" value requires that fileTypes.excel.pagination.dimensions.mode be set to "preserve" and Microsoft Office renderer to be active.
• 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.renderGridlines – specifies whether or not the Excel gridlines in all worksheets of the workbook should be rendered.