Free Support Forum - aspose.com

Excel Report - Page Breaks

Hi,

Our application use Aspose.cells version 7.3.0.0 for creating Excel report based on Excel template.

When generating report, sometimes the page breaks are displayed.

User need to go over to ..Developer->Properties->DisplayPageBreaks and set it to 'False'.

I would like to handle this automatically in code when report in generated. so, the output will come out with no page breaks.

Thanks,

Hi,



Thanks for your posting and using Aspose.Cells for .NET.



It seems this feature is not available. We need to look into it and add it.



However, you can use the Worksheet.IsPageBreakPreview property to set the page break preview of worksheet on/off.


Let us know if it fits your needs.

We have also added a New Feature Request for this issue in our database. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41238.

Please see the following screenshot that explains your requirements for a reference.

Screenshot:

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We have looked into your issue and found that this property cannot be supported because if you open the file again in MS Excel, you will find the property is lost, so
the file does not contains this setting.

We could not support it.