Hi Lior,
thanks a very lot for this helpful hint for setting up a lot my pages. Works within of 10 minutes ... Great! Due to the fact that my customer rated the defect of my HSSF programing Iow I could'nt step deeper into it. And so the printing set up has to be done by the users. With your hint how to correctly process many lines the data appear nicely in a readable manner even for more than 50 pages. ..::Thanks::..! Greetings, cu Stefan > -----Ursprüngliche Nachricht----- > Von: Lior Shliechkorn [SMTP:[EMAIL PROTECTED] > Gesendet am: Sonntag, 11. September 2005 00:00 > An: POI Users List > Betreff: Re: howto print large sheets with fit to page? > > 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/ --------------------------------------------------------------------- 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/
