Hi,
Is there a easy way to export the styles I have applied to CellValuePresenter to Excel?
I have applied quite a lot of conditional style to different cells, including font bold, font color, cell backgroud color, and tooltip. It would be great to have a generic way to handle this exporting logic.
Regards,
Jason
Hello,
I suggest you see the sample from the Feature Browser under xamDataGrid / Excel Exporter / Custom Cell Styling section where it is shown how to set the colors in the excel sheet and you are right that there is no Background, but the FillPatternBackgroundColor should do the trick.
Hope this helps you.
Hi Stefan, thanks for your reply. That doesn't work for me because I have to apply style based on certain condition to a cell, but not the whole field.
Now I am trying to do my logic in OnCellExporting event, but I am having problem to set the cell background color there. How can a set the cell background in this event? There is FillPatternBackgroundColor but no Background property.
Hello Jason,
Thank you for your post. I have been looking into it and I suggest you see this forum thread:
http://blogs.infragistics.com/forums/t/31555.aspx
where a similar issue like yours is discussed. Please let me know if this helps you or you need further assistance on this matter.
Looking forward for your reply.