When a multi line text object is placed in the page header and then the crystal report is exported to Excel Data only format we find square boxes in the exported excel file.
This issue is by design. If your OS system is window 2000, Office XP or Office 2003 will show carriage return as one square box. Because in platform before 2000, they can not decently deal the carriage return( \x0d \x0a), they will display chr(10) as a square box.
Use the following macro to modify the content of one cell, if you
want to apply it to the whole worksheet, you can easily change
This macro need to be run in the Excel file.
Dim rangeContent As String
Dim rangeInd As String
rangeInd = "A1"
rangeContent = Application.Range(rangeInd).Value
Application.Range(rangeInd).Value = Application.Substitute(rangeContent, vbCrLf, vbLf)
Range(rangeInd).WrapText = True
crystal reports , 8741788 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To