This is a migrated thread and some comments may be shown as answers.

Error when Export Report to Excel

2 Answers 31 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Thuan
Top achievements
Rank 1
Thuan asked on 24 Oct 2017, 03:52 AM

I designed the my report on Telerik Reporting. When I export to Excel, something error appeared. Most of column is split as my picture. 

Someone help me to fix this error please ?

2 Answers, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 25 Oct 2017, 03:46 PM
Hello Thuan,

The most common cause of merged cells is improper or missing left/right alignment of report items. Make sure the left and right edges of all report items line up with one another. The alignment and applying the same width to report items will usually solve the problem. For more details please check Design Considerations for Excel Rendering help article (Merging Cells) section.

In the context of the provided screenshot, I would say that the Column that has number 2 in row "9" begins in column "I". Then the bold title above it begins in column "J", and the smaller title below the bold one begins in column "K". If you align those items left edges (and also if there are others below the table) in the report, when you export it to Excel they would probably all begin in column "I", and the current columns "I", "J" and "K" would be merged.

Regards,
Todor
Progress Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Thuan
Top achievements
Rank 1
answered on 11 Nov 2017, 02:47 AM

yeah ! thanks so much for your advice. I try to fix as you show me and it has been working correctly.

Regards !

Tags
General Discussions
Asked by
Thuan
Top achievements
Rank 1
Answers by
Todor
Telerik team
Thuan
Top achievements
Rank 1
Share this question
or