Focal Point
EXL2K Column Header Orientation

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

August 11, 2008, 04:01 PM
ColdWhiteMilk
EXL2K Column Header Orientation
I'm looking to change the orientation of the column headers of my EXL2K spreadsheet output so that they are rotated 90 degrees to the left.

I can set this in EXL2K, but I was curious if there was a setting or stylesheet function that I coult set this.

I've tried searching on the forum for this, and the results all seem to apply to graphs, but not detail worksheets.

Any help would be appreciated.

Thank you.


Production - 7.6.4
Sandbox - 7.6.4
August 11, 2008, 04:10 PM
GinnyJakes
TABLE FILE CAR
SUM SALES AS 'S,A,L,E,S'
BY COUNTRY
ON TABLE SET ONLINE-FMT EXLEK
END

Is this what you want?


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
August 11, 2008, 04:18 PM
ColdWhiteMilk
That is really close.

I was trying to rotate the individual letters 90 degrees to the left in attition.


Production - 7.6.4
Sandbox - 7.6.4
August 11, 2008, 04:25 PM
GinnyJakes
I get it now. You want to rotate each indiviual letter so that it is laying on its side. I haven't a clue.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
August 11, 2008, 04:38 PM
ColdWhiteMilk
I don't know how to do it either. :-)

I'm just hoping that if it can be done in Excel, that I can get WebFOCUS to export it that way.


Production - 7.6.4
Sandbox - 7.6.4
August 11, 2008, 05:04 PM
GinnyJakes
Well, I did it in Excel. I went to Format Cells/Alignment and there is an Orientation property. So I rotated the text 90 degrees.

I have no idea how you would export that from WF unless you used a template. There are lots of posts on the Forum about using Excel templates.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
August 12, 2008, 02:25 AM
Tony A
CWM,

There was a discussion about this quite a while ago - late Dec 2005 (forum search on excel css), that gave an IB solution of using CSS with EXL2K output via an HTMLFORM using HTMLFORMTYPE=XLS (see link).

It may help you?

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10