Print settings for PDF format file in java aspose

Aspose.Cells Product Family
1

Hi

How to do Print settings for PDF format file in java aspose. We implemented print settings like pageSetUp vertical breaks etc for excel and converted that excel to PDF in java aspose. But that converted PDF file is not behaving properly as expected i.e vertical page breaks are not visible in PDF to split large data into multiple pages.

Appreciate your help by giving response sooner. Thanking you in advance.

Regards

Anitha

2

Hi Anitha,


Thank you for contacting Aspose support.

There could be several reasons for the API to behave incorrectly while rendering spreadsheets to PDF format. For instance, if you have enabled the OnePagePerSheet or AllColumnsInOnePagePerSheet options from PdfSaveOptions class, the PageSetup configurations may not take effect. It would be of great help in understanding your scenario if you can share the following information/artifacts.

  1. Your input/template spreadsheet (if any).
  2. Your desired results that you may create manually in Excel application.
  3. Your current source code to convert spreadsheet to PDF format.