TRUE/FALSE Values when downloading queries and exports to Excel

Options
Monique Scharlotte
Monique Scharlotte
Tenth Anniversary Photogenic Loyalty Badge Inquirer Level 1
in Blackbaud Raiser's Edge NXT®: General Discussion
I have set my user options to export YES/NO values instead of TRUE/FALSE values when downloading results from queries or exports to Excel, but in spite of that, I continue to get the TRUE/FALSE values.


Has anyone else experienced this, and if so, is there a fix to this?


Thanks.
Tagged:

Comments

  • Steven Cinquegrana 2
    Steven Cinquegrana 2
    Ninth Anniversary 500 Comments 250 Likes Name Dropper
    Hi Monique,


    I confirm the same behaviour. The solution I'd offer is to export to csv, which does honor the setting from what I can tell after a quick test. Then open the file in Excel - being careful as always that Excel doesn't "help you" by reformatting various columns!


    Cheers,

    Steve Cinquegrana | CEO and Principal Developer | Protégé Solutions

     

Categories