Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
rtr13
Contributor III
Contributor III

Removing cell color from exports

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 

Labels (2)
2 Replies
maxronny
Contributor III
Contributor III

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
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.