Cognos Analytics

Expand all | Collapse all

Any way to enable word-wrap in Excel output or somehow control column widths? (11.1 R6)

  • 1.  Any way to enable word-wrap in Excel output or somehow control column widths? (11.1 R6)

    Posted Thu June 25, 2020 08:13 AM
    Hi everyone, I've done a lot of Googling and searching in this forum, but I'm not able to find out how to change how Cognos exports to Excel format (not Excel Data). It seems that however long the longest data is in each column, that's how long the column will be in the Excel export. I've tried sizing the width of the column, data element, underlying table of the list, etc. to no avail. I have a feeling that there is no way to do this from the Cognos list report, but was hoping someone may know an easy(?) workaround to at least allow me to control the widths of columns when exporting to Excel.If anyone knows, please let me know, I would appreciate it greatly! :)  Thanks and regards, Melody

    ------------------------------
    MELODY ALBERTI
    ------------------------------


  • 2.  RE: Any way to enable word-wrap in Excel output or somehow control column widths? (11.1 R6)

    Posted Thu June 25, 2020 12:09 PM
    Hi Melody,
    Please have a look at the information here:

    // Henk

    ------------------------------
    HENK CAZEMIER
    ------------------------------