Viewer of excel limited to 2 pages

GroupDocs.Viewer Product Family
1

Hello,

Using java Viewer to convert excel file (with more than 2 pages) to html pages generates only 2 pages when calling Viewer#view(ViewOptions viewOptions, int… pageNumbers) method.
If we call Viewer#view(ViewOptions viewOptions) all pages (html) are generated.

I attach a demo to reproduce the issue.

My environment is:
java version “1.8.0_451”
Java™ SE Runtime Environment (build 1.8.0_451-b10)
Java HotSpot™ 64-Bit Server VM (build 25.451-b10, mixed mode)

Operating System: Ubuntu 22.04.5 LTS
Kernel: Linux 6.5.0-44-generic
Architecture: x86-64
groupdocs-viewer-src-excel-2sheets.zip (58.5 KB)

2

Hello @catalin.croitoru ,

Thank you for reaching out to us. We have reviewed your example of using our library and found that the issue you described is related to the property viewOptions.getSpreadsheetOptions().setRenderingPrintAreaAndPageBreaks(true). Once you disable it, you will be able to generate the required number of pages. We will continue investigating to identify the reasons for this behavior, and we will inform you as soon as we have further updates.