Excel tagsets creating rouge cell with different background color

[ScottBass]

SAS 9.3 (TS1M2)

Excel 2007 32-bit

Hi,

When I run the below code, I get a rouge cell at the end of the data (A21) which has a background color of gray instead of white.  This is problematic when the worksheet is printed. 

Do you get the same results?  If so, any idea how to get SAS to play nicely?

Thanks,

Scott

ods _all_ close;

ods noresults;

ods noproctitle;

ods tagsets.excelxp

  file="c:\temp\temp.xml"

  style=statistical

  options(

sheet_interval='none'

frozen_headers='yes'

autofilter='all'

  );

ods tagsets.excelxp

  options(

sheet_name='Class'

  );

proc print data=sashelp.class noobs label

  style(header)={

just=left

font_face="Marriott Light"

font_size=11pt

bordertopwidth=1

borderbottomwidth=1

borderleftwidth=1

borderrightwidth=1

  }

  style(data)={

font_size=10pt

font_face="Marriott Light"

bordertopwidth=1

borderbottomwidth=1

borderleftwidth=1

borderrightwidth=1

  }

  split='*'

  ;

run;

ods _all_ close;

ods listing;

[ballardw]

Yes, same behavior. Also using 9.3 TS1M2

But if I use Style=Journal it isn't there.

[Cynthia_sas]

Hi:

  This seems to be an issue using style=statistical. Not sure why. That would be a question for Tech Support. But with almost any other style, the cell at the end of the data is not colored (in my 9.4 test, using Office 2013, the colored cell was light gray).

cynthia