Keep formatting on Excel Export

Skip to first unread message

Q&A Bot

Sep 10, 2021, 6:21:15 AM9/10/21

Q:  When exporting a table or pivot table, the cell and value colors should be preserved. Is that possible?

Yes, it is possible to have the same colors formatting in a report web view, PDF and Excel exports.
To achieve that you need to use in the Expression-type dimension (or measure) these functions for colors formatting (instead of Html.Raw):
  • Html.SetTextColor to set the color of the text (applied to cell's tag TH/TD).
  • Html.SetBackgroundColor to set background color of the text (applied to cell's tag TH/TD).

Reply all
Reply to author
0 new messages