ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Export to Excel error if negative numbers are included in 15.5.1

book

Article ID: 124231

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

After upgrading to 15.5.1, 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. Errors you may see:

"The file is corrupt and cannot be opened." OR "Problems During Load, Problems came up in the following areas during the load: Table

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 unrecognizable format: 
<Data ss:Type="Number">&apos;-25</Data> 
Where it should be exported as: 
<Data ss:Type="Number">-25</Data> 

Cause

Caused by DE46372

Environment

Release: 15.5.1
Component: Clarity Export to Excel

Resolution

DE46372 is resolved in 15.5.1 Patch 1, (15.5.1.1) and 15.6.
 

Additional Information

Export to Excel (Data Only) from a portlet where a column includes negative numeric number causes Export fails