Something weird does happen when I use the ExcelXp tagset to display large tables. In fact, the weird thing is that it does not happen to behave like expected.
Il want to use the FIT_PAGEWIDTH option to resize automatically the output when printing, on a single page. The "printer setup" is correctly defined in Excel, but the radio button is not set, so any settings on page width or height are just ignored.
Am I wrong somewhere, or is there something missing there ?
Sample below :[pre]
DATA work.large ;
ARRAY columns (15) ;
DO i = 1 TO 100 ;
DO j= 1 TO DIM(columns) ;
ODS TAGSETS.EXCELXP FILE="c:\temp\large.xls" OPTIONS(PAGES_FITWIDTH="2") ;
PROC PRINT ;
ODS TAGSETS.EXCELXP CLOSE ;
Thanks in advance for any hint, help or suggestion.
I have never experimented with PAGES_FITWIDTH, but if you open a track with Tech Support, and this is a reproducible example; then the track will be handled by the folks who know how to fix the issue.