Exporting to Excel - Formatting Issues

[Mark Holdt]

Dear Telerik Team

I am setting a custom background color (e.g. R:15, G:55, B: 147) for textboxes and some table rows. This look fine when rendering the reports within Reportviewer, however, once I export them to Excel they suddenly get slightly different colors (e.g the custom colors get 0, 0, 128 in Excel)

I have tried formatting this within the Report Designer and setting the Background colors programmatically, however, they change each time.

is there a solution to this problem.

Thank you
Mark

[Robert]

Hi Mark,

In reading through the documentation for Telerik Reporting, I ran across the following in the "Design Considerations for Excel Rendering" topic. Under the styling section it says:

"For compatibility, the Rendering Extension supports a predefined set of around 75 colors that can be used for Background and Foreground colors of report items. The report item’s colors are translated to the closest possible color from the predefined palette."

Do you think this is what you may be experiencing?

- Robert

[Steve]

Hi Mark,

This is just a follow up to let you know that in 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 excel format.

All the best,
Steve
the Telerik team