Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Wrapping text in excel list column headers

    Posted Fri October 18, 2019 04:43 PM
    Hi,

    We have a report with around 8-10 columns with long headers. Column headers are wrapping in html format  which is not happening in excel format ,  used size and overflow option , it is not working in excel. Any thoughts on this. Thanks in advance.




    ------------------------------
    SRAVANTHI G
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Wrapping text in excel list column headers

    Posted Mon October 21, 2019 09:23 AM
    @SRAVANTHI G - If possible, could you attach screenshots of what you are seeing and a copy of your report spec? You can also send it directly to me - denny.narezny@ca.ibm.com

    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 3.  RE: Wrapping text in excel list column headers

    Posted Fri November 08, 2019 09:28 AM
    have used autofit to make the titles fit into the columns, but the titles are taking up lots of space. There has to be a better way…oh, now wait…there is! I can wrap the text in the column headings, so the focus is on the contents in the cell, not on the width of the column.

    I select the entire row A1, and right click. I then select format cells, and click Wrap Text.

    Under Text alignment, select the Vertical text box and select Top.

    ------------------------------
    Barry Singha
    ------------------------------