IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Is there a way to make AUTOFIT width in Exl2k ?
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  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: 12 | Registered: January 27, 2004Reply With QuoteEdit or Delete MessageReport 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 QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Is there a way to make AUTOFIT width in Exl2k ?

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