In terms of the Export to Excel functionality, the following forum post may provide some insight:
In terms of the PDF, this is also expected behavior, as it is meant as a presentation tool, and thus will show whatever is in the direct view. This may be a good one put in the Ideas section of the Community!
Hope this helps a bit!
Thank you for the reply, in terms of the export to Excel, can you direct me to a list of style or format features that are supported when exporting to Excel. For example the colour of the text seems to transfer but the colour of the background does not. It would be helpful to understand the scope of what is supposed to be possible when exporting.