Hi,
I am going a bit crazy trying to accomplish the following formatting for Excel exports:
1. set row (or cell) height
2. set column width
3. set row (or cell) backcolor and forecolor
4. If using ExcelML, removing the dropdowns from the header row.
5. If using ExcelFormat-html, setting font size (and color).
It seems like there should be a way to do this. I have tried:
1. Using ExcelML format and setting styles in the ExcelML style events - I can get the backcolor/forecolor changed, but not width or height.
2. Using ExcelFormat=html and trying to set the attributes in the radgrid columns as well as in the ExcelExportCellFormattingEvent.
If I'm missing something or if there is a guide to formatting, please let me know!
I am running into similar problems with PDF export as well. In fact, I can't seem to get any kind of color styling in PDF.
Thanks much,
Michael
I am going a bit crazy trying to accomplish the following formatting for Excel exports:
1. set row (or cell) height
2. set column width
3. set row (or cell) backcolor and forecolor
4. If using ExcelML, removing the dropdowns from the header row.
5. If using ExcelFormat-html, setting font size (and color).
It seems like there should be a way to do this. I have tried:
1. Using ExcelML format and setting styles in the ExcelML style events - I can get the backcolor/forecolor changed, but not width or height.
2. Using ExcelFormat=html and trying to set the attributes in the radgrid columns as well as in the ExcelExportCellFormattingEvent.
If I'm missing something or if there is a guide to formatting, please let me know!
I am running into similar problems with PDF export as well. In fact, I can't seem to get any kind of color styling in PDF.
Thanks much,
Michael