topic Re: ods excel and backgroundrepeat in ODS and Base Reporting

ods excel and backgroundrepeat

xxformat_com — Thu, 28 Oct 2021 11:27:55 GMT

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;

Re: ods excel and backgroundrepeat

Ksharp — Thu, 28 Oct 2021 12:19:06 GMT

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.

Re: ods excel and backgroundrepeat

Cynthia_sas — Thu, 28 Oct 2021 14:02:15 GMT

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