Exporting Clarity v12 Report Output to Excel Data-Only Formatting

book

Article ID: 20045

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL 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>

Figure 1

Export to Excel Data Only Output from the Report:

<Please see attached file for image>

Figure 2

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>

Figure 3

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>

Figure 4

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>

Figure 5

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:

Attachments

1558717251975000020045_sktwi1f5rjvs16uhp.gif get_app
1558717250131000020045_sktwi1f5rjvs16uho.gif get_app
1558717248314000020045_sktwi1f5rjvs16uhn.gif get_app
1558717246218000020045_sktwi1f5rjvs16uhm.gif get_app
1558717244263000020045_sktwi1f5rjvs16uhl.gif get_app