Hello all,
I am using: org.apache.poi.hssf.usermodel.HSSFWorkbook I use an existing excel.xls (2003) as a template. The only print settings in the template is orientation of landscape In my code I create a variable printSetup = worksheet. getPrintSetup() then set the paper size. printSetup.setPaperSize(PrintSetup.LETTER_PAPERSIZE) When I look at theExcel spreadsheet created with all the data, it is a bit too wide for the print set up. When I use the Excel interface to change print settings, things get wild. I attempt to set the fit to 1 page wide, and Excel scales the document down to about 30% and only uses about half the available page width. If I try to set the page width using: printSetup.setFitWidth(1), it appears to have no affect. Are the some other settings that I need to apply to the worksheet or to the printSetup, to avoid this behavior inside Excel??
