topic Re: ODS POWERPOINT PROC REPORT cell padding in ODS and Base Reporting

ODS POWERPOINT PROC REPORT cell padding

data_null__ — Fri, 17 Sep 2021 19:37:13 GMT

I would like to reduce the space around the data in a cell, cell padding I think, in the header and column but I can't seem to do it.

This is the default appearance. I would like less space between the data and the cell border.

I can use padding options and the cell get smaller but padding appears unchanged.

ods powerpoint file="cellpadding.pptx";
proc report data=sashelp.class(obs=8) style(CALLDEF COLUMN HDR HEADER LINES REPORT SUMMARY)=[bordercolor=red];
   columns _all_;
   define _all_ / display;
   run;
proc report data=sashelp.class(obs=8)
      style(CALLDEF COLUMN HDR HEADER LINES REPORT SUMMARY)
         =[cellpadding=0pt bordercolor=red paddingleft=0pt paddingright=0pt paddingbottom=0pt paddingtop=0pt]
         ;
   columns _all_;
   define _all_ / display;
   run;

Re: ODS POWERPOINT PROC REPORT cell padding

ballardw — Fri, 17 Sep 2021 20:35:53 GMT

Did you see if the HTML or maybe a PDF or RTF version looks different? It may be something in the Powerpoint destination where MicroSoft is "protecting" you from removing too much space.

Re: ODS POWERPOINT PROC REPORT cell padding

data_null__ — Fri, 17 Sep 2021 21:11:39 GMT

@ballardw wrote:

Did you see if the HTML or maybe a PDF or RTF version looks different? It may be something in the Powerpoint destination where MicroSoft is "protecting" you from removing too much space.

This is default PDF.

This is PDF with CELLPADDING=0.

Re: ODS POWERPOINT PROC REPORT cell padding

ballardw — Fri, 17 Sep 2021 21:40:46 GMT

@data_null__ wrote:

@ballardw wrote:

Did you see if the HTML or maybe a PDF or RTF version looks different? It may be something in the Powerpoint destination where MicroSoft is "protecting" you from removing too much space.

This is default PDF.

This is PDF with CELLPADDING=0.

So it does seem that Powerpoint is limiting how close the values get to the cell borders. You might make a quick trial with CELLSPACING=0 for the Powerpoint and see if that makes a difference. I'm not on a machine with Powerpoint so can't actually test that.

Re: ODS POWERPOINT PROC REPORT cell padding

data_null__ — Tue, 28 Sep 2021 13:40:49 GMT

@data_null__ wrote:

I would like to reduce the space around the data in a cell, cell padding I think, in the header and column but I can't seem to do it.

This is the default appearance. I would like less space between the data and the cell border.

I can use padding options and the cell get smaller but padding appears unchanged.
ods powerpoint file="cellpadding.pptx";
proc report data=sashelp.class(obs=8) style(CALLDEF COLUMN HDR HEADER LINES REPORT SUMMARY)=[bordercolor=red];
   columns _all_;
   define _all_ / display;
   run;
proc report data=sashelp.class(obs=8)
      style(CALLDEF COLUMN HDR HEADER LINES REPORT SUMMARY)
         =[cellpadding=0pt bordercolor=red paddingleft=0pt paddingright=0pt paddingbottom=0pt paddingtop=0pt]
         ;
   columns _all_;
   define _all_ / display;
   run;

Bump.