Focal Point
EXL2K Column Header Orientation
August 11, 2008, 04:01 PM
ColdWhiteMilkEXL2K 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
GinnyJakesTABLE 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
ColdWhiteMilkThat 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
GinnyJakesI 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
ColdWhiteMilkI 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
GinnyJakesWell, 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 ACWM,
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 | |