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.

Exporting Clarity v12 Report Output to Excel Data-Only Formatting


Article ID: 20045


Updated On:


Clarity PPM SaaS Clarity PPM On Premise



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


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.


Release: ESPCLA99000-12.1-Clarity-Extended Support Plus


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