Customize Excel Document View Settings for PrizmDoc Server

PrizmDoc Server supports different view modes for rendering of Excel documents. To customize Excel view 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 Excel viewing settings:

Example

fileTypes.excel.margins.mode: remove
fileTypes.excel.renderGridlines: true
fileTypes.excel.renderOnlyPrintArea: false
fileTypes.excel.renderHeadersAndFooters: true
fileTypes.excel.renderHiddenContent: true

• 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.renderGridlines – specifies whether or not the Excel gridlines in all worksheets of the workbook should 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.renderHeadersAndFooters – specifies whether or not headers and footers of an Excel workbook should be rendered. When set to "true", even if the original document is missing the headers and footers, a space for headers and footers shall be reserved when rendering an Excel document.
• 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.

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

To customize Excel view 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 Excel viewing settings:

Example

"officeConversionService": {
    ...
    "excelRenderGridlines":true,
    "excelRenderOnlyPrintArea":false,
    "excelRenderHeadersAndFooters":true,
    "excelRenderHiddenContent":true
    ...
},

• excelRenderGridlines – specifies whether or not the Excel gridlines in all worksheets of the workbook should be rendered.
• excelRenderOnlyPrintArea – specifies whether the print areas defined in 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.
• excelRenderHeadersAndFooters – specifies whether or not headers and footers of an Excel workbook should be rendered. When set to "true", even if the original document is missing the headers and footers, a space for headers and footers shall be reserved when rendering an Excel document.
• excelRenderHiddenContent – specifies whether or not the hidden rows, hidden columns, and whole spreadsheets that are hidden in the original Excel workbook are to be rendered.