Clarity PPM: Export to Excel issue after Upgrading to PPM 15.5.1

Document ID : KB000124231
Last Modified Date : 18/02/2019
Show Technical Document Details

Export to Excel (Data Only) does not work when the results include negative numbers. The file throws an error and is unable to be opened.

Exporting the same results to CSV will export the data and the even though the file opens, the negative number unexpectedly contains an apostrophe, e.g. '-25. 

Steps to Reproduce: 
1. For simplicity, create a custom number attribute on the Team object (issue is reproducible with out of the box attributes as well) 
2. Go to the Team tab of an existing project and add the custom number attribute to the Team list view 
3. Type in a negative amount for this custom field on the list view, Example: -25 
4. Click on Save 
3. Click on Options - Export to Excel (Data Only) 
4. Open the downloaded file 

Expected Results: The file opens in Excel 
Actual Results: The file does not open and throws one of the following two errors: 
       "The file is corrupt and cannot be opened." OR "Problems During Load, Problems came up in the following areas during the load: Table" 
Reviewing the xls in Notepad, the -25 is being exported in an unregnizable format: 
<Data ss:Type="Number">&apos;-25</Data> 
Where it should be exported as: 
<Data ss:Type="Number">-25</Data> 

Caused by DE46372
DE46372 is resolved in 15.5.1 Patch 1, ( and 15.6.
Additional Information:
KB000126316: Export to Excel (Data Only) from a portlet where a column includes negative numeric number causes Export fails