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.
Export to Excel Data Only Output from the Report:
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)'
Then, in Microsoft Excel, go to the worksheet that contains the exported data, select all the data (highlight the data) and select 'Copy' function
Go to a blank worksheet within the same workbook, and select 'Paste Special' option to keep 'Values & Number Formatting'
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.