topic Re: Copy from excel export changes color in QlikView

Copy from excel export changes color

bastorizzel — Fri, 07 Oct 2016 09:49:09 GMT

Hello,

when I export a table from an app which is on the qlikview server to excel and then copy the table or a part of this table to a new excel document the background color changes to this ugly cyan color.

When I export an excel from development this issue does'nt appear.

I guess this is a server setting or is it excel issue?

Thanks for your help,

Sebastian

Re: Copy from excel export changes color

divya_anand — Mon, 10 Oct 2016 11:43:43 GMT

Hi Sebastian,

This is not a Qlikview issue. I have not come across such a thing before. This might be your Excel issue, the green triangle on the cells indicate error in the formula, you might want to hover or click on the green triangle & check what the issue could be or maybe there is a predefined setting.

Re: Copy from excel export changes color

RobertTimm — Thu, 18 May 2017 21:47:11 GMT

Yes, I'm having the same issue. Currently looking for a solution, too.

Edit: You can try this: upon pasting, right-click and select Match Destination Formatting

Re: Copy from excel export changes color

c_gilbert — Fri, 19 May 2017 13:20:22 GMT

It also works for me when I choose 'Paste Special' then 'Values & Source Formatting'