Export to Excel generate extra (blanc) lines

[UnleashThePain]

Hi,

When I export a Crystal report (version 8.5.3.975) with CrystalDesk (version 9.0.6965) CrystalDesk creates 3 empty lines between each line with data. When I export to MS-Excel using the export function in Crystal Reports it will put the lines correctly without the blank lines.

Anyone an idea how to solve/workarround? Maybe knows the exact batch command to export and email properly?

Unleash

-----------------------------------------
>>>Fornicate Under Command of the King<<<

 

[Madawc]

It removes blank lines and you want them incleded in Excel?

If the blanks are spacing on the report, I'd expect Excel export to exclude them as part of its normal function.

If you can make them lines with blank fields rather than blank lines, it might recognise them as something that's supposed to be there.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10