Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  EXCEL NOT WRAPPING LONG TITLES

    Posted Tue April 27, 2021 03:09 AM
    Hi guys, 

    Is there any way possible to have the EXCEL Format option to wrap the title of the columns especially those with headers more long than their content?
    I would like to have the same behaviour and estetic as in HTML but for Excel, no luck yet.

    i have attached the actual situation and the desired format output.

    Thanks

    ------------------------------
    Magnum BI
    ------------------------------

    #CognosAnalyticswithWatson

    Attachment(s)

    xlsx
    result format as of now.xlsx   4 KB 1 version
    xlsx
    result format desidered.xlsx   9 KB 1 version


  • 2.  RE: EXCEL NOT WRAPPING LONG TITLES

    Posted Wed April 28, 2021 09:28 AM
    Hi, I believe you need these 2 settings configured in both the BatchReportService and ReportService services:
    RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL: True
    RSVP.EXCEL.XLS2007_COLUMN_WIDTH_CONTROL: True

    Once these are done, you'll need to set the Size & overflow setting on each column that you want to size a specific width (any content in that field will word-wrap accordingly). Here's an example of what I have set on a specific column that can have a lot of text:


    Hope this helps! Regards, Melody

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

    Original Message


  • 3.  RE: EXCEL NOT WRAPPING LONG TITLES

    Posted Thu April 29, 2021 08:31 AM
    Hi Melody,you have been a great help !
    Thanks

    ------------------------------
    Magnum BI
    ------------------------------

    Original Message


Related Content