Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

export table to excel -- copy from excel to excel gives background color issues

We have a chart table in qlikview which we export to excel.

This looks like the picture below -- color settings are exact like the QlikView chart table.

We used a chart style type: 'Light'.

excel -- export from QV.PNG

If a user copies data from this exported table to another excel file the table area gives a strange background we cannot explain:

excel -- export from QV -- 2.PNG

Does anyone know if there are settings for this and where this comes from?

rgrds,

Anita

2 Replies
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi Anita,

Didi the you advice the user to copy and paste special - past Values in Excel?

If you didn't can you advice user to do so?

Regards,

Gab

Anonymous
Not applicable
Author

Past special in Excel -- gives for most things (besides the csv and text) the wrong background color.

A user should just be able to copy and past things as their justed to in Excel.

What does QlikView do with saving the Excel -- it is something that is not visible in the front (couldn't find anything).

rgrds,

Anita