HPageBreaks

Hi,

I have a problem with Aspose.Cells and HPagebreaks.

I Have more than 4000 records, splitted in different sheets and I need to make a HPagebreak each 2 records. But I have the following exception

Exception of type 'System.Web.HttpUnhandledException' was thrown.
The count of HPageBreaks cannot be larger than 1024.

Does someone has the solution ?

Thanks in advance

Hi,


It might be a limitation of Ms Excel regarding Horizontal Page Breaks but I am not 100% sure. Could you do it manually in MS Excel? If you could perform the task in MS Excel, give us your sample code (or sample console application, you may zip it) and template file to reproduce the issue on our end. We will look into it soon.

Thank you.


Hi,

And, please check the articles (Excel 2003 and 2010):

http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx

Page breaks 1000 horizontal and vertical

You can have 1000 horizontal and vertical page breaks in MS Excel 2003 and 1026 in MS Excel 2010. We follow MS Excel Standards, so it is a limitation of MS Excel and nothing to do with Aspose.Cells component.

Thank you.

Thank you

Hi,

Thanks for your understanding.

If you encounter any other problem, please feel free to let us know, we will be happy to help you.