topic Re: ExcelXP - cellheight statement ignored in ODS and Base Reporting

ExcelXP - cellheight statement ignored

FrankE — Tue, 08 Feb 2011 22:09:29 GMT

Hi guys,

I'm creating a report with the ExcelXP tagset and it seems the cellheight statement is being ignored. In my example bellow I create 2 rows via the line statement, 1 with inline formatting to change the font and cell height and the other with no formatting at all. The issue is that "test line 2" does get the modified font but the modified cell height is not honored for some reason. Any help would be appreciated.

PS- I've also tried modifying the template with a proc template statement and I get the same thing... I can change font face, size, etc but cellheight won't change.

data test;
input @001 policy_number $10.
@011 name $10.;
cards;
1111111111Person1
2222222222Person2
3333333333Person3
;
run;

ods escapechar='^';
ods tagsets.ExcelXP path="c:\temp\" file="temp.xls";

proc report data=test nowindows;
column policy_number name;
define policy_number / order "Policy Number";
define name / "Name";

compute before policy_number;
line 'test line 1';
line "^S={font_face=Federation CELLHEIGHT=10pt} test line 2";
endcomp;
run;

ods _all_ close;

Re: ExcelXP - cellheight statement ignored

Cynthia_sas — Tue, 08 Feb 2011 23:30:59 GMT

Hi:
Look at the suboptions available in TAGSETS.EXCELXP for controlling row heights, specifically mentioned in these previous forum postings for a variety of different scenarios:
http://support.sas.com/forums/thread.jspa?messageID=37260醌
http://support.sas.com/forums/thread.jspa?messageID=42955Ɤ
http://support.sas.com/forums/thread.jspa?messageID=14286㟎

To reveal the documentation on suboptions, use this along with your other suboptions:
[pre]
ods tagsets.ExcelXP path="c:\temp\" file="temp.xls"
options(doc='Help');
[/pre]

cynthia

Re: ExcelXP - cellheight statement ignored

FrankE — Wed, 09 Feb 2011 14:23:56 GMT

Yep I saw those posts and from what I gather.. it just doesn't work?

Re: ExcelXP - cellheight statement ignored

Cynthia_sas — Wed, 09 Feb 2011 17:10:52 GMT

Not at all. I can make the row height adjust in Excel -- just not with the CELLHEIGHT style attribute. There are internal controls in the EXCELXP suboptions -- namely the ROW_HEIGHTS suboptions and the AUTOFIT_HEIGHTS suboption. You will have to experiment with them to see which will give you the results that you want.

Sometimes you have to use a style template change to impact the output from TAGSETS.EXCELXP, but if you find that ROW_HEIGHTS and AUTOFIT_HEIGHTS suboptions don't work for you, you might want to open a track with Tech Support.

cynthia