Color in Export to Excel in Telerik Report

[Ban]

Hi,
I have a problem in Exporting my Telerik Report to Excel, I have a color of a TextBox should change depend on a binding field, I use the 'ItemDataBound'  event to change the color of the textbox and its work correct BUT when I export my report to PDF the color appear corect the same color I assign to but when I export to Excel the color look different !!!, I use the below syntax to assign the color to the TextBox Style:

CO = (System.Drawing.

Color)ColorTranslator.FromHtml("#a17e9a");

 

 

txtEvent.Style.BackgroundColor = CO;

 

Please help me to find what is the error and why in PDF work right and in Excel not.

Thanks

[Peter]

Hello Ban,

We have already answered your question in the other support thread you have opened. To read it you have to go to your account page and navigate to your support threads.

Best wishes,
Peter
the Telerik team

[Chris]

Hi,

I am looking for the response to this post but I can't find it.  I too am experiencing issues with the colors being changed when exporting, but I'm exporting to PDF.

Is there a solution to the change in color that is happening on export?

Thanks,
Chris

[Peter]

Hello Chris,

The Excel Rendering Extension for compatibility supports a predefined set of 56 colors that can be used for Background and Foreground colors of report items. The report items' colors are translated to the closest possible color from the predefined palette.

For more information about the Excel rendering extension, please take a look at the Design Considerations for Excel Rendering help article. The exact colors are listed in the following article http://www.mvps.org/dmcritchie/excel/colors.htm

Kind regards,
Peter
the Telerik team

[Dominik]

I am also having issues with the colors when exporting to excel. In this behaviour expected to change in any future release? Keeping the exact color information is very important for our customers.

[Steve]

Hi Dominik,

The Excel Rendering Extension of Telerik Reporting produces Excel files in the Binary Interchange File Format (BIFF, v. 8) which guarantees that exported files can be opened by Microsoft Excel 97 or later. Thus the Excel Rendering Extension has all limitations inherent to BIFF v. 8 and the supported color palette is one of them. This behavior can change if we migrate the export to Excel to a later Excel format that supports more colors, however such transition is not in our short term plans.

Sorry for the inconvenience.

Best wishes,
Steve
the Telerik team

[Dominik]

This is a very disappointing drawback. If there are no timelines as to when do you expect to have this feature updated we will be forced to look for another solution to satisfy our customer requirements.

[Steve]

Hi Dominik,

There is no time frame for such task as the interest has been very low so far - you are only the third user that has requested it. Currently there are other pressing features missing in the product that are highly demanded by users and we're putting all our efforts towards these.

Sorry for the inconvenience once again and thank you for the understanding.

Greetings,
Steve
the Telerik team

[Steve]

Hi guys,

This is just a follow up to let you know that since Q1 2011 we've introduced new export formats based on Office Open XML and one of them is XLSX which does not have the limitation to the color palette as the old BIFF format.

Kind regards,
Steve
the Telerik team