AnsweredAssumed Answered

Excel Add-In Special Characters

Question asked by DRG on Apr 11, 2018
Latest reply on May 7, 2018 by Michael Bulkeley

I have just downloaded the Excel Add-in and I'm following the instructions on the YouTube video CA Agile Central - Exporting Initiative to Task Hierarchy with Excel - YouTube .  The problem I am having is that when I download from Agile Central to Excel 2016, I have a lot of special formatting characters that appear as text in the columns and rows.  I see where this issue was reportedly fixed yet I'm having it now.

 

I did a search and replace using wildcards and replaced <*> and &*; with a space to remove all the special characters.  Now however, when I attempt to set up the merged queries, my data doesn't match when I link the "Feature" data from the User Stories to the "Name field in the Feature table.

 

What can be done to prevent these special characters from downloading into Excel from Agile Central?

Outcomes