Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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 ?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Is there a way to make AUTOFIT width in Exl2k ?
 Login/Join
 
jif26
Member
posted
Hi, is there a way to make AUTOFIT width in Exl2k without having to define the fields ? (much like SQUEEZE).
 
Posts: 23 | Registered: January 27, 2004Report 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,$
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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-2020 Information Builders