PrizmDoc Server supports different view modes for rendering of Excel documents. To customize Excel view settings, edit the central configuration file.
The file paths for the Central Configuration file are:
- Linux: /usr/share/prizm/prizm-services-config.yml
- Windows: C:\Prizm\prizm-services-config.yml
Note: The default installation directory is: C:\Prizm.
Modify the following parameters to adjust Excel viewing settings:
| Example |
Copy Code
|
fileTypes.excel.renderGridlines: true
fileTypes.excel.renderOnlyPrintArea: false
fileTypes.excel.renderHeadersAndFooters: true
fileTypes.excel.renderHiddenContent: true
|
-
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.
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:
Modify the following parameters to adjust Excel viewing settings:
| Example |
Copy Code
|
"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.
