SAP Knowledge Base Article - Public

1216446 - Misaligned column headers appear in Excel after exporting from Crystal Reports 8.5

Symptom

In Crystal Reports 8.5, after exporting a report to Microsoft Excel version 5, 7, or 8 Extended format, the column headers are misaligned.

Resolution

This is a known issue with the Database and Export Drivers Pre-Version 9 and has been tracked with ID ADAPT00175330.

Hot Fix updates addressing this issue are available as indicated below. With the updates, the columns of the report should now align properly when exported to Microsoft Excel Extended format, using the u2fxls.dll.

IMPORTANT: Unless indicated otherwise, Hot Fix updates have only been tested with English versions of Crystal Reports 8.5.

For Crystal Reports 8.5, the fix is included in the most recent Crystal Reports 8.5 Service Pack. The Service Pack is available for English, French, German, and Japanese languages.

This issue is corrected in the following components versions and later:

U2fxls.dll, version 8.6.2.515, dated 08/08/2003

For Crystal Enterprise 8.5 for Windows deployments, the fix is included in the most recent Crystal Enterprise 8.5 Service Pack. The Service Pack is available for English, French, German, and Japanese languages.

If you have made any modifications to ePortfolio, the Crystal Enterprise 8.5 Service Pack may overwrite your custom code. Therefore, it is recommended that you back up your ePortfolio directory before applying the Service Pack.

For Crystal Enterprise 8.5 SAP Edition and SAP Enhanced Edition deployments for Windows, the fix is included in the most recent Crystal Enterprise 8.5 SAP Edition and SAP Enhanced Edition for BW 3.0 Service Pack. The Service Pack is available for English, French, German, and Japanese languages.

If you have made any modifications to ePortfolio, the CE 8.5 Service Pack may overwrite your custom code. Therefore, it is recommended that you back up your ePortfolio directory before applying the Service Pack.

Keywords

CR CE SI SP EXCEL EXPORTING COLUMN HEADERS Crystal Reports EXCEL Columns SP CR85SP3 CE85SP2 CE85SAPSP2 SI75SP , c2013983 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

SAP Crystal Reports 8.0