idea Re: Keep formatting on Excel Export in Suggest an Idea

Keep formatting on Excel Export

jheasley — Wed, 25 Nov 2020 15:38:50 GMT

When exporting a table or pivot table, the cell and value colors should be preserved. End users develop specifications for how to color these based on operational conditions, and often make selections based on these. The formatting is a critical part of the actionable insights.

Re: Keep formatting on Excel Export

millerhm — Fri, 08 May 2020 12:57:05 GMT

YES - this is a huge need for us - the lack of formatting in exports is an issue in almost every project we work on, combined with another request here for including titles and selections in the exports.

Re: Keep formatting on Excel Export

amarkrishnasamy — Sat, 20 Jun 2020 16:59:28 GMT

Guys,

I'm not sure if there is an update to this, but it's critical to keep formats when people export it to excel. We cannot expect users to download this and again redo color coding which is already done on the dashboard. We have various heatmaps that we generate and this defect kills the whole purpose.

Re: Keep formatting on Excel Export

awqvuserneo — Sun, 21 Jun 2020 01:12:27 GMT

Agreed!

Re: Keep formatting on Excel Export

Almen — Fri, 31 Jul 2020 10:13:19 GMT

Needed.

Re: Keep formatting on Excel Export

gsan — Tue, 22 Sep 2020 15:20:38 GMT

Yes, this functionality is needed.

Re: Keep formatting on Excel Export

mmet123 — Mon, 09 Nov 2020 17:37:02 GMT

Agreed! Additionally keeping the alignment and text wrapping formatting as well

Re: Keep formatting on Excel Export

jcad — Mon, 09 Nov 2020 18:04:48 GMT

Agree with all as this is much needed! Backing Mmet123 on the text alignment and wrapping formatting to keep when exported.

Re: Keep formatting on Excel Export

colombari-g — Thu, 12 Nov 2020 16:08:40 GMT

Needed absolutely

Re: Keep formatting on Excel Export

russell_angus — Tue, 17 Nov 2020 15:22:34 GMT

Completely agree. My client uses a dashboard for technical and legal compliance - red/green - and loses this critical information on export - please sort this out!

Re: Keep formatting on Excel Export

kozlovvv — Mon, 14 Dec 2020 15:36:33 GMT

Need!

Re: Keep formatting on Excel Export

HelloQlik — Mon, 14 Dec 2020 16:49:42 GMT

Waiting to see update on this much needed

Re: Keep formatting on Excel Export

Stanislav_P — Tue, 15 Dec 2020 18:33:18 GMT

Fully support this request. It's really hard to explain users why they can't extract data in the same view as they see it in the app.

Re: Keep formatting on Excel Export

jcad — Tue, 15 Dec 2020 19:35:45 GMT

Not having this type of feature is preventing my organization from wanting to move forward on certain types of reporting products that we've built and their desires to keep the formatting without manually changing anything is resorting to the old ways that we've built certain reports on APIs (not Qlik) that are past end of life cycles that do not enhance the reporting quality and always have tech issues with those applications- making this harder than it needs to be. I would really like for this to be possible so many will want to use Qlik Sense more with our applications as the go-to.

Re: Keep formatting on Excel Export

devan9876 — Wed, 06 Jan 2021 02:49:22 GMT

Yeah this one of the biggest gaps I have noticed between Qlikview and Qliksense. For better or worse, much of our business still lives and dies by Excel spreadsheets so being able to export with conditional formatting in tact is very important.

I would also ask that since In Qliksense there is a more of a push towards extension/widget development that background color and text color be made standard properties and/or have some sort of api that developers can use to customize the formatting of excel exports on extensions/widgets too rather than it being something only the native objects have the capability of doing.

Re: Keep formatting on Excel Export

jeanjordaan007 — Wed, 13 Jan 2021 23:53:25 GMT

Can I double like this one please.

Re: Keep formatting on Excel Export

matthias_v — Mon, 08 Mar 2021 10:09:28 GMT

Still one of the remaining missing (needed) functionalities compared to QV

Re: Keep formatting on Excel Export

Denis_LI — Thu, 25 Mar 2021 15:00:52 GMT

Has encountered that issue too and would be effectively great if this could be addressed.

Cross-tables are often used and loosing the colors is a hug drawback.

Re: Keep formatting on Excel Export - Status changed to: Open - On Roadmap

Andrew_Kruger — Fri, 09 Apr 2021 00:47:41 GMT

Improvements to the export of data according to the object formatting are being considered.

Re: Keep formatting on Excel Export

AG-gugelbisolutions — Tue, 13 Jul 2021 09:30:10 GMT

Absolutely a must have option!