Hello,

I cannot squeeze the column width to exact 11. When I try squeeze the column for width 11 either it is increase or decrease. I appreciate any one have suggestion how to get exact column width for 11 and 13.

-*this below code produce the column width 11.14 not exactly 11. 
TYPE=REPORT,
     COLUMN=N19,
     SQUEEZE=0.847222,
$


-*this below code produce the column width 13.14 not exactly 13. 
TYPE=REPORT,
     COLUMN=N25,
     SQUEEZE=0.986111,
$
  

Output in XLSX format



Thank you,
V_Ani

This message has been edited. Last edited by: FP Mod Chuck,

Looks like Excel is proportioning the cell width based on the cell contents data and font size.

You can influence this a bit but once Excel takes over, you're going to get an approximation of the width as it 'helps' you present your data.

  TABLE FILE CAR
SUM

COMPUTE COUNTRY_11/A10 = COUNTRY;
COMPUTE CAR_13/A24 = MODEL;

BY  COUNTRY NOPRINT
BY  MODEL  NOPRINT

ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET STYLE *
TYPE=REPORT,SQUEEZE=ON,SIZE=6,$
TYPE=REPORT,
     COLUMN=N1,
	 WRAP=11,
$


TYPE=REPORT,
     COLUMN=N2,
	 WRAP=13
$
ENDSTYLE
END

Good call Don... KISS Keeping It Simple!