topic Sending to excel changes the format color in QlikView

Sending to excel changes the format color

Anonymous — Tue, 21 Dec 2010 13:30:59 GMT

We have the following similar problem at one of our customers. Customer is using QV Server 9. When he downloads a table to Excel (by pressing the Excel button in the caption of an object), the Excel file is opened. What happens is that somenumbers change colors (red instead of green and turn) with no reasonable explanation (already examined the matter ofrounding up / down and it's not the reason).

Has anyone experienced the same? How can we solve this?

Sending to excel changes the format color

Tue, 21 Dec 2010 13:42:19 GMT

Maybe it is the user setting "Adjust Excel Palette to Colors in Export" (User Settings / Export Tab)

Try unchecking it. Try uncheck on server and opr client.

Maybe that will solve the problem.

Sending to excel changes the format color

Anonymous — Tue, 21 Dec 2010 15:11:51 GMT

Thanks'

but it didn't solve the problem.

One more thing, it happens only in the total row..

Sending to excel changes the format color

Thu, 21 Apr 2011 16:34:33 GMT

Hi Eran Dayan,

I face same problem. You got any solution?

Regards

Ravi

Sending to excel changes the format color

Wed, 15 Feb 2012 20:58:30 GMT

bump

Sending to excel changes the format color

Anonymous — Thu, 16 Feb 2012 06:20:15 GMT

If you can update your qv with sample data and that export color issue.

I will try to get a solution for your problem

Regards

Ashok