SAP Knowledge Base Article - Public

1296001 - Column width is truncated after exporting report to Excel (97-2003) Data only format from Crystal Report Designer.

Symptom

Column width is truncated after exporting report to Excel (97-2003) Data only format.

Environment

  • Crystal Reports 2008 SP1
  • Crystal Report XI R2

Reproducing the Issue

  1. Launch the Crystal Report Application.
  2. Design a report. 
  3. Export the report using Excel (97-2003) Data only Format.

Cause

This is not a part of the current product functionality.

Resolution

Workaround

  1. Export the report using Excel (97-2003) data only format.
  2. Select "Constant column width (in points)".
  3. Change the number manually as per requirement. 
  4. Click on OK button.

An Enhancement Request has been raised for this issue and can be tracked with ADAPT Id: ADAPT00486957. The Enhancement Request will be reviewed in terms of future product development when considering possible new features in next major release.

Keywords

CR, resize, Auto fit. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Product Enhancement

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports XI R2