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

Exporting to Excel - Formatting Issues

2 Answers 57 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Mark Holdt
Top achievements
Rank 1
Mark Holdt asked on 29 Dec 2009, 01:19 PM
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

2 Answers, 1 is accepted

Sort by
0
Accepted
Robert
Top achievements
Rank 1
answered on 29 Dec 2009, 04:23 PM
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
0
Steve
Telerik team
answered on 11 Jan 2012, 09:06 AM
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

Q3’11 of Telerik Reporting is available for download. Register for the What's New in Data Tools webinar to see what's new and get a chance to WIN A FREE LICENSE!

Tags
General Discussions
Asked by
Mark Holdt
Top achievements
Rank 1
Answers by
Robert
Top achievements
Rank 1
Steve
Telerik team
Share this question
or