Hi, before I burn any more brain cells on this one I thought I'd ask. I'm trying to perfect a spreadsheet format but can't seem to affect Row / Cell height at all. I was able to work around by showing Observations and making them a massive sized font, but that's too unprofessional looking.
This is the code I'm using for the moment. There's some junk in there.. remnants of different things I've tried. Autofit, row_heights, nothing seems to work. It seems like I can only properly use the Column settings with HTML too... am I mistaken?
proc import out = testing
define style XLsansPrinter;
parent = styles.sansPrinter;
style header_id from header /
font_weight = bold
background= light blue
just = c
vjust = top
style data_currency from data /
font_size = 11pt
just = c
style data_text from data /
font_size = 40pt
In answer to Alai, this is more of a microsoft problem, but we are stuck with making it work.
autofit doesn't work. - that is microsoft's problem. I keep trying anyway...
First I am wondering which version of the tagset you are using. Later versions of the tagset have greatly improved height calculations. I wouldn't be surprised if a newer version made
all of your problems go away.
The next thing is that you could use row_height_fudge, It's in points, and it is added to the height of each row after the calculations are done. You do not want autofit_height on, that will turn off any height specifications. Autofit_height would be great if Excel actually did what it should.
As it is, heights must be calculated and specified. The row_heights option can help also, but since you appear to want them all the same height, row_height_fudge may be what you need, although the heights will vary according to the font size and number of rows the text needs.