Setting Column widths for excel in WF Stylesheet

Focal Point

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

August 02, 2007, 10:13 AM

linus

Setting Column widths for excel in WF Stylesheet

Is it possible to set the column width for excel ouput within the WF Stylesheet? I have searched the WF 5.2 manual, WF 7.0 manual and FocalPoint on how to do this and I can't find anything on setting column widths for excel within the WF Stylesheet.

WF 7.1.4, HP-UX

WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF

August 02, 2007, 10:27 AM

ypatel

what version of excel are you using ? - I believe formating don't work on excel97 and lower so column widths are adjusted automatically to field's format length(size).
excel2k supports formating.

-Yogesh Patel
------------------------------------------------------------------------
PROD: WF 764 on Linux Apache tomcat v5.5
DEV: WF 768 on Linux

August 02, 2007, 10:28 AM

linus

I'm using 7.1.4 -- I found what I needed -- it's the wrap command.

Thanks for your prompt reply.

WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF

August 02, 2007, 10:30 AM

Leah

I believe that WRAP and setting a numeric value for the SQUEEZE option on a COLUMN style will help. The information I found is in my printed versions of 5.2, (chapter 8) of WebFOCUS so I'm sure it is still valid.

Leah