Cube View - Excel Column Headings

[LisaS]

Is there a way to have nested column headings centered and merged when exporting a cube view to excel? I have nested columns and want the top column header to be centered and merged over the bottom columns. It does this automatically for a pdf export but the excel export repeats the top header for each column.

Excelvs. pdf 

[Federmann]

Actually that sort of behaviour would also be great for the direct cubeview representation, e.g. in a dashboard, not only the export.

[JamesKirkby]

Could you use conditional formatting to make the Excel text blue in the first and last column, while white in the middle with Excel wrap text false? I don't think there is a way to do this using header format default settings. the border settings might need a slight adjustment as well.

[JackLacava · Accepted solution]

EDIT: Available from 8.2!

This is unfortunately a common issue. You might want to upvote (kudo) this IdeaStream post:

https://community.onestreamsoftware.com/t5/Productivity/Ability-to-Merge-and-Center-Headings-across-...

See also:

https://community.onestreamsoftware.com/t5/Reporting/Cube-View-Excel-Column-Headings/td-p/21819

 https://community.onestreamsoftware.com/t5/Platform/Option-to-center-CubeViewData-Explorer-Column-He...