How do I shrink the margins? That might help a bit. The font size is the smallest.
Danny Mui <[EMAIL PROTECTED]> wrote:The pagebreak is automatic so I don't think you would be able to modify them anyway. You're trying to jam a lot of content into one page: 1) Shrink the margins 2) shrink the font size 3) Set the zoom % so things are smaller. (Adjust to 95% size..keep going lower till it fits..) Lior Shliechkorn wrote: > Brian, > > I tried to do that it wasn't working right either. I want to be able to fit a report > that is 400 pages with 3 columns being cut off so that each page prints correctly > without the remainder columns causing the print job to be 800 pages. > > Once I set the printarea to be from A to N, I can see that there is a bounding box > around that print area, however, I guess I'm trying to make it work more as a page > break(?). How can I modify the page break? > > Thanks, > > Lior > > Brian Glick wrote: > I don't know if you're trying to get the entire width of the spreadsheet > on the page, but if you are, try something like this: > > > //format sheet > HSSFSheet sht = wb.getSheetAt(i); > HSSFPrintSetup pSetup = sht.getPrintSetup(); > sht.setAutobreaks(true); > pSetup.setFitWidth((short) 1); > pSetup.setFitHeight((short) 0); > pSetup.setLandscape(true); > > > Brian Glick > Freightek, Inc. > > -----Original Message----- > From: Lior Shliechkorn [mailto:[EMAIL PROTECTED] > Sent: Sunday, December 28, 2003 12:40 PM > To: POI Users List > Subject: Re: DANNY MUI: Re: Is there a bug in the setPrintArea()? > > I have the page set as landscape actually, which is why I think I'm > getting cut off the way I am. I'm not sure what else I would be able to > do. > > thanks, > > Lior > > Danny Mui wrote: > Actually it gets cut off at I hehe. Switch to landscape and you see the > cutoff change to somewhat larger. We can't print 2 pages worth of stuff > onto 1 page can we? Might be able to squeeze more in by modifying > margins and the such but seems like "it's working as intended". > > i hate that line ;) > > danny > > Lior Shliechkorn wrote: > > >>I can't really include more of a code segement than I already did...=\. > > But the problem I'm having doesn't seem to come from the rows > themselves, which works fine for me as well, but the problem is in the > columns being cut off. > >>I want to print up to column N, but I get cut off at J. >> >>Any ideas, or did this happen to you as well? >> >>Thanks >> >> > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------- > Do you Yahoo!? > Yahoo! Photos - Get your photo on the big screen in Times Square > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------- > Do you Yahoo!? > Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------- Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
