Export to excel

[prasadmokashi]

Hi,

When I export the report to Excel, the values in the report span over 2-3 columns or rows of excel whereas I expect it to occupy only one cell per value.

Is there any way of correcting this ?

Also is there any way of coloring the excel cells same as report ?

I am using v10 of CR and Office11.

Thanks,
Prasad

 

[lupins46]

Make sure you export using the excel 97-2000 Extended option. This gives better results than the other one.
Or just use the Data-Only option.

 

[prasadmokashi]

Thanks lupins46.

Using Excel 97 Extended option indeed gives better relsults.

Rgds,
Prasad