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

Document ID : KB000126316
Last Modified Date : 12/02/2019
Show Technical Document Details
Issue:
STEPS TO REPRODUCE



1. Create an Nsql query using the following;

SELECT @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:A123:A123@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:AAAA:AAAA@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:BBBB:BBBB@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:CCC:CCC@
FROM
(
Select
12345 as A123,
(2) as AAAA,
to_CHAR(-2) as BBBB,
-1 as CCC
From Dual
)SQL
where
@Filter@

2. Create a Grid portlet using the Query created in step 1 as the data provider and add all columns in the List Column layout section

3. Put the Portlet in a Tab on PPM => Home => Overview page and do an Export to Excel (Data Only)



EXPECTED:
Data gets exported to Excel and file opens up successfully


ACTUAL:
Excel file generated errors with message - 'This file cannot be opened because of errors'
 
Cause:
This is reported as Defect  DE46400
Resolution:
Resolved in Clarity 15.6

Workaround:
Do an 'Export to Excel' then save the output file again as a Comma delimited (CSV).
Additional Information:
This appears to be a duplicated of Defect DE46372
https://comm.support.ca.com/kb/export-to-excel-issue-after-upgrading-to-ppm-1551/kb000124231