ODS POWERPOINT PROC REPORT cell padding

[data_null__]

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;

[ballardw]

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.

[data_null__]

---

@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.  

[ballardw]

---

@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.

[data_null__]

---

@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.