We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Issue with vertical page breaks- excel adds its own page breaks when vertical page breaks are set using aspose

Hi

Excel adds its own page breaks when vertical page breaks are set using aspose. Page breaks are not inserted wherever its required as per my requirement. Also how to set 'Adjust to' radio option in page set up using java aspose instead of 'Fit to tall/wide'. Please do the needful. Attaching Input and output excels and sample code. Need output as per attached 'Required output' excel.

Thanking you in advance. Your sooner response would be appreciable.

Hi Anitha,

Thanks for your posting and using Aspose.Cells.

We think, it is a correct behavior, because whenever you will add a page break, the other vertical and horizontal page breaks will be added by Excel to cover the entire worksheet.

You can try it on Microsoft Excel and click the Page Break Preview, you will see lot of page breaks have been added by Excel spanning across the entire worksheet.

You can set the scaling factor of Page Setup using the Worksheet.getPageSetup().setZoom() method for your needs.

Let us know if you have any other questions, we will look into it and help you asap.