XLSX Export with no background color

[Aleksandar]

When exporting a report using the XLSX format, it always sets a white background and the gridlines aren't visible. I've set all the report, sections, and items to transparent background color. I've enabled "ShowGridlines" in runtime settings. When I export to XLS it works as expected with no background color. Therefore, I don't think it's an issue with the report itself. How can I export to XLSX with a transparent background to see the gridlines?

[Ivet]

Hi, Aleksandar,

Thank you for reaching out.

It is not possible to export to XLSX with a transparent background color by using Reporting. As a workaround, you can manipulate the XLSX document with the SpreadProcessing library:

1. Import - SpreadProcessing - Import and Export to Excel File Format Using XlsxFormatProvider - Telerik Document Processing
2. Customize the Fill and Border color of the cells - SpreadProcessing - Get, Set and Clear Cell Properties - Telerik Document Processing
3. Export - SpreadProcessing - Import and Export to Excel File Format Using XlsxFormatProvider - Telerik Document Processing

I have logged a bug report on the portal, and cast your vote for it so that you are subscribed to updates - It is possible to export to XLSX with a transparent background color. Also, as a reward for helping us improve the product, I have awarded you with 2000 Telerik points. 

I hope the above information will be useful. Let me know if you have other questions.

Regards,
Ivet
Progress Telerik