Exporting Clarity v12 Report Output to Excel Data-Only Formatting

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Description:

In Clarity v12, we execute the Budget Forecast Analysis Report and when we select the action to export the report data into Microsoft Excel, data only the formatting is not correct for the header.

Report Output:

<Please see attached file for image>

Export to Excel Data Only Output from the Report:

<Please see attached file for image>

Solution:

This is due to the use of Export to Excel Data Only versus the use of Export to Excel with formatting.

To ensure that your Microsoft Excel output is formatted properly, be sure to use the following steps.

Within the Report, Export, for the File Format, select 'Microsoft Excel (97-2003)'

<Please see attached file for image>

Then, in Microsoft Excel, go to the worksheet that contains the exported data, select all the data (highlight the data) and select 'Copy' function

<Please see attached file for image>

Go to a blank worksheet within the same workbook, and select 'Paste Special' option to keep 'Values & Number Formatting'

<Please see attached file for image>

The pasted data will be similar to the data using the Export Data Only option, but without the alignment issues.

Keywords: CLARITYKB, CLRT-66758, nab, how-to.

Environment

Release: ESPCLA99000-12.1-Clarity-Extended Support Plus
Component: