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

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

STEPS TO REPRODUCE



1. Create an Nsql query using the following;

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

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

Environment

Release:
Component: ODSTU

Resolution

Resolved in Clarity 15.6 and  back ported to 15.5.1 (Patch 1) 15.5.1.1

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