1219431 - Carriage return symbol is inserted in the generated spreadsheet when exporting a report to Excel (data-only) from Crystal Reports

• Carriage return symbol appear in the excel file.
• When exporting a multi-line text object to 'Microsoft Excel (Data-only)' format, the exported file has one line with a carriage return symbol instead of line breaks.

• SAP Crystal Reports 2020
• SAP Crystal Reports 2025

• Add the registry key: WrapTextInDataOnly, and set the value to: True
  
  WARNING The following resolution involves editing the Microsoft Registry. Using the Microsoft Registry Editor incorrectly can cause serious problems. Use the Microsoft Registry Editor at your own risk. For more information see the SAP Knowledge Base Article 1323322 
    
  
  1. Open the Microsoft Registry Editor.
     (In Microsoft Windows, under the menu Start, select Run, and type: regedit) 
         
  2. In the Microsoft Registry Editor, navigate to the path
     
     HKEY_LOCAL_MACHINE\Software\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Export\Excel
     
     
  3. Add the registry key: WrapTextInDataOnly
     
     
  4. Set the value to: True

CR, export, xlxs , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

SAP Crystal Reports 2020 ; SAP Crystal Reports 2025