Removing cell color from exports

[rtr13]

Hi All, 

Is there a way to remove cell color from exports (so the background is white) when you have a calculated background color being used for chart colors?

When I export my data, one of my columns contains the colors of my calculated background. Does qlikview provide a way to remove the colors from excel exports?

Thanks,

Rose 

[maxronny]

unfortunately i think there is no way to remove cell format when you export in an excel file.

only in print option you can remove the cell color format.

[Brett_Bleess]

I believe the other poster is correct on this one, but I am including Help link for you to have a direct look yourself to see if you want to play with anything to check on impact.  The only other thing of which I can think would be to have a button object and a copy of the chart without colors that is hidden that you could use to do the export as a workaround on this one.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/User_Preferences_Output....

Regards,
Brett