Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Is there a way to make AUTOFIT width in Exl2k ?
Go
New
Search
Notify
Tools
Reply
  
Is there a way to make AUTOFIT width in Exl2k ?
 Login/Join
 
Member
posted
Hi, is there a way to make AUTOFIT width in Exl2k without having to define the fields ? (much like SQUEEZE).
 
Posts: 21 | Registered: January 27, 2004Reply With QuoteReport This Post
<monte2000>
posted
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,$
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Is there a way to make AUTOFIT width in Exl2k ?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.