Multiple cells are merged into one column in exported Excel file

[former_member533461]

Hello, I have a report which exports MS Excel file. Although all the fields are same width and they are all aligned, multiple cells are merged into one column in the exported Excel. Also, there is no space between fields but this issue is not still solved. Would someone be able to give me adovice, please? Thank you!

[ido_millet · Accepted solution]

See: The Crystal Reports® Underground

[former_member533461 · Accepted solution]

Hi Ido. "Whole Report" was not selected under Report Export Options >> Column width based on objects in and now it works. Thank you so much for your help!

[Former Member]

Hi Christine,

Have you tried Vertical Guidelines for formatting.

Please refer to picture below.

-Mustafa

[former_member533461]

Hi Gulam. Actually, my report already had vetical guidelines but I was missing another setting but I found out those guidelines are really important. Thank you for the reply!