topic Re: VA 7.5 : Export to Excel with color coding in SAS Visual Analytics

VA 7.5 : Export to Excel with color coding

CHUNantes — Wed, 17 Feb 2021 09:25:17 GMT

Hello.

We are using SAS VA 7.5 and some of our users want to export data from a table :

But when they open the Excel file, all the color coding is gone :

Is it possible to keep this feature in Excel ?

Thanks.

Re: VA 7.5 : Export to Excel with color coding

Madelyn_SAS — Wed, 17 Feb 2021 14:29:09 GMT

Conditional highlighting from display rules is not preserved when exporting.

Re: VA 7.5 : Export to Excel with color coding

CHUNantes — Thu, 18 Feb 2021 10:10:58 GMT

OK, thanks.

Do you know if VA 8.5 have the same behaviour ?

Re: VA 7.5 : Export to Excel with color coding

Madelyn_SAS — Thu, 18 Feb 2021 14:29:50 GMT

The current release works the same way. The color coding is a client-side feature only. You can enter this suggestion in the SASware ballot so that others can vote on it, and product management can consider it for a future release.

https://communities.sas.com/t5/SASware-Ballot-Ideas/idb-p/sas_ideas