ods excel and backgroundrepeat

[xxformat_com]

Hi,

This morning I managed to have a background without duplicates but now the image repeats although backgroundrepeat is set to no_repeat.

I'm not sure what I changed that would lead to this unexpected result.

proc template; 
    define style styles.xxlogo;
    parent=styles.excel;
        class body / backgroundcolor =_undef_ 
                     backgroundimage ="&xxtraining./images/bear.png"
                     backgroundrepeat=no_repeat;
    end;
run;

ods excel file="&xxtraining./reporting/test.xlsx"
          style=styles.xxlogo
          options(start_at='2,2');

proc print data=sashelp.class;
run;

ods excel close;

[Ksharp]

No you can't . But you can make a white picture as big as enough and at north-west corner put your LOGO in .

Or @Cynthia_sas  know the solution.

[Cynthia_sas · Accepted solution]

Hi:
I am not sure about the BACKGROUNDREPEAT option and whether it works in ODS EXCEL. According to the documentation, https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsug/p1pt77toue3iyun0z4l9gth5as9f.htm -- the BACKGROUNDIMAGE option is supported by ODS EXCEL, but BACKGROUNDREPEAT is only supported by Markup destinations and PowerPoint destinations. So this may be a question for Tech Support.
Cynthia