Bug 48707

HSSFPrintSetup/XSSFPrintSetup setPaperSize method does not allow to set custom width and custom height of paper used for printing ...

Here is my scenario...

HSSFSheet hssfSheet = hssfWorkBook.getSheetAt(0);
HSSFPrintSetup hssfPS = hssfSheet.getPrintSetup();

hssfPS.setFitWidth((short)1);
hssfPS.setFitHeight((short)999);
hssfSheet.setFitToPage(true);


here I want to set the custom paper size, as setPaperSize only gives few option for paper size so it is not feasible due to that limitation. I want to set the custom paper size according to the maximum physical number of cells in excel sheet so that the data in my sheet should not shrink when I made its actual printout or PDF.... (i.e. set width to 17 inches when max physical columns in sheet are more than 10 and set width of page to 20 inches when max physical columns are greater than 15 etc...)