If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Solution to "Guarantee" Setting Column Width to Excel Report

Started by Cognos_Jan2017, 12 Feb 2018 02:20:13 PM

Previous topic - Next topic

Cognos_Jan2017

Saw this in Google search few months ago, and has "worked", but NOT all the
time ... especially when Column Entry is "long" (around 30 or more characters).

From Google search ...
1. Excel columns with inconsistent width:                           
                  
We could specify fixed column width using 'Size & Overflow' property to have a uniform look, but the moment we export to excel,  the fixed width applied in the report does not reflect in excel.                              
Columns may stretch or shrink inconsistently.                        
                                 
To avoid this behavior, do not use 'Size and Overflow' on column header or body, but use it on the data item inside the column body by unlocking the report.

Any known way of "guaranteeing" setting a "long entry" Column Width so any characters longer than the setting will expand the column entry by making a longer row height?

TIA, Bob