Excel files created via CA PPM show special characters

Document ID : KB000024472
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

On list view of the project object, the function 'Export to Excel' was used to create a Microsoft® Excel file.

When the exported file was opened, you can see special characters in some cells which look like carriage return.

Solution:

The CA PPM application is designed for the global market; thus, the application supports a character set more than just the ASCII character set. In order to resolve this display issue in Microsoft Windows®, you will have to install the East Asian Languages.

  1. Go to Control Panel on your local, personal computer 
  2. Double click on Regional and Language Options
  3. Choose the Languages tab
  4. Put a check on 'Install files for East Asian languages'
  5. This will require that you reboot your workstation for the changes to take effect 
  6. Open the Excel file