Hello,
I applied some background color to the grand total row for a flat report. But that background color is not getting carried over to the Excel report. Please suggest how to get around this. Also, how to set the font style and size in Excel.
Thanks
Sri
Hello Sri,
Thank you for reaching out to us.
If you are using the customizeCell method, it is not intended to work with the export. Since every cell's style can be unique when using the customizeCell - such a function would take a lot of time. Therefore, an export report with customized cells is impractical because it would last much longer.
However, you can set the background color for the total row and font styles via CSS. This way, the applied styles will be visible in the export. Please refer to the following JSFiddle for reference: https://jsfiddle.net/flexmonster/pnokaLh5/.
You are welcome to contact us if other questions arise.
Kind regards,
Nadia