Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
bastorizzel
Contributor II
Contributor II

Copy from excel export changes color

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?

cyan.PNG

Thanks for your help,

Sebastian

3 Replies
divya_anand
Creator III
Creator III

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.

RobertTimm
Contributor II
Contributor II

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

Pasting from Excel to Excel.png

c_gilbert
Creator II
Creator II

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

doc-copy-values-and-formatting-1.png