Ticket Q588135
Visible to All Users

Excel Messages when opening Exported ASPxGridView using ASPxGridViewExporter

created 11 years ago

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

Comments (3)
DevExpress Support Team 11 years ago

    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.

    G G
    Greg Knierim - Skyline 11 years ago

      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.

        Answers approved by DevExpress Support

        created 11 years ago

        Posted by the Greg Knierim - Skyline:

        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.

          Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

          Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.