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!