Hello, I need to print my spreadsheer with given number of rows per page, but since my rows are wide, I also need to fit the spreadsheet into the width of one page. In my code I call
sheet.setAutobreaks(false); sheet.getPrintSetup().setFitWidth((short)1); If I want to have 10 rows per page in a worksheet with 17 rows, I call setRowBreak(10). However, I still end-up with four pages because worksheet width doesn't fit into one page and calling setFidWidth(1) seems to have no effect. I am able to get desired result just by calling setScale(), but I have to calculate or guess the value of scale. Is it possible to get this done without using scale ? Thank for help Alex --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
