export excel: data is trunkated

[jel]

I'm trying to export a report to Excel, using this code:

ExportOptions exportOpts = oRpt.ExportOptions;
exportOpts.ExportFormatType = ExportFormatType.Excel ;
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
exportOpts.DestinationOptions = new DiskFileDestinationOptions();
// Set the disk file options.
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
((DiskFileDestinationOptions)  oRpt.ExportOptions.DestinationOptions ).DiskFileName = strFileName ;
oRpt.Export();

In the excel-sheet I end up with, all text-fields are truncated to fit the size of the field on the report-design. However, I want to export many long textfields, so I dont want them truncated...
Does anybody know which settings I overlooked?

 

[synapsevampire]

Are you sure that they're truncated, and not just properly sized to display the full contents?

If they are truncated, what size are these fields, and what version of CR and have you applied the service pack?

-k

 

[jel]

Version: Crystal Reports for Visual Studio .NET
And yes, I'm sure data is truncated.
I wanted to export rows of (about) 30 fields, to fit them on a page I had to make them very small. In Excel I only get the first 3 characters of textfields, so only the characters that would be displayed if you'd view the report. The thing is: I don't want to view the report, but export the data.