Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR10 Line feed in text formula won't export to excel properly 1

Status
Not open for further replies.

deb13

Technical User
Nov 20, 2003
49
GB
I have a report with a summary paragraph which includes chr(13) and chr(10) for presentation purposes.

When I export to excel, the carriage return and line feed doesn't come through - I get a little box symbol in place.

If anyone can resolve this please let me know.

Thanks

Deb
 
It doesn't work deb because Crystal does not export to Excel in line by line method - but in objects.

This is fixed in Crystal XI - but as a workaround instead of using Chr(13) - I pad it out with extra empty text boxes.

Cheers
paulmarr
 
thanks Paul - that's a good idea - I'll do that.

Deb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top