Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Customizable Format Options for Excel Exports in QlikView

marcus_sommer

Customizable Format Options for Excel Exports in QlikView

The last SR for QlikView - see: QlikView 12.50 SR4 is now available! - Page 2 - Qlik Community - 1783889 - changed again the formatting settings for Excel exports. Yes, it's known that there could be various errors by the export depending on the scenario in which it's used.

Avoiding any issues with it by setting everything to text is IMO not really a solution else I suggest to implement granular customizable settings at least at document level but better on a dimension/expression level - maybe additionally to the settings within the tab Numbers.

Further a detailed documentation not only to the settings itself else also about the technically background and potentially conflicts in regard to the Excel releases, used platforms, regional settings and so on would be very useful - because a valid problem-solution might not only be approached from the Qlik side else also from the target-environment.

Many thanks!

- Marcus  

4 Comments
KHSDM
Creator III
Creator III

Agreed. At least give an option that allow us to choose whether export as per default behavior or the mixed format. Ideal solution would be WYSIWYG during export, so the exported result would be same as whatever displayed in QV. (but maybe difficult to implement)

Meghann_MacDonald

There is an additional request for this feature in pivot table snapshots here: https://community.qlik.com/t5/Suggest-an-Idea/Improved-header-font-size-when-outputting-a-snapshot-o...

to add in support of the idea above.

Meghann

Meghann_MacDonald

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived