Skip to main content
Newcomer
Jul 11, 2023 1:18 PM UTC

Cube View - Excel Column Headings

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.

ExcelLisaS_0-1689081403305.pngvs. pdf LisaS_1-1689081453915.png

 

 

    3 replies

    Newcomer
    Jul 11, 2023 3:19 PM UTC

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

    Member
    Jul 11, 2023 3:48 PM UTC

    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.