Focal Point
Is there a way to make AUTOFIT width in Exl2k ?

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7011077331

January 27, 2004, 02:19 PM
jif26
Is there a way to make AUTOFIT width in Exl2k ?
Hi, is there a way to make AUTOFIT width in Exl2k without having to define the fields ? (much like SQUEEZE).
February 12, 2004, 05:38 PM
<monte2000>
Both SQUEEZE and WRAP will affect the cell presentation in HOLD FORMAT EXL2K.

1. Without any settings WebFOCUS will set the EXL2K column width to the maximum length of either column heading or data value, which ever is greater.

2. Setting WRAP=n, overrides the above behavior and sets the column to a particular length. Excell will then wrap the data to another line within the cell. WRAP can be set for specific columns or the entire spreadsheet.

ie.

ON TABLE SET STYLE *
TYPE=REPORT, WRAP=1,$

3. Setting SQUEEZE=n for a specific cell, gives the user the control over the maximum cell width. This setting is for individual cells, not the entire spreadsheet.

ie.

ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=N1, SQUEEZE=1,$