Stefan, My pleasure. I'm glad I could help.
Take care, Lior --- "Marx, Stefan ext. MA Fa. Lynx" <[EMAIL PROTECTED]> wrote: > 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/ > > __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.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/
