topic Re: drop special formatting when exporting to excel? in QlikView

drop special formatting when exporting to excel?

stevelord — Thu, 08 May 2014 20:33:51 GMT

Colleague of mine wanted to know if there's a way, from accesspoint, for him to set it so his exports from a qvw don't come with the background formatting/color scheme stuff. Something like what you'd get if you just copy/paste special/values onto a blank worksheet, but having it drop to that format automatically when you use the export to excel button.

I've been wondering a bit too- it would drop the file size a bit and make for speedier movement of larger data sets. I have the ability to kick the dashboard design back to utterly plain everything, but I think some kind of background stuff comes out with all qlikview exports anyway, and other people in the company specified the color scheme and such for this dashboard.

Thanks!

Re: drop special formatting when exporting to excel?

marcus_sommer — Fri, 09 May 2014 10:26:03 GMT

There are user-specific settings for export and print - see in Menu --> User Settings --> Export/Print (with IE Plugin - I could imagine AJAX is similar).

- Marcus

Re: drop special formatting when exporting to excel?

stevelord — Fri, 09 May 2014 13:53:34 GMT

Thanks, any options for FireFox? Sorry I didn't say the browser up front. (And I'll flip to correct after I verify IE result. Company has IE blocked until they're sure everyone has the security update in place.)

(I see in tools content advanced how to change what is displayed, but the exports still come out with qlikview settings.)