XLS or XLSX Page Content Truncated
Your XLS or XLSX page content may be truncated because XLS and HTML-formats do not include the page size in the document like Word and PDF. It can be set explicitly similar to how you can set the page size when printing. To set the page size to avoid truncated content, use the xlsHeight
, xlsWidth
, xlsxHeight
, and xlsxWidth
parameters in the web.xml
file as shown in the examples below.
For XLS files set the parameters as shown in the example below to the height and width that you would like for your document:
<init-param>
<param-name>xlsHeight</param-name>
<param-value>11</param-value>
</init-param>
<init-param>
<param-name>xlsWidth</param-name>
<param-value>14</param-value>
</init-param>
For XLSX files, set the parameters as shown in the example below to the height and width that you would like for your document:
<init-param>
<param-name>xlsxHeight</param-name>
<param-value>11</param-value>
</init-param>
<init-param>
<param-name>xlsxWidth</param-name>
<param-value>14</param-value>
</init-param>
Have questions, corrections, or concerns about this topic? Please let us know!