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;
... View more