04-15-2016 03:08 PM
I am trying to make a group of proc report tables completely formatted using ODS Excel, rather than writing Excel Macros to edit the formats to make the tables printable. For the majority of my tables using the option "fittopage" works since they are one page tables. However I have two tables that span multiple pages in length and cannot figure out how to get the 13 columns to fit (in an Excel macro I can set the output to "fit all columns on page") then set where the page breaks need to happen. Is there a way to do this in ODS Excel?
04-15-2016 03:16 PM
Tagsets excelxp has the fit to page option, have you tried that with ODS EXCEL?
Some of the tagsets.excelxp options are valid in ODS EXCEL but not all. There's a page that has the exceptions but I can't find it
04-15-2016 03:20 PM
I use the fit to page for my single page tables. If I use it for the long tables it fits all the pages on a single page making the table unreadable because of the teeny-tiny shrinkage.
04-15-2016 03:50 PM
May I suggest that if the object is to create print output that RTF or PDF may be a better choice?
Though any output with sufficient rows or columns is not going to fit on a typical page.
04-17-2016 12:33 PM