asked on October 29, 2025
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
⋅ October 30, 2025
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
⋅ November 6, 2025
Hello Sri,
Hope you are having a great week.
We were wondering if you had a chance to check the suggested approach for Excel formatting. Could you please confirm if it works for you?
Looking forward to hearing your feedback.
Kind regards,
Nadia
⋅ November 6, 2025
Hello Nadia,
I was able to apply background color to the flat report grand total cells and also add a Grand Total word in the first cell. But I was not able to apply a background color to the cell with the Grand Total word. Is there a way I can identify that full row via id or class, like we do .fm-header etc. ?
Thanks
Sri
⋅ November 7, 2025
Hello Sri,
Thank you for the response.
We are glad to hear that you successfully applied background color and added a Grand total label.
Currently, adding a background color to cells without a total value via CSS is not supported, as empty cells do not have any HTML classes indicating a total row. This can only be achieved using the customizeCell function. However, these changes will only be shown in Flexmonster, not in the exported file.
Please let us know if other questions arise.
Kind regards,
Nadia
