I have tried to generate a excel file in 2007 format using aspose api, but when i am trying to open it using Ms-Excel, then ms-excel prompting to recover the same file. The problem is related with some limit factor means when data is low it works fine but after some limit data it starts creating problem.
Please find the attached screen-shot of error and excel file that having problem.
After checking your file, we have found the issue is caused by too many duplicated pagebreaks have been put into the PageBreaks collection. So, you should thoroughly check your code to avoid placing same pagebreak into the collection many times, you should fix your code and the issue should be fixed. And, we will also provide a new fix later to enhance the API of HPageBreaks/VPageBreaks.add() in which we will check the existence of the added PageBreaks.
Please try the attached version.
We have enhanced the methods for adding pagebreaks. When adding
pagebreaks, we will check whether the added pagebreak is existed to avoid
adding same pagebreak into the collection repeatedly.
We have tried the attached jar file for creating excel files, but the problem still exist, please find the attached excel that has problem.
Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Thank you for the feedback.
We will look into your shared file and get back to you soon.
Thank You & Best Regards,
We are waiting for your response. Please tell how soon can you get back to us on this? We have to plan our project plan accordingly.
We have further analyzed your issue. We come to conclusion that it is not an issue with the component rather it is the limit of MS EXCEL. If there are 1024 pagebreaks in the worksheet, when you try to add one new pagebreak, you will get a warnning message. You may confirm it manually in MS Excel.
Thanks for your understanding!