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
EDIT: Available from 8.2!
This is unfortunately a common issue. You might want to upvote (kudo) this IdeaStream post:
See also:
https://community.onestreamsoftware.com/t5/Reporting/Cube-View-Excel-Column-Headings/td-p/21819
Actually that sort of behaviour would also be great for the direct cubeview representation, e.g. in a dashboard, not only the export.
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.
