COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: hike22 on 02 Apr 2021 10:41:56 AM

Title: Report Output to Excel with No Wrap But fixed width columns
Post by: hike22 on 02 Apr 2021 10:41:56 AM
I want to be able to output to excel where there is no wrap in the data text, but the column width is fixed to a smaller size.  Essentially the rest of text in the cell will be hidden until a user manually adjusts it.  However no matter how I set the Size & Overflow settings in Properties, the column size always expands to fit the entire line of text.  Or it will merge multiple columns together in Excel to fit it all.

Any help is appreciated!

I am using IBM Cognos Analytics 11.0.13 (LTS).


Thanks!