I have a ASPxGridView that I am exporting using the ASPxGridViewExporter. When I export it using the PrintingSystem objects to an XLSX format, I get the following message when opening in Excel 2010:
http://screencast.com/t/s3G5pXY7NSd
If I click Yes to the first message, I get the following second message:
http://screencast.com/t/tENmGgh9s
I click Close and the exported grid looks fine but am wondering about the messages and what might be causing this. I have other ASPxGridViews that export fine to the XLSX format so I'm not sure what is making this one different.
Any ideas?
Thanks,
Greg
Hello Greg,
Different causes can lead to such an error. We also had several bugs that caused this issue, but they have been resolved. If you are using the recent v13.2.9 version (as mentioned in the Build file of this ticket), these bugs should not cause an issue any more.
Would you please clarify if the issue always occurs, or only if specific data is exported? If the issue is data-specific, we will need a test sample for further research. Otherwise, please demonstrate how you export ASPxGridView data in your project, and we will research this issue on our side.
I finally figured out this issue. It appears that Excel was trying to merge the content in the first cell and appears that the length of the content including carriage returns was too long. Once I shortened the content by removing a few carriage returns, the export to Excel opened without any warnings/errors.
Hi Greg,
Thank you for posting this information here. I believe it would be helpful for our other customers. I have re-posted your comment to the Solutions section.