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.
input @001 policy_number $10.
@011 name $10.;
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.