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     [CLOSED] AUTOFIT in EXL07
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] AUTOFIT in EXL07
 Login/Join
 
Platinum Member
posted
Is there a style sheet command to Auto fit the excel cells for width and row height in EXL07 format?

This message has been edited. Last edited by: FP Mod Chuck,


App Studio Version 8202
windows Platform
SQL Server 2008/2012
 
Posts: 172 | Location: TX | Registered: January 22, 2007Reply With QuoteReport This Post
Master
posted Hide Post
None that I know of. I do it with the following commands in an excel macro. For example, if my data starts in row 5 col 1:
  ws_last_row = Cells.SpecialCells(xlLastCell).Row
  ws_last_col = Cells.SpecialCells(xlLastCell).Column
  Range(Cells(5, 1), Cells(ws_last_row, ws_last_col)).Select
  Selection.WrapText = False
  Selection.Columns.AutoFit


I do all kinds of formatting using Auto_Open macros that can't be done in WebFOCUS or at least not easily.

This message has been edited. Last edited by: jgelona,


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 900 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
Member
posted Hide Post
To control the row height, this helps:

TYPE=REPORT, WRAP=OFF, $


WebFOCUS 8.2.01M
 
Posts: 9 | Location: Charlotte, NC | Registered: December 19, 2012Reply With QuoteReport This Post
Expert
posted Hide Post
Nice Thread Good info...
 
Posts: 2914 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] AUTOFIT in EXL07

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