Hello Stefan, I ran into a similar issue where I was crunching a lot of data into fitting to a page. One thing I found, by basically seeing how many rows there are per page, is to divide by the number of rows. So, as an example, a regular landscape page ( by stating setLandscape(true) ) has about 27 rows. So I wrote the following:
short numberOfPagesDataSpans = totalNumberOfRowsInDocument / 27; ps.setFitHeight( numberOfPagesDataSpans ); ps.setFitWidth((short) 1); So basically, you're saying I want my page to fit in a landscape size. But I might have 2+ pages of data that I don't want to squeeze into one page. Therefore, you find how many pages the data needs to span and still fit into a single page (width wise). I hope this was clear. It was a pain in the *** to get this going for me, but it's a clever way to get it to work. Please let me know if you find this helpful. Best Regards, Lior Shliechkorn --- "Marx, Stefan ext. MA Fa. Lynx" <[EMAIL PROTECTED]> wrote: > Hi list-reader, > > fiddling in the area of formatting & printing I ran > into > trouble trying to scale some data to page size. > Using the code like > > [..] > // printing optimized > iSheet.setMargin(HSSFSheet.LeftMargin, 0); > iSheet.setMargin(HSSFSheet.RightMargin, 0); > > HSSFPrintSetup ps = iSheet.getPrintSetup(); > > ps.setLandscape(true); > iSheet.setAutobreaks(true); > ps.setPaperSize(HSSFPrintSetup.A4_PAPERSIZE); > > ps.setFitHeight((short) 1); > ps.setFitWidth((short) 1); > [..] > > print out the lines nicely fitting on the page when > I'm in the situation that there are only one page > to print. But as soon as I have to deal with more > data (page counts in the area of 40 or more) the > setAutobreaks() methode reduces the scaled print > image to a nearly micros-scopic font size and un- > readble lines. > Looking at the sources of 2.0-pre I get the impres- > sion the constellation with many line more than > one paper size width are spoilling the fit to page > functionality. > Before I start in the direction to make my line fit > by adding wrapping and re-design of my sheets and > all the groupping and summation: > > Is there anybody out there who avoid this effect? > > Many greetings from Germany, thx for reading, much > more for writting ;=). > > cu Stefan > > P.S.: I'm using the 2.5.1 final 2004/08/04 version. > -- > Tel: +49-(0)221-149-5953 > Fax: +49-(0)221-149-97-5953 > E-Mail: [EMAIL PROTECTED] > Stefan Marx, M.A. > www.marx-consulting.com > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > Mailing List: > http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: > http://jakarta.apache.org/poi/ > > ______________________________________________________ Click here to donate to the Hurricane Katrina relief effort. http://store.yahoo.com/redcross-donate3/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
