«
»

OpenOffice Calc More Compatible Than Excel for Crystal 8.5 Exports

If you are using Crystal Reports version 8.5 and Microsoft Excel 2003 with Service Pack 3, you have probably seen the message “File error: data has been lost” when opening an Excel file created by the Crystal 8.5 export. Usually, I have not noticed any actual data loss, but yesterday I did. The problem seems to become acute when there are multiple subreports on a line in the Crystal report.

The solution is to open the spreadsheet in Calc from the OpenOffice suite, available for free from OpenOffice.org. The spreadsheet that had problems in Excel opened flawlessly in Calc.

Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay
  • LinkedIn
  • Technorati

This entry was posted on Thursday, July 16th, 2009 at 4:16 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “OpenOffice Calc More Compatible Than Excel for Crystal 8.5 Exports”

  1. Open Source Software Demystified | friendlysystems.com Says:
    September 11th, 2009 at 8:42 am

    [...] be able to switch with no problem, and stop paying Microsoft Office license fees. I have even found one case where OpenOffice actually works better than Excel 2003 in opening exported spreadsheet from Crystal [...]

Leave a Reply

You must be logged in to post a comment.