Copy to Clipboard & Paste Losing Borders for Pivot Chart

[#1]

The reason I'm using Copy Paste is that I have several objects being picked up and copied to the same Excel tab, I can't seem able to retain the borders.

This is the same if you do it manually by right clicking and selecting Copy to Clipboard.

Does anyone have a solution to retain the format?

[kji]

On the User Preferences Export tab there is a setting for "Include Caption and Border" when copying to Clipboard.

[#3]

These are all ticked, any other ideas

[amien]

any solution for this? i have the same issue, and i don't want to work with macros

[Anonymous]

Hi

     Hope this will help you to achieve your result

     Settings ---> User Preferences --->Export ---> Select Full Table from Table Copy Format and mark check in

Send to Excel Options --> Adjust Excel Palatte to Colors in Export (option).

Doubt mease refer the attached  image file

Regards

Ashok

[amien]

Thanks for your reply

but does this also work in a server? cause i need it on server level. and i think those user settings will not apply as a document setting?

[Anonymous]

Hi

     I am not sure this will work in server because i tested this in qlikview personal edition

     FIrst you can try this , suppose is not work with in server means you can manually write the macro to add the

border for widget in excel sheet level

Regards

Ashok