Problems when exporting to Excel

[Touzi]

I have problems when exporting report to Excel:
-  I would like to know why I get ​extra cells at a line when exporting to excel.
-  The colors are not the same (color blue turned into gray).

 

[Fridli Jacober]

Hi Touzi

-  I would like to know why I get ​extra cells at a line when exporting to excel.

You're using text boxes with MultiLine=true or you have spaces between text boxes (also see http://www.telerik.com/forums/problem-with-line-breaks-multiline-textbox-in-excel-export)

-  The colors are not the same (color blue turned into gray).

Do you have a recent reporting version?​
I also noticed similar when exporting to excel 97-2003 but I'm not sure if this still applies...

[Stef]

Hello,

Please check the Design Considerations for Excel Rendering help article. It elaborates on the possible reasons for cells merging and the specific limitations of Excel.


I hope this information is helpful.

Regards,
Stef
Telerik

[Touzi]

Hello,

Thank you for your reply.
We tried to apply the ​best practices that you have recommended but the problems still appears.
You will find two pictures attached to this message, for ​better understanding.

 

Regards,

Jihed

[Stef]

Hi Jihed,

Please test to align all items vertically. You can also use a Table item to organize the TextBox items.
About colors, please check the Design Considerations for Excel Rendering help article ( Excel 97-2003 and Excel 2007 and above).

The old Excel format supports 56 colors palette, where the new Excel format supports up to 16 million colors.

Regards,
Stef
Telerik